… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific…:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db… lot of “bad file descriptor” errors. I was able to get the server up with –skip-grant-tables and insert a few…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER… any easy way to skip a single transaction? There is! Injecting empty transactions. Let’s imagine that the replication in slave server is not working because of an error: Last_SQL_Error: Error ‘Duplicate entry ’4′ for…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR…replication-related configuration: mysql> stop slave; Query OK, 0 rows affected (0,00 sec) mysql…
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: 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: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… down MySQL crashes etc. If you however are using MEMORY table in replication and just want to do a restart without replication breaking… you may not want these changes to be replicated. What could have done better ? MySQL could have features to make it more… similar to skip-slave-errors but specified on per-table basics. This would allow me to simply allow to avoid all replication errors for…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… the MySQL Error log file. The error message describes few reasons and indeed because there is little validation (ie no checksums) in the replication… recover “corrupted” event to be manually executed on the slaves. Skipping around event makes master and slave potentially inconsistent and you…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…having only 1 mysql server, no replication setup) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql server-id=1 #replicate-same-…user = replication #master-password = rplpassword #master-port = 3306 #innodb_flush_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 …
Comment: The story of one MySQL Upgrade
October 24, 2010 By 8 Comments
… does it cause an error in the slave? â‘¡I check the mysql document,the option name is slave-skip-errors both in 5.1 and 5.0 â‘¢according to mysql test,”To do this we set up replication from…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… ON DUPLICATE KEY UPDATE had a unfair share of replication issues in MySQL 5.0. There are number of ways the problem… see how broad is it. We let Slave to replicate with skip-slave-errors=1105 to see if we get any other problems… set up replication from Percona Server 5.1 back to MySQL 5.0 and performed the same checks again – happily replication worked and…
