Many people have a master/slave MySQL environment of various
different topologies, and many use the slave as a backup.
Is your slave schema identical to your production schema? As long as an SQL statements completes without an error, your slave schema can differ. Common examples are different indexes or storage engines for example. However if you use the slave as backup, you want to ensure when you recover, you are recovering a production environment, not a slave environment.
While the changes may be small, the can lead to different results. For a client I found that the default value of a price field was 10.00 in one …[Read more...]