FAQ
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 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+unsubscribe@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+unsubscribe@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.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 6 | next ›
Discussion Overview
grouppuppet-users @
categoriespuppet
postedMay 17, '13 at 2:14p
activeJul 2, '13 at 10:03p
posts6
users5
websitepuppetlabs.com

People

Translate

site design / logo © 2022 Grokbase