Role openstack/openstack-ansible-galera_server release queens-em conflict with MariaDB 10.4

[fititnt]

• References:
  • https://github.com/openstack/openstack-ansible-galera_server
  • https://mariadb.org/

---

The Ansible Role galera_server from openstack (this role is not on Ansible Galaxy) have a bug when testing MariaDB 10.4 and needs monkeypatching. The issue is confirmed to happens on Ubuntu 18.04, but is likely to happens also on Debian.

This is the exact line https://github.com/openstack/openstack-ansible-galera_server/blob/ec4f967b1386f4b83c1de2baa9da8ba37b00823a/vars/debian.yml#L58

galera_server_mariadb_distro_packages:
  - libmariadb-dev
  - mariadb-client
  - mariadb-backup
  - "{{ galera_mariadb_server_package }}"
  - galera-3 # This line, when using MariaDB 10.4, should be galera-4 or be user configurable
  - rsync
  - socat

The dependency conflict happens because MariaDB 10.4 cannot be installed along with galera-3 (wich is hardcoded on galera_server_mariadb_distro_packages) because it conflict with galera-3.

---

I will just lazy ping @mnaser @ctrlaltdel (the openstack/openstack-ansible-galera_server repo does not have a place to fill one issue) but maybe later will try to discover where to report this issue or made a PR

[mnaser]

Hi @fititnt

We don't actually support MariaDB 10.4 yet so that's why we haven't ran into that issue. Would you like to push up a patch to the role to make those fixes? It should be relatively trivial to check what version we're trying to install and decide between galera-3 or galera-4.

Mohammed

[fititnt]

@mnaser great! Where did I send pull requests (or patchs) for this?

I will also take some time to test this role on MariaDB 10.4 so could already give some testing considering it's a new cluster on a private client.

---

Ah, just to mention, this repository, ansible-linux-ha-cluster glue some Ansible roles (part are created by me, part by others). Later I will even try test openstack/openstack-ansible-galera_server cluster running on 3 different OSs at same time just as proof of concept. Maybe I already done it but with the default MariaDB version (10.3.10 if I remember) and just not pushed the result here.

[mnaser]

@fititnt -- the project is currently mirorred to GitHub, but the development happens inside the OpenDev Gerrit.

https://docs.openstack.org/infra/manual/developers.html

Let me know if you need anything else :)

[fititnt]

@mnaser perfect. I'm relatively new to Ansible (and to OpenStack) but definitely will stop on next weeks and do the full drill, not just this fix.

And very thank you for this special starting guide to know the general idea.