Sample Header Ad - 728x90

How can I disable the MaxScale readwriterouter for specific queries?

0 votes
1 answer
86 views
I'm using a Galera replication and MaxScale readwriterouter. I'm facing an issue because the application has been developed with this flow: 1. start transaction 2. update a record 3. commit 4. read that record The result is the the record is updated using the write-server and the next read is done on read-server. It doesn't get the data that has been just updated due to replication delay. Unfortunately it is a bit diffult to re-factor the whole application and I'm looking if exists some solution to force a read in the write-server so I can be sure to get the data that was just updated.
Asked by Tobia (211 rep)
Oct 22, 2024, 02:26 PM
Last activity: Oct 23, 2024, 03:14 AM