my database size is very big around 100gb and when I restore it takes 3 days to restore. I am using amazon ec2.
My question is I want to setup a new slave to MYSQL master, can I take a snapshot of the Master and create a new instance using the snapshot and then enable replication in between.Given that I take log position before the snapshot and
my.cnf changes as required. Snapshot is very fast and takes 1-2hours to create a new machine, whereas
mysqldump is taking very very long.
I was just worried if replication works using above method, can anyone help please.