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 puppet-users+unsubscr...@googlegroups.com. 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.
