If you as i am using MySQL replication mechanism, master-slave or master-master replication you sometimes loose replication due to duplicate entries.
You can fix it by simply skipping the record:
1. log into MySQL:
mysql -u root -p
2. in MySQL shell stop slave replication
mysql> STOP SLAVE;
3. skip the affected record
mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
4. start slave replication process
mysql> START SLAVE;
5. verify that replication is working:
mysql> SHOW SLAVE STATUS \G
6. exit MySQL shell:
mysql> quit;
Provided by:SiQ systems, Cloud experts
Subscribe to:
Post Comments (Atom)
solving error: Your current user or role does not have access to Kubernetes objects on this EKS cluster.
Trying to access EKS cluster with kubectl you might get an error similar to: Your current user or role does not have access to Kubernetes ob...
-
General Information PGPool can run on same server along with PostgreSQL DB or on stand alone server(recommended). In this article we wil...
-
login to mysql as a root: mysql -uroot -p end execute: mysql> show processlist; will show you list of processes running in MySQL a...
-
Following information is intended for bash shell only. The system variable TMOUT can be set to specify the amount of time the user is ina...
No comments:
Post a Comment