Hey,

Sorry, I can't help with kolla answer, as I have close to no idea, but was wondering what is wrong with ProxySQL and why not worth using it? Except cumbersome user management:) As I was also considering it lately for adoption.

PS: I would wait for a more native solution for kolla, but fwiw ... OpenStack-Ansible has quite a decent Ansible role for MariaDB+Galera cluster deployment, that we use outside of OSA a lot as well, as it's quite agnostic: https://opendev.org/openstack/openstack-ansible-galera_server

On Fri, Nov 10, 2023, 21:57 Jahns, Jay <jahns.jay@heb.com> wrote:

We currently run OpenStack on top of two datacenters, and we need to ensure we have datacenter redundancy for the database. With this, we would have 2-3 nodes in each DC running galera.

Its been recommended by multiple people that we use an externally managed database server (or cluster) that has its own redundancies built around the two DC layout, and not have kolla manage that.

Is there a way we can use kolla to deploy a galera cluster per DC, and use that to provide redundancy in the event that we lose one of the DCs? We were currently looking at proxysql but folks have recommended against it.

Thanks.