No PowerDNS replication taking place and in “show slave status \G;” command in mysql, the errors were noted:

Last_SQL_Errno: 1062
Last_SQL_Error: Error……

To resolve this, set the SQL_Slave_Skip_Counter to 1 in mysql with the following command. First log into the PowerDNS server using SSH.

Stop Slave;
Set Global SQL_Slave_Skip_Counter = 1 ; 
Start Slave;
Show Slave Status \G;

Is the Error is still present, try running the command again and increment the value from 1 to 2 and so on. If you’re tired of the trial and error test, try putting in 100 or a larger number.

admin has written 39 articles