MySQL Replication is one of the most used and valued features of the MySQL Server.
Unlike some other products on the market, it’s out-of-the-box, easy to configure, non-paid and smart features.
Most of our medium/large/super-large installation base are using replication to achieve “scale-out” scaling. Some will use it for backup purposes (not as HA though) and some will use it for geographic redundancy.
In this article I won’t discuss replication as there are hundreds of posts out there on how and what replication can do for you.
Rather, I would like to discuss our new extension to the good old replication mechanism: Semi-Synchronous Replication.