Testing a replicated backup system

Testing a replicated backup system

If you have a high need for availability for a production application, but don’t have the money to invest in full fault tolerance networking, machinery, and access, you’ll need to have some sort of realtime backup system in place should your primary environment go down. This poses the issue of how do you keep one system on standbye, but be sure that it’s ready to go at all times. The image below shows one possible setup. The...

Read More

Mysql Replication Issues and Errors

Everywhere I look I see articles about how easy it is to set up replication in MySQL.  I will admit that it’s easy, but at what cost?  I am not comfortable enough with MySQL’s replication to just set it and forget it.  It’s been difficult to keep things synchronized between the master and slave. As I work this out, I’ll be adding links and comments to this post.  There’s alot of good material out there, and...

Read More