Schema Sync

Databases MySQL

Use Replication for backups? Are you schemas consistent?

Ronald Bradford
March 31, 2011

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.