Replication with MySQL
On a somewhat large system, where multiple machines co-exist and interact, replication plays an important role in order to achieve fiability, performance and availability.
Replication is commonly used on databases where information is critical. And since I’ve been talking a lot about MySQL, why not a tutorial on how to set up database replication with it? Remember though that replication is NOT a backup system. Acts like a mirror — deleted on server 1 it will also delete on every other servers.
There’s no problem with concurrency since this is a one-way replication, ie, from the master to the slaves and not the other way around. Which means that the replicas can not be used for load balancing (except if you only need them for reading.. quite restrictive though). But this saves us from concerning about concurrency and consistency :-)
No Responses to “Replication with MySQL”