Read/Write Splitting with Master Pinning
(MXS-920)
|
|
| 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: |
|
||||||||
| 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. |