Haproxy for galera cluster read write split ACL

Help!
1

Hi, I have configured read write split for galera cluster using acl like this
# Define ACLs
acl is_write query -m str -i “INSERT”
acl is_write query -m str -i “UPDATE”
acl is_write query -m str -i “DELETE”
acl is_read query -m str -i “SELECT”

use_backend galera_read if is_read
use_backend galera_write if is_write
default_backend galera_write

it is not working, basically using the default backend always, so when i removed default backend i get server not reachable.
Any idea ho to fix this much appreciated.

Kind regards,

2

Hi

query sample fetch is HTTP oriented, this won’t work for SQL (mode tcp backend)
As HAProxy is not SQL-awayre, you probably need to inspect the raw tcp payload to get this to work

3

Okay, thanks a lot for the info
much appreciated