… 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: 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: 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: 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: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… slaves you can skip replicating it specifying replicate-ignore-table=db.memory_table. Note you should not be using STATEMENT level replication with INSERT… 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: 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…
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 to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
… following to resume replication: replica> CALL mysql.rds_skip_repl_error; master> DROP DATABASE percona; Note: If you are running an earlier MySQL version and it does not have the rds_skip_repl_error procedure, you can try removing the conflicting record from replication slave and replication…
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
…-db=mysql,test #replicate_do_db=crmdb #replicate_do_db=newcrmdb #auto-increment-increment = 3 #auto-increment-offset = 1 #log-slave-updates skip_name…-user = replication #master-password = rplpassword #master-port = 3306 #innodb_flush_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb max_connections = 600 #thread_stack= 150M key…
