Tools for managing lots of database servers

I have a growing number of MySQL database servers and am starting to struggle managing them all.

If for example I have updated a schematic (where the previous schematic exists and is in use on all the existing servers) are there any tools that would allow me to bulk update/insert the new database to all my database servers at once?

I’m sure I’m missing something here. I’ve heard of the likes of Ansible, Chef, Puppet for managing lots of servers but is there anything out there for databases like my example?

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

I’m not sure if this applies to your use case, but there is support for db replication and sharding with MySQL/MariaDB. Those capabilities have an upfront cost (you need time to properly setup), but have a long term savings on the time you would spend synching your databases manually.

If you want a station-by-station manual upgrade because your databases/tables are being treated like a warehouse (it’s write by you and read by everybody else), then you could use phpMyAdmin to export your database or tables to a file and distribute to each station to import them. You could also do the export/import using a script (like @sierracircle) using the mysql command line tools.