… to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n for a simple reason, it doesn’t work anymore if you are using MySQL GTID. Then the… the one that is causing the problems. Since SQL_SLAVE_SKIP_COUNTER doesn’t work with GTID we need to find a…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them. An infinite replication loop is… have a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, you define the global variable server_id… loop, you can try to skip the statements by stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave again…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… as original file system Why snapshot based MySQL backups are great ? There are number of …pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified process you can clone … – especially if you use slave_skip_errors or sql_slave_skip_counter. Cloning master you’re starting …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…Percona Software Repositories). Based on MySQL 5.1.66, including all…(Mark Callaghan, Laurynas Biveinis). Crash-resistant replication would break with binlog XA … the changed row and userstat counters. Bug fixed #1064333 (Laurynas Biveinis)…. though it is sufficient to skip just one (e.g. the first…
Comment: Implementing efficient counters with MySQL
July 2, 2007 By 16 Comments
…fine. However as we’re speaking about semi-realtime counters just access logs are not enough this is …total you may want to do an update as skipping it would be too visible, while if the …replication. I’m not sure why you’re speaking about contention which is fixed by MySQL 5.1 row level replication….
