-
Mysql replication troublshooting
•
${toc} to achieve the best result in troubleshooting it is highly recommended to install percona toolkit it contains tool that will help resolve replication error Coordinator stopped because there were error(s) in the worker(s). when we use the command show replica status\G we found The error message you received indicates that there was a…
-
Using percona xtrabackup for backup
•
taking backup percona xtrabackup is consider a hot backup that backup the whole data directory with its redo logs and also it will take backup of the my.cnf to take backup we have already setup directory for backup mkidr backup to take the backup we will use the below command which will also compress…