Setting MySQL chain replication

MySQL replication allows you to set in quite easy way “infinite” chain of replication. Which can be very useful in some cases. Especially if you need to make bigger changes in architecture without downtime. We used this A->B->C replication chain for...

Switch the binlog format at runtime

Sources: https://dba.stackexchange.com/questions/6150/what-is-the-safest-way-to-switch-the-binlog-format-at-runtime https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html https://www.percona.com/blog/2009/05/14/why-mysqls-binlog-do-db-option-is-dangerous/...