city-of-bloomington / ansible-role-mysql Goto Github PK

We are starting to want to run CentOS on servers. We need to update our Ansible roles to work with RPM based distros as well as DEB.

A few servers need to alter the mysqld settings. For instance, some servers for Tomcat need to set the tablenames to lowercase.

The old way of doing apt with-items is deprecated. The new way is to declare a variable for all the package names.

New style for apt-get install

- name: "Install Dependencies"
  apt:
    name: "{{ packages }}"
    state: present
  vars:
    packages:
      - "postgis"

Old, deprecated style

- name: "Install Dependencies"
  apt:
    name: "{{ item }}"
    state: present
  with_items:
    - "postgis"

It turns out the settings in local.cnf are not getting applied. On startup, the server includes the files alphabetically, so the local.cnf gets loaded before mysqld.cnf. Settings in mysqld.cnf are overwriting what we loaded in local.cnf.

We need to rename local.cnf so it gets loaded after mysqld.cnf

It would be nice if we had Ansible install a backup script that would back up every database on a mysql server. We should create a directory in /srv/backups using the database name. The SQL files should be gzipped and purged after five days or so.

Ansible can now be run using Python3. However, our MySQL role is coded expecting to be only used in python 2. The only difference is installing the correct python mysqldb driver.

Python2: python-mysqldb
Python3: python3-mysqldb

We should probably write Ansible to check which version of python is being used and install the appropriate mysql driver.