puppetlabs-mysql and Percona

[Jochen Haeberle]

Hi,

the module puppetlabs-mysql on the forge is tagged with percona, but I don't see a way to have the module install a Percona-Server. The module has providers for MySQL and MariaDB, but not Percona.

I tried working with puppetlabs-mysql, installing Percona with a package-resource ending with Percona-Server and MySQL beeing constantly installed and deinstalled.

What does everybody else use to manage a Percona-Server?

Thanks in advance

Jochen

[Anthony Martinet]

Hi there,

I have the same issue here.

Still digging on how to make this work, so far when using package_name => 'percona-xtradb-cluster-server-5.5' I have an error.

Next step for me is digging into the autogenerated my.cnf ...

Any feedback would be appreciated :)

Anthony

[Anthony Martinet]

Problem solved with a 

manage_config_file      => false

Which mean the problem was indeed in the auto-generated my.cnf

:)

[Walter Heck]

Setting up percona server with puppet is a matter of changing the package_name. Your package name however suggests you're trying to set up galera cluster which is a very different beast altogether. For that, we have created (and use) a galera module that works in conjunction with puppetlabs-mysql: https://github.com/olindata/puppet-galera

I have created a detailed blog post for setting up galera with puppet here: http://www.olindata.com/blog/2014/04/managing-percona-xtradb-cluster-puppet

The github repo that uses is a full fledged puppet demo environment found here: https://github.com/olindata/olindata-galera-puppet-demo

Hope this helps.

cheers.