MySQL replication health

Tuesday, 09. 30. 2008  –  Category: sw

It’s possible for MySQL’s statement-based replication to get out of sync. I’ve yet to see a real example myself, perhaps because the DB abstraction layers I encounter not creating the “dangerous” queries that can make this happen. Still, other than monitoring replication health with SHOW SLAVE STATUS and friends I’ve sometimes been concerned about whether [...]

Using Single Sign-On To Integrate Ning With An External Site

Wednesday, 08. 20. 2008  –  Category: all, sw, web

Overview
Ning provide off the peg hosted social networks. The service is free unless you pay to not have their context-driven ads on your pages. Within a few minutes of sign-up you’re away.
Particulary cool is that they will let you at the source of your network. You can’t then wander off and run it elsewhere, it [...]

High Availability Rails Cluster

Tuesday, 08. 19. 2008  –  Category: all, sw, web

I’ve been asked about this a few times, so I figured I’d post here. This is a brief description of a highly available Rails cluster I’ve built. Some preliminaries:

There’s no invention here, I believe this setup is very common.
High availability isn’t the same thing as load balanced. There is nothing here to intelligently shared load [...]

« Older Entries