Question : What is the impact of MySQL compressed-slave-protocol on replication traffic? According to High performance MySQL it can lower […]
Category: Replication
Why isn’t mixed-mode replication default on MySQL
Question : It is well known that mixed-mode replication was default from MySQL 5.1.12 to MySQL 5.1.28. However, this was […]
Maatkit shows the MySQL replication error in one table, but won’t fix it
Question : We use MySQL 5.1 with a primary/secondary replication setup. I use mk-table-checksum from Maatkit to generate checksums on […]
Monitoring replication on mysql
Question : I have managed to setup master and slave replication. It is working fine. What are the possibilities that […]
INSTALL PLUGIN ‘rpl_semi_sync_master’ SONAME ‘semisync_master.so’ not working
Question : I’m trying to install semi synchronous replication in my mysql 5.5 and trying to execute the below command: […]
Some MySQL slave errors?
Question : Master version: mysql-server-5.5.14-1.el5.remi Slave version: Percona-XtraDB-Cluster-server-5.5.24-23.6.340 Binlog format: ROW based I’m using PRM to setup HA for MySQL. […]
Synchronize two MySQL databases between two servers
Question : Is there any way to connect a database on two servers inside a trigger? I have 2 databases […]
Mongo DB – reading during update
Question : Is it possible in a three-member-replica set (1 primary, 2 secondaries) to update records on the primary, or […]
Generating Error when data size is larger then max text repl size
Question : I recently ran into an issue with where an application tried to do an insert with data over […]
MariaDB/MySQL backup replication
Question : I have currently two DB instanced with two-way replication. Each replicates other database. So both are master and […]