Read the original article at 5 Ways to fortify MySQL replication
MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master, or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without blocking the master database.
All of these goals can be achieved using some powerful tools. Here’s a quick guide to those tools and how to use them.
- Build new Replicas without Downtime
Something we’re sure you need to do quite often is to build new slaves. You can snapshot from another slave by bringing …[Read more]