It should be theoretically possible. The mysql-server package owns /var/lib/mysql, but it is the mysql_install_db script that sets up an empty database in $datadir when the service starts if $datadir is empty. If you update your config file before you start the mysql server, you should be able to point it at any datadir you like. It will leave an empty directory at /var/lib/mysql, but hopefully you are ok with that as it's owned by an RPM.
I had a quick look at the module, /var/lib/mysql is hard coded in a lot of places and you'd have to override / set most of them as well as in my.cnf: $ grep -R '/var/lib/mysql' * manifests/params.pp: $datadir = '/var/lib/mysql' manifests/params.pp: $socket = '/var/lib/mysql/mysql.sock' manifests/params.pp: $datadir = '/var/lib/mysql' manifests/params.pp: /(SLES|SLED)/ => '/var/lib/mysql/mysql.sock', manifests/params.pp: /(SLES|SLED)/ => '/var/lib/mysql/mysqld.pid', manifests/params.pp: $datadir = '/var/lib/mysql' manifests/params.pp: $datadir = '/var/lib/mysql' manifests/params.pp: $socket = '/var/lib/mysql/mysql.sock' On Wednesday, December 4, 2013 12:30:31 PM UTC, Walter Heck wrote: > > Tried and failed. The problem is that the mysql package automatically uses > /var/lib/mysql, so the right sequence is: > > 1) yum install mysql-server > 2) service mysqld stop > 3) adjust my.cnf > 4) make moves on filesystem if needed > 5) service mysqld start > (steps 2 and 3 can be reversed) > > This is hard to puppetise as it is only needed the very first time when > mysql is not yet installed. I've only ever had to do this on smaller groups > of servers at a time, so always resorted to doing it manually. > > let me know if you figure it out, would be great to see a solution in > puppetlabs-mysql. > > > On Wednesday, 4 December 2013 02:39:50 UTC+1, Thomas wrote: >> >> Has anybody sucessfully used puppetlabs-mysql (or some other method) to >> install MySQL-server on Linux with a my.cnf where datadir != /var/lib/mysql >> ? >> > -- 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/fa6d9246-47c6-407a-a4e5-758cf1621759%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
