Is this possible without having to dump to all other slaves at the same time?
Basically I would create a blank database with the 'create database' function on the master and slave. Then I would setup the replication of the DB.
I would then do a dump on the master.. would all the inserts during the dump be replicated to the slave?
I am trying to perform a backup of my /home directory using crontab
When I run my dump command in the terminal it works fine but when I try to run it using crontab it does not want to work. I work on a CentOS
This is my command to run dump using crontab. It is suppose to run once a week, Friday at 8pm
I am running a AWS RDS large instance for the production. I am taking mysql every mid nite. But the thing is its taking too long to take the mysql dump and also the website will stop responding during the mysql dump process. What I am planning to do is, instead of taking the mysql dump, any how I am taking DB snapshot every day.