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 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.
# dump -0auL -f /media/Main/Backups/ubuntu_fs_root.dump /dev/sda7
DUMP: You can't update the dumpdates file when dumping a subdirectory
DUMP: The ENTIRE dump is aborted.
Google says that mean that I try save dump file on filesystem that I backuping - but it is not so: