I am building an application that will run on multiple instances of the same Mysql schema. Same database schema, different data in each. The goal is to keep each clients data in separate instances of the same database. I have designed my model in MySQL Workbench and have been using the "Synchronize Model" function and that works OK, but i have to specifically push the changes to each instance of the DB. As this grows that will become unmanageable.
Is anyone aware of any database management tools that will allow me to push schema changes to multiple instances simultaneously? Again, this is not replication as the data in each DB is different, i am looking for a way to push Schema changes only.
Thanks in advance.