aboutsummaryrefslogtreecommitdiff
path: root/releasenotes/notes
diff options
context:
space:
mode:
Diffstat (limited to 'releasenotes/notes')
-rw-r--r--releasenotes/notes/fix-proxysql-distributed-reads-5142e40995499611.yaml13
1 files changed, 13 insertions, 0 deletions
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>`__