bmildren/percona_mysql

ansible role for Percona Server

percona_mysql's Issues

role Installation in Mac 10.11

$ ansible-galaxy install ben.mildren.percona_mysql command returns the following error
error: you do not have permission to modify files in /etc/ansible/roles/ben.mildren.percona_mysql

If it download everything locally and don't try to write into /etc/ansible it wouldn't create this issue.

Fix Query Response Time option

PS 5.6 changes this from an option to a plugin therefore it needs special handling.

innodb buffer pool size

Curious to why you use 25% of system memory for buffer pool.
"{{ ( ansible_memtotal_mb / 4 ) | int }}"

I typically use 80% (since its dedicated mysql) and use:
{{ (ansible_memtotal_mb * 0.8) | int }}M

I am super new to Ansible. Thank you for the awesome role.

Contradictory Default

In https://github.com/bmildren/percona_mysql/blob/master/defaults/main.yml#L17-L22 the default is set to false, but the comment says that to override the default, set it to false. I'm confused whether by default it will upgrade...

Role vars precedence?

First of all, thanks for the role, it is well written and covering a lot. But I'm a bit confused with your variable handling. In my opinion, my.cnf is highly configurable for mysql users. Why did you put the variables of my.cnf in role's vars directory? It is hard to override (&merge) them.

I generally use group_vars and host_vars to write my custom values, and the vars in percona_mysql role always have precedence over my values. Do i have to override them with --extra vars ? What is your practice?

Task "remove superfluous root users" problem

Hello.

I found strange trouble with this role installation on different centos7 instances. First time I found this trouble when I tried to install it on vagrant "centos/7" default box. It's strange, but on different boxes I saw different results. At all, I tried to run this role on several boxes: "centos/7", "hfm4/centos7", "jayunit100/centos7" and "geerlingguy/centos7". And just on part of them I gived this error:

TASK: [ben.mildren.percona_mysql | ensure percona database exists] ************
<192.168.99.100> REMOTE_MODULE mysql_db name=percona state=present login_unix_socket=/var/run/mysqld/mysqld.sock
failed: [192.168.99.100] => {"failed": true}
msg: unable to connect, check login credentials (login_user, and login_password, which can be defined in ~/.my.cnf), check that mysql socket exists and mysql server is running
FATAL: all hosts have already failed -- aborting

After that message, when I tried to run mysql -S /var/run/mysqld/mysqld.sock in guest machine shell, I saw this: Access denied for user 'root'@'localhost' (using password: NO)

This behaviour does not depends on percona_mysql_root_password variable, but eventually I found a decision. When I comment "remove superfluous root users" task, this problem was disappear.

I don't sure, that I can correctly fix the problem in this role. For me, I added the condition: when: remove_superfluous_root_users == true under task (and relevant variable to defaults vars).

But maybe, you can make more clever fix?

Add option & variable support for Galera / PXC

This is still a to do and the Galera related options / variables still need to be added