How do manage running queries across multiple DB servers?

Hello,

Currently, at my workplace, we have multiple MySQL instances running where
they have databases for certain functions. During a deploy, we need to
manually SSH into the server and run these queries (stored as SQL files,
about 10~25 lines long queries that make table/field changes) manually
using the source command.

The entire process is very error-prone and time-consuming, to say the
least. While we have some tools written in house, I was exploring other
options of maybe using Puppet to store the queries in a new "deploy module"
and have these deployed but I like to hear from the team on suggested
methods.

I'm new to the world of database administration and any comments are
greatly welcomed.

Thank you,
Robert

-- 
Robert Freiberger
510-936-1210

_______________________________________________
svlug mailing list
[email protected]
http://lists.svlug.org/lists/listinfo/svlug