Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Normally we can skip 1062 duplicate error but in rds can we skip multiple 1062 errors in one go.
For example we define slave skip error =1062 in my.cnf and restart slave. but in RDS MYSQL how can we permanently skip 1062 error, alteast for few hours as we have duplicate data in the restore file and unfortunately log position we have is old.
If you cannot use the RDS CLI, set proper DB Parameters or other means to set slave-skip-errors=1062, you are better off just creating a read replica to make a new Slave from the Master then dropping the old Slave that had the 1062 error.
I have mentioned MySQL RDS Read Replicas in the past
May 21, 2013 : Best strategies to have a backup of an RDS MySQL databaseJul 25, 2012 : Scaling Percona datacenters: setup and replicationAfter creating read replica, you should make sure you are using INSERT IGNORE or INSERT ... ON DUPLICATE KEY commands on the Master to prevent duplicate keys from replicating to Slaves.
SHOW SLAVE STATUS) Focus on fixing the code to avoid 1062s.