err_code2 - Eduguru

mysql master - slave replication

MySQL Skip Duplicate Replication Errors : skip replication error

October 13, 2014October 13, 2014 eduguru 2 Comments 'ALL', and from here we have: _ Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY) Message: Duplicate entry ‘%s’ for key %d_ You can skip also other type of errors, and keep the data consistent with the mater that has sent the query. You can skip such errors, as long as you know really well what are those queries and why they are failing, but again don’t do this unless you understand very well what those queries are and what impact they have on your data: slave-skip-errors=[err_code1, err_code2, etc. For example you can skip just one query that is hanging the slave using: mysql>SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; There might be cases where you will want to skip more queries. , even if this is not recommended, MySQL Skip Duplicate Replication Errors : skip replication error, Normally MySQL replication will stop whenever there is an error running a query on the slave. This happens in order for us to be able to identify the problem and fix it, you would add to your my.cnf: slave-skip-errors = 1062 As shown above in my example 1062 is the error you would want to skip

Normally MySQL replication will stop whenever there is an error running a query on the slave. This happens in order for us