… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users…have log_slave_updates enabled on the cluster node acting as async slave for replicated events from the async master to …to achieve better consistency, if you have an async master <= 5.0 though, you can workaround this by turning …
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication …1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang…free. Release notes for Percona XtraDB Cluster 5.5.30-23.7.4 are available …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1… the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by not…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
MySQL 5.6 is GA! Now we have new things to play … need to know in which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID numbers… take a backup from the master and restore it on the slave to set up a new replication server. master > show global variables like…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… just posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good… my opinion. Syncing master info every 10000 events is no better than not syncing it at all as replication will be badly out of sync if slave is to crash. The recommendation to use master_info_repository=table…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
….mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc/refman/5.1/en/change-master-to.html [5…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…_Master_Log_File and Exec_Master_Log_Pos from SHOW SLAVE STATUS slave1 [localhost] {msandbox} ((none)) > change master to master_log_file=’mysql-bin.000001′, master…last byte read from ‘./mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL 5.6 will ensure …
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the… an active master/slave connection check. And here is where replication‘s heartbeat can help us. This feature was introduce in 5.5 as another…
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
… replication slave. Is useful not only for disaster recovery but also to test how our application deal with lagged replication. With MySQL 5.6 this technique will be included natively: http://dev.mysql.com/doc/refman/5.6/en/replication-delayed.html CHANGE MASTER TO MASTER…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… changes, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even… not possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication stream correctly. If…
