Hello, %username%! My job is a common situation when you need to update the schema of MySQL database used for a particular site and then make the same changes on one or more servers. Of course you also want to save the state of the schema after each incremental update. For some of the tables that store static data is also required to synchronize data in a table. Current solution:
1) to Store the schema in the file format of the MySQL Workbench (*.mwb)
2) After each change to create a new commit in the version control system (Subversion)
3) Use built-in tools MySQL Workbench to synchronize changes (Synchronize Database). Similarly, you can use other software, such as SQLYog, which allows you to synchronize not only the schema but also the data.
This method is not very convenient, because it requires you to sync manually and separately for each table by selecting it in the dialogue. Question: what other ways to perform incremental database schema updates you can offer? Normal replication is not suitable because the connection to the servers is unstable and communication with them can happen over SSH. Required technology updates on-demand, it is also possible using binary logs or dumps.