By FindMyBus
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?
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!
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.