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 <pkrawet...@gmail.com>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 puppet-users+unsubscr...@googlegroups.com.
> To post to this group, send email to puppet-users@googlegroups.com.
> 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 puppet-users+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
