… to use MySQL features which break replication. The failover node is a hot standby, it’s just not a running slave node from… consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how to do it. With DRBD the chance of nodes running out of sync is…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…. A statement based replication slave can get out of sync with the master fairly easily, especially if data is changed on the slave.  It… replication went out of sync? To determine exactly what row is having an issue, we can use the ‘mysqlbinlog’ utility in combination with the slave relay log. Examining the output of SHOW SLAVE STATUS, we can see that the slave is currently executing at relay log file: mysql…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…about MySQL Replication Performance. There are however…Replication. As you probably know MyISAM uses buffered IO so if master crashes you’re out of sync anyway – whatever sync…sync_binlog enabled as slave could have consistent data after it catches up but master may have some of its tables out of sync…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
… do not worry that eventually you get out-of-sync situation, as it regularly happens with regular MySQL replication if you imprudently write to the… it by variable wsrep_slave_threads Second: There might be a small period of time when the slave is out-of-sync from master. This happens…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… get rid of those “slave is out of sync with master” pain-in-the-neck problems. Combining all above, now we can setup distributed replication systems…. with current state of MySQL EC2 setups suffer from lacking a good HA schema. With Galera, we can setup replication with the same… to join me in testing MySQL/Galera 0.8, binaries are available from Launchpad. The downside of MySQL/Galera is that it is…
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
When replication runs out of sync first question you often ask is if someone could be writing to the slave. Of course there is read_only… via replication thread) so you will know offender at once. In many cases however log_slave_updates is enabled which makes slave to… slave id. So to see if we have any queries ran on the slave directly we can do: [root@centos data]# mysqlbinlog mysql…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… could be network (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others. In… with slaves which are a bit out of sync, which is quite often better than having just master available (also having extra load of data…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely for relay logs to run out of sync (they are not synced to the disk) plus position on the master which slave remembers becomes stale. During MySQL 4.0…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the… about making sure things can’t run out of sync silently. For example you might know if slave server reboots (say power goes down…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…out common causes of replication lag Hardware Faults Hardware faults may cause reduced performance causing replication…slave never is able to catch up. MySQL or OS version changesMySQL version changes (even minor upgrade) may introduce issues which causes replication…
