
MySQL allows to set up database replication to have bases redundance.
There are many advantages to have replication :
- to carry out server redundance : if a database server crashs, the server in replication can take its place,
- to set up a loadbalancing on requests, for example with ipvsadm.
Replication is not magic, albeit it is easy to do, it brings constraints and complications if there is an important delay. Of course, it's needed to don't write data on a slave to preserve database integrity...
In this article, we will see how to set up replication and how to manage it...