… the slave, as described in the MySQL manual. You can configure the slave…ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql…” errors. I was able to get the server up with –skip-grant…
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 = n for a simple reason, it doesn’t work anymore if you are using MySQL GTID. Then…’s imagine that the replication in slave server is not working because of an error: Last_SQL_Error: Error ‘Duplicate entry ’4′ for key…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… you run START SLAVE (or if it’s done automatically, for instance when restarting the server without the skip-slave-start option), replication… sec) 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 1200 (HY000…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…slave_load_tmpdirblogpercona.commanual slave_net_timeoutblogpercona.commanual Slave_open_temp_tablesblogpercona.commanual Slave_received_heartbeatsblogpercona.commanual Slave_retried_transactionsblogpercona.commanual Slave_runningblogpercona.commanual slave_skip_errorsblogpercona.commanual slave…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server to continue, …- cloning 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_counter. …
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… SLAVE STATUS’ on this slave. This is relay relay log corruption and you can check details in the MySQL Error log file. The error message…” event to be manually executed on the slaves. Skipping around event makes master and slave potentially inconsistent and you should access the risks…
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
… 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…
Comment: The story of one MySQL Upgrade
October 24, 2010 By 8 Comments
… in slave and master,but 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… Server 5.1 back to MySQL 5.0″,when I set up this,start slave,it report errors,said ‘log as be corrupt…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… is mysql configuration (We are having only 1 mysql server, no replication setup) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql…_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb max_connections = 600 #thread_stack= 150M key…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
…. To discover the difference between Master and Slave you can use excellent Maatkit tool though …the table. In the applications which are error tolerant (like handle errors properly) you may rename table ….01 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep_old…
