how I can configure the mysql module to allow me to run multiple instances of MySQL server on the same node

edit

Hi,

I got similar requirements and also came to the conclusion that it wasn't supported in official puppet module, but there's a way to do that (and even more) by combining puppetlabs-mysql and Docker (garethr/docker). This has been well documented here.

This is currently not supported(, or even envisioned) in the puppetlabs-mysql module

Multi Mysql installs are usually complicated and bespoke per system, distro, and Mysql version. If you wanted to attempt to add your own implementation it might looks like this.

modules/multimysql/manifests/init.pp

class multimysql {

   include ::mysql
}

modules/multimysql/manifests/server.pp

define multimysql::server (
  $rootdir =
) {

  file { "$rootdir": ensure => directory, }
  file { "${rootdir}/etc": ensure => directory, }
  file { "${rootdir}/var": ensure => directory, }

  file { "${rootdir}/etc/my.cnf":
    ensure => file,
    content => template('multimysql/my.cnf.erb')
  }

  file { "/etc/init.d/mysqld-${name}":
    ensure => file,
    content => template('multimysql/my.init.erb')
  }

  service { "mysqld-${name}":
    enable => true,
    ensure => running,
  }
}

This is obviously incomplete and missing a few important parts like initializing the data dir, but might get you started.

Interesting!

I would review the logic of some of the developers who have written tomcat modules to create multiple instances on one server. This may shed some insight as to how you may want to structure your mysql modules. I never attempted this for mysql. I had only small glitches with this process in tomcat.

Good luck with this.... sorry I am not much help.

-Glynn