Read/Write Splitting with Master Pinning (MXS-920)

[MXS-783] Master Pinning Created: 2016-07-05  Updated: 2016-10-18  Resolved: 2016-08-17

Status: Closed
Project: MariaDB MaxScale
Component/s: ccrfilter
Affects Version/s: None
Fix Version/s: 2.1.0

Type: Sub-Task Priority: Major
Reporter: Johan Wikman Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-545 Review and finalize slavelag filter Closed

 Description   

At a high-level, if a connection (representing a real-time web request) is all reads, it can run off any of the read-replicas. If a connection does read, read, read, write, read, the connection is switched to the master nodes on the first write and then stays on the master for the remainder of the connection. There is no replication lag concern for the application to make sure it reads the data that was just written since it's pinned to the master.



 Comments   
Comment by markus makela [ 2016-07-05 ]

This functionality is implemented by the slavelag filter.

Comment by Dipti Joshi (Inactive) [ 2016-07-21 ]

markus makelaIs the slavelag filter one of the existing experimental filter ?

Comment by markus makela [ 2016-07-21 ]

Yes, it has been in the repository for quite some time but has not been a part of the package.

Comment by markus makela [ 2016-08-17 ]

Cleaned up the filter, documented it and renamed it to Consistent Critical Read (CCR) filter.

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