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
Last activity: Oct 23, 2024, 03:14 AM