Pushing MySql Schema changes to multiple Database Servers

MRS
MRS used Ask the Experts™
on
Hey,

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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
Obviously there are many tools that could do the same thing however one of them you could use for this purpose is "Octopus Tentacles" that we use to deploy to SQL, MySQL, Postgres and ORACLE database servers and you could read/download it from here: "Download Octopus Deploy self-hosted" https://octopus.com/downloads
MRS

Author

Commented:
Icohan,

That is exactly the kind of product I am looking for, but the databases will not be cloud hosted.  Are you aware of any on premise products like this?
David FavorFractional CTO
Distinguished Expert 2018

Commented:
Dirt simple way to accomplish this.

1) Do service mysql stop on all instances.

2) rsync -av --delete /var/lib/mysql/. from master to all slaves/spares.

3) service mysql start on all instances.

This will create a short outage works 100% of the time.
Database Analyst
Commented:
If David's answer is not sufficient for you and you want to use the tool then please read here: https://octopus.com/docs/getting-started about setting up Octopus "with your own self-hosted or cloud-hosted Octopus Server"

One mention is that I'm not related in any way to "Octopu" and it is only coincidence and good experience we had with it internally by using our own self-hosted Server that I mentioned it to you. Of course sometimes easy/free solutions like the one David mentioned may be preferred over an expensive 2rd party tool.
MRS

Author

Commented:
Thanks to both of you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial