Introduction :
In MySQL the replication is logical. And the DB changes were written to mysqlbinlog. This mysqlbinlog is pulled (IO Thread) and applied ( SQL Thread) by the slave servers. Binlog is the key for MySQL Replication.
Binary logging format is of three types.
- Statement
- ROW
- Mixed
ROW based replication benefits the smaller writes ( OLTP ) work load. The events are logged based on how individual table rows are affected. Primary key and Unique keys on tables benefits the efficient writes.
Major Drawbacks in Row Based Replication ( RBR ):
MySQL Binlog troubleshooting becomes harder at times when you have ROW/Mixed binlog formats.
ROW format is claimed to be a better Binlog Format for data consistency and scalability. But ROW based replication tends to have a couple of drawbacks when it was …
[Read more]