Settings for parallel replication workers

We currently (2018/04) run several MySQL 5.7.25 replicas with parallel replication workers. Over time there were huge changes in load on replicas so I had to adjust settings several times to keep up with changes and correct always newly occurring replication lags. So...

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/...