We want to sync 2 mysql servers with eachother (products & qa system). We would like to sync all databases, data and users of the production machine to a secondary mysql machine.
What would be the easiest and best way to do this automatically? Synchronization can but doesn't have to be done instantly. We are ok with sync every 12 hours or so, although faster is better. Ease of setup and maintenance is more important than speed for us.
We run mysql 5 on a Centos 5 machine