How to sync table schema?


Form what I read on pt-table-sync documentation, it is not possible to sync table structure from server1 db.table to server2 db.table? Are there any work-arounds or alternatives to sync the table structure?


Table schema is stored in INFORMATION_SCHEMA. You may have a home-grown script to query and compare the schema. Related tables are: tables, columns, key_column_usage, also triggers, routines, views if used.

Along with that one other option is mysqldbcompare from MySQL utilities. Check documentation here