RHEL/CentOS 7 uses MariaDB instead of MySQL

[mrkeuz]

Hello!

First of all thanks for you effort!

I found a small issue. On Centos 7 "default" Mysql is 'mariadb-server' as far as I understand.
So it falls with:

failed: [********] => (item=mysql,mysql-server,MySQL-python) => {"changed": false, "failed": true, "item": "mysql,mysql-server,MySQL-python", "rc": 0, "results": ["mariadb-5.5.40-1.el7_0.x86_64 providing mysql is already installed"]}
msg: No Package matching 'mysql-server' found available, installed or updated

FATAL: all hosts have already failed -- aborting

Some topics about mysql package in Centos 7:
https://www.centos.org/forums/viewtopic.php?f=48&t=47394
https://www.digitalocean.com/community/questions/can-t-install-mysql-on-centos-7

[mrkeuz]

Just FYI

Worked RedHat.yml vars are:

mysql_daemon: mariadb
mysql_packages:
  - mariadb
  - mariadb-server
  - MySQL-python

"mariadb.service"

There is issue with startup:

$ journalctl -xn
...
141125  2:21:54 [ERROR] mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
141125  2:21:54 [ERROR] Can't start server: can't create PID file: No such file or directory
...

For fix just remove pid-file in my.cnf.j2.

Some info about pid:
https://bugzilla.redhat.com/show_bug.cgi?id=1069586

[JorisVanEijden]

Can the mysql_packages be moved from vars to defaults?
I'd like to use mysql56u from IUS for some machines.

Quote: "if you are writing a role and want to ensure the value in the role is absolutely used in that role, and is not going to be overridden by inventory, you should put it in roles/x/vars/main.yml like so, and inventory values cannot override it. -e however, still will."

[geerlingguy]

I've set mysql_packages in a way that can be overridden, and I'll soon be working on getting the rest of the role working correctly on CentOS 7 / MariaDB.

[geerlingguy]

See #38 .