[MXS-2212] Smart causal_reads Created: 2018-12-05  Updated: 2019-02-01  Resolved: 2019-02-01

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: 2.3
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None


 Description   

causal_reads add MASTER_GTID_WAIT is added ,if there was a write before it.

A more smart method would be to scan, if the write statement influence the result of the select statement.

It is not needed to add MASTER_GTID_WAIT with the write statement like...

Insert into table1 ....

If the following select is

Select * from table2



 Comments   
Comment by Johan Wikman [ 2018-12-10 ]

Doable, but much more complex than the current "brute-force" approach. The statements must be fully parsed and you need to separately maintain for each table information whether MASTER_GTID_WAIT must be injected in front of a SELECT targeting that table.

Generated at Thu Feb 08 04:12:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.