I know this post is old, but I'm just posting this answer as I got similar requirements and struggled a bit to have it implemented. Anyway, following your advise, I was able to automate Mysql Multiple Instance by combining puppetlabs-mysql <https://forge.puppet.com/puppetlabs/mysql> and Docker (garethr/docker) <https://forge.puppet.com/garethr/docker>, That design and implementation is fully documented here <http://stivesso.blogspot.com/2016/12/puppetizing-dockerized-mysql-multi.html> . *The approach I used is following your proposition (leveraging on Containers -Docker-) with HA as added benefit :-).*
On Friday, 17 May 2013 15:29:50 UTC+1, David Schmitt wrote: > > On 17.05.2013 16:12, 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. > > This is a fundamental limitation of all mysql modules I've seen. > Implementing this is quite a big step up from the usual install > package/manage databases setup as it requires configuring the new db > cluster, and passing the port through all other defines. > > > I think the common solution is either kernel or h/w level virtualisation > (e.g. openvz, xen, or kvm) instead of trying to cram multiple db > clusters onto the same base installation. > > > Regards, David > > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/cfea387b-80f5-48aa-9e3a-b0c7d2ef506a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
