Replication enables data from one MySQL server to be replicated on one or more other MySQL servers. Replication is mostly used as scale-out solution. In such a solution, all writes and updates take place on the master server, while reads take place on one or more slaves. This model is actually known as master-slave replication and this is the kind of replication that I will be setting up in this post.
Recently I had an interesting issue crop up. Due to an
unfortunate migration incident in which involved master/master
replication and not checking to see if replication was caught up,
we ended up with an infinite replication loop of a number of SQL
awk helped immensely in the aftermath
The basics of the replication infinite loop were (more…)