MySQL incremental schema updates?

Question

MySQL

Hello %username%! In my work, there is often a situation when it is necessary to update the schema of the MySQL database used in the operation of a particular site, and then make similar changes on one or more servers. Naturally, it is also required to save the schema states after each incremental update. For some tables that store static data, you also need to synchronize the data of the entire table. Current solution:
1) Store schema in MySQL Workbench format file (*.mwb)
2) After each change, create a new commit in version control system (Subversion)
3) Use the built-in MySQL Workbench tools to synchronize changes (Synchronize Database). Similarly, you can use other software, like SQLYog, which allows you to synchronize not only the schema, but also the data.
This method is not very convenient, since it is required to synchronize manually and separately for each table by selecting it in the dialog. Q: What other ways can you suggest to perform incremental database schema updates? Regular replication is not suitable, since the connection to the servers is not permanent and communication with them can occur via SSH. What is required is the on-demand update technology, possibly also using binary logs or dumps.

Answer 1

There is no magic way to synchronize circuits yet. Check out liquibase.org/

Answer 2

Perhaps you will find something useful in these articles:
habrahabr.ru/blogs/php/90052/
habrahabr.ru/blogs/net/129242/
habrahabr.ru/blogs/sql/121265/