Thread: Shell script to stop start mysql and do the mysql dump and rsync.

Guys i need help to create a script for my mysql databases that uses two way replication. I wanted to have a script that will automatically stop the databases from serverA then do a mysqldump then do an rsync to serverB and stops the mysql on serverb then load the mysqldump then restart the mysql service both severA nd B. Sorry guys but i'm, not good in scripting. i need the best help that i can get from you guys. Thank you and appreciate it.

mysql has commands to perform the functions you need, just add them to the script along with the proper authentication.

On the remote server either copy the script over and use ssh to run the script or put it in crontabs on either or both servers.

Best bet, add a mysql user to each server who can run the scripts. Add the scripts to each server's crontab or "at" if you can't write to crontab. Make sure the mysql user has an .ssh directory on both servers and no password (for unattended execution of the script). Copy each .ssh/public_key to the opposite server and ssh should work both ways.

Bill