Hi,
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?
Thanks
Hi,
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?
Thanks
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 [url]http://dev.mysql.com/doc/mysql-utilities/1.3/en/mysqldbcompare.html[/url]
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.