diff options
| author | Zuul <zuul@review.opendev.org> | 2026-10-09 22:59:51 +0000 |
|---|---|---|
| committer | Gerrit Code Review <review@openstack.org> | 2026-10-09 22:59:51 +0000 |
| commit | 7101c4cc7fe83937686a39dbe0174293423e32a2 (patch) | |
| tree | c958cc2c6a68fc162ef713334fe165e534836e1e | |
| parent | 60e7009b2940ae95093c7d8d7710737e5586ebdc (diff) | |
| parent | a0d97b7373730f241b3637f9e5ab03cd8f99cf87 (diff) | |
| download | kolla-ansible-7101c4cc7fe83937686a39dbe0174293423e32a2.tar.gz kolla-ansible-7101c4cc7fe83937686a39dbe0174293423e32a2.zip | |
Merge "Fix ProxySQL not using backup writer node for reads" into stable/2026.1
| -rw-r--r-- | ansible/roles/loadbalancer/templates/proxysql/proxysql.yaml.j2 | 2 | ||||
| -rw-r--r-- | releasenotes/notes/fix-proxysql-distributed-reads-5142e40995499611.yaml | 13 |
2 files changed, 14 insertions, 1 deletions
diff --git a/ansible/roles/loadbalancer/templates/proxysql/proxysql.yaml.j2 b/ansible/roles/loadbalancer/templates/proxysql/proxysql.yaml.j2 index f7a8b0a08..549051383 100644 --- a/ansible/roles/loadbalancer/templates/proxysql/proxysql.yaml.j2 +++ b/ansible/roles/loadbalancer/templates/proxysql/proxysql.yaml.j2 @@ -111,6 +111,6 @@ mysql_galera_hostgroups: offline_hostgroup: {{ _offline_group }} max_connections: {{ proxysql_backend_max_connections }} max_writers: 1 - writer_is_also_reader: 0 + writer_is_also_reader: 2 comment: "Galera cluster for shard {{ shard_id }}" {% endfor %} diff --git a/releasenotes/notes/fix-proxysql-distributed-reads-5142e40995499611.yaml b/releasenotes/notes/fix-proxysql-distributed-reads-5142e40995499611.yaml new file mode 100644 index 000000000..1ec90b0fd --- /dev/null +++ b/releasenotes/notes/fix-proxysql-distributed-reads-5142e40995499611.yaml @@ -0,0 +1,13 @@ +--- +fixes: + - | + Fix ProxySQL Galera configuration so that the backup writer + node also serves read queries, instead of leaving it idle + and sending all reads to the single remaining reader node. + This is done by setting ``writer_is_also_reader`` to ``2``, + which adds backup writer hostgroup nodes to the reader + hostgroup while still excluding the active writer node. See + the `ProxySQL documentation + <https://proxysql.com/documentation/group-replication-configuration/>`__ + for details. + `LP#2167037 <https://launchpad.net/bugs/2167037>`__ |