Scale With Maxscale – Part 3 (Replication)

This blog post is continuation of series of blog post on Maxscale, Part-1 which provides detailed introductory to Maxscale, Part-2 deals about the operation and administration of Maxscale. In this we will discusses, How Maxscale can be efficiently used for read scaling with mysql replication (Master – Slave). Replication is a great feature which is … More Scale With Maxscale – Part 3 (Replication)

Read MySQL Binlogs better with rows query log events

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 … More Read MySQL Binlogs better with rows query log events