Performing remote MySQL actions
I am setting up an application host which connects to a remote MySQL database. As part of this host's configuration, a large number of MySQL actions (i.e., grants, inserts etc) need to be performed against this remote host.
Is there a convention on how this should occur? I understand that Puppet configuration is on a per host basis, but this doesn't really fit our environment as it stands at the moment. It would be far easier and more logical if all host based dependencies could be performed as part of that host's configuration.
In other words, instead of adding the MySQL actions as part of the database server manifest, is there an accepted way to perform this from the application host?