Hi,
We do this, unfortunately none of our code is clean enough to release. It's
used to run replication slaves of several different masters on a single box.
In short we have a base mysql class that installs required packages,
disables the default service instance and makes other global-level changes
(noop io scheduler, helper scripts, etc). Then we define a new type:
define roles::db_mysql_instance($role, $application, $id = '1', $port =
'3306', ...) { ... }
In the type we include our base class and roll out everything that needs to
be per-instance with per-instance names:
- mysql-$name service
- /etc/mysql-$name + templated configs
- /var/log/mysql-$name, /run/mysql-$name, /etc/init/mysql-$name
- Log rotation, SSL key, backup scripts, etc etc
Our base class and role definition are pretty short, ~500 lines, comprising
~50 individual resources (mostly file).
It all works fine. Been in use for a little over a year. Right now we're
moving from physical hardware to the cloud so this will probably be
deprecated as part of the migration. I think it only makes sense for
non-virtualised physical hardware.
Alex
On Sat, May 18, 2013 at 12:12 AM, Peter Krawetzky <[email protected]>wrote:
> Was wondering if someone has implemented the management of multiple MySQL
> instances using puppet on the same server? Essentially we want to use the
> same MySQL binaries but implement multiple distinct MySQL instances
> connecting via a specific port number. Puppet Forge has a great MySQL
> implementation including databases, users and permissions but it doesn't
> seem to allow for managing multiple instances.
>
> Any information would be greatly appreciated.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Puppet Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/puppet-users?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
