[Puppet Users] Re: MySQL server install with datadir != /var/lib/mysql

2013-12-04 Thread Walter Heck
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

[Puppet Users] Re: MySQL server install with datadir != /var/lib/mysql

2013-12-04 Thread Luke Bigum
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

[Puppet Users] Re: MySQL server install with datadir != /var/lib/mysql

2013-12-04 Thread Thomas
Yes that is what I was thinking as well. Unfortunately I don't believe yum will permit me to specify --noscripts so I can avoid mysql_install_db from running. On Wednesday, December 4, 2013 7:30:31 AM UTC-5, Walter Heck wrote: Tried and failed. The problem is that the mysql package

Re: [Puppet Users] Re: MySQL server install with datadir != /var/lib/mysql

2013-12-04 Thread Thomas
I agree and was thinking along those lines as well. For those interested vicinus (on github) https://github.com/vicinus has started this and has it working on Ubuntu. See https://github.com/puppetlabs/puppetlabs-mysql/issues/380 for