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?
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.