Question : I have a master-slave set-up with multiple slaves in different datacenters. One of the slaves stopped working normally […]
Tag: master-slave-replication
What is the maximum latency / distance mysql replication can tolerate without having errors or wrong data?
Question : I have two machines in a master – slave replication. I want to know if they are in […]
Setting connection collation in master for slave replication
Question : I am trying to replicate a MySQL 8 server (master) to MySQL 5.7 (slave) instance. I know it […]
Fix mysql replication crashed due to underlying storage corruption
Question : we have critical database server running on two virtual machines. one virtual machine crashed due to underlying storage […]
replicate-wild-do-table=channel_name:db_name.% doesn’t work in MySQL 8.0 for channel based replication
Question : I am trying to configure a replication topology where there will be one slave which will connect to […]
MariaDB slave replication stopped after slave upgrade to 10.1.41
Question : After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay […]
When queries start executing on standby server the replay lag starts to increase
Question : I have a two servers with following specs: 8 vCPU, 32768 MB RAM, 640 GB SSD The master […]
Row-row based logging in a blackhole replication filter setup?
Question : I am using two MySQL server instances on the same server to filter replication to a third external […]
Howto reliably ship WAL log files between master and slave
Question : I have a replication master and a slave on two different computers. Actually both databases are running in […]
Why has deadlock behaviour changed between MariaDB 10.1.22 and 10.2.14?
Question : Since upgrading MariaDB 10.1.22 to 10.2.14 our MariaDB slaves are encountering deadlocks that are not handled in less […]