MySQL master master replication, also known as "mysql chained replication", "multi master replication or "mysql daisy chaining replication" is an extension of mysql replication allowing the creation of multiple master servers that can then be masters of multiple slaves. In this post, I demonstrate how to setup mysql master master replication. In a multi master mysql … [Read more...] about How to Setup MySQL Master Master Replication
MySQL Replication Events – Statement versus Row-Based Formats
In a recent post, I briefly touched upon mysql replication events. It is important to know the advantages and disadvantages of each type. There are two types of replication event: Statement based – these are the write operations. They written to the binary log as SQL statements. Row based – these are the row changes and they are written to the binary log as … [Read more...] about MySQL Replication Events – Statement versus Row-Based Formats
What is MySQL Replication and How Does It Work?
MySQL replication, a.k.a MySQL database replication provides the facility to make replicas of databases. The ability to make exact copies of databases and keep them in real-time sync as changes are made at the "master" provides a number of advantages. In summary these are: Scaling out a database application Reducing database backup impact Facilitate reporting … [Read more...] about What is MySQL Replication and How Does It Work?