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

Resync a double replicated MySQL Database

Resync a double replicated MySQL Database

Certain scenarios need a master database replicated to multiple slaves instead of just one. If you have a very heavy read application you might benefit from a number of slaves. It also provides a sort of double backup if one slave drifts away from the data it’s supposed to have. Double replication also allows you to test a backup system. I have a separate article dedicated to that. With a double replication you’ll have a setup like...

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