Replication setup

Thanks Arjen, my first replicating setup is now working.

After the replication workshop I decided having a local slave would be a much better idea than nightly remote mysqldump backups followed by rsync.

Not only can I develop queries on actual data locally now, the nightly automated data transfer has been reduced substantially as well.

Comments

arjen:

Why not do both? That is, also do a (local) mysqldump backup. If you have an InnoDB-only setup, it even lock-free!