…MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL…slave from the slave also clones inconsistences in data which slave could have accomulated – especially if you use slave_skip_errors or sql_slave_skip…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…, you can try to skip the statements by stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave again. This method is… Server 3 is a normal slave Step1 Stop the replication on the active master (server 1): mysql> stop slave; Step 2: there are writes… binary-log of mysql 4 and the master position is increased… Step 6: the slave position on the active master (mysql 1) is changed…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… VirtualBox). The goal is to give step by step instructions, so the setup process is …mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep_slave…] WSREP: wsrep_notify_cmd is not defined, skipping notification. 120619 13:20:19 [Note] WSREP…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…mysql_fix_privilege_tables to ensure all new privileges are added, which is something I frequently see forgotten Next step is setup MySQL…how broad is it. We let Slave to replicate with skip-slave-errors=1105 to see if we …simply to hook up old MySQL 5.0 and all it slaves as a slave off new master and…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…the next step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it is skipped….MySQL replication is an asynchronous process and although it is fairly fast at transferring data between the master and the slaves…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… Cache” which is quite helpful for MySQL Performance optimization tasks but there are… served from query cache, query parsing step is saved. Queries must be …with query lookup in cache if not – skips it. Does not support prepared … not distributed If you have 10 slaves and use query cache on all…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
…step when upgrading your servers. pt-upgrade This tool lets you test your SELECT queries against multiple MySQL…is consistent across the master and the slave with pt-table-checksum. Capture your production … this to 100 queries only # –no-report simply skips the overhead pt-query-digest had to …
