diff options
| author | Franciszek Przewozny <przewozny.franciszek@gmail.com> | 2026-09-11 00:13:27 +0200 |
|---|---|---|
| committer | Michal Nasiadka <mnasiadka@gmail.com> | 2026-09-17 06:38:11 +0000 |
| commit | a0d97b7373730f241b3637f9e5ab03cd8f99cf87 (patch) | |
| tree | dd253c1f02402eb9275f877457f575f69a4c3d48 /ansible | |
| parent | 7c45608cf7dd251a334ac888a19ad7d8c053a165 (diff) | |
| download | kolla-ansible-a0d97b7373730f241b3637f9e5ab03cd8f99cf87.tar.gz kolla-ansible-a0d97b7373730f241b3637f9e5ab03cd8f99cf87.zip | |
Fix ProxySQL not using backup writer node for reads
Set writer_is_also_reader to 2 in the Galera hostgroup
configuration so that the backup writer node also serves
reads, instead of sitting idle while all read traffic went
to the single remaining reader node. The writer node is
never added to the reader hostgroup regardless of this
setting, only the backup writer is affected. See bug report
for performance difference details.
Closes-Bug: #2167037
Change-Id: Ib5145c200c3cd70f861824abd967748faf61e1cf
Signed-off-by: fprzewozn <przewozny.franciszek@gmail.com>
(cherry picked from commit 42eec877ff572fd724af8a1c0fa64acf5e824c7b)
Diffstat (limited to 'ansible')
| -rw-r--r-- | ansible/roles/loadbalancer/templates/proxysql/proxysql.yaml.j2 | 2 |
1 files changed, 1 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 %} |