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:
Provided by:SiQ systems, Cloud experts
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...
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...
How to install PGPool II on PostgreSQL Servers in master-slave architecture + PGPoolAdmin web managmentGeneral Information PGPool can run on same server along with PostgreSQL DB or on stand alone server(recommended). In this article we wil...
Simple VPN server configuration for easy VPN access to AWS using built in Windows VPN client. First to install pptp server package. s...