[MXS-2951] SkySQL Docker - Update MaxScale configuration to take advantage of newer features Created: 2020-04-01  Updated: 2022-03-14  Resolved: 2022-03-14

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

Type: Task Priority: Minor
Reporter: Shane Johnson (Inactive) Assignee: Esa Korhonen
Resolution: Won't Do Votes: 0
Labels: None

Epic Link: SkySQL MaxScale Docker Image

 Description   

MaxScale has a lot of features that create differentiation and competitive advantages for SkySQL. This is request is to simply change some of the defaults.

Master reconnection
Allows MaxScale to migrate connections from the old primary to the new primary so applications don't have to open new ones.

https://mariadb.com/kb/en/mariadb-maxscale-24-readwritesplit/#master_reconnection

Adapting routing
Allows MaxScale to route queries based on individual instance response times.

https://mariadb.com/kb/en/mariadb-maxscale-24-readwritesplit/#slave_selection_criteria

Delayed retry
Allows MaxScale to retry reads if they fail due to a connection error (e.g., the replica just failed).
We may want to set the read timeout to a smaller value (10s by default)

https://mariadb.com/kb/en/mariadb-maxscale-24-readwritesplit/#retry_failed_reads
https://mariadb.com/kb/en/mariadb-maxscale-24-readwritesplit/#delayed_retry_timeout

Transaction replay
Allows MaxScale to replay transactions on the new primary if the original fails.

https://mariadb.com/kb/en/mariadb-maxscale-24-readwritesplit/#transaction_replay

Causal reads
Allows MaxScale to tell a replica to catch up to the client before executing the query.
We may want to set the read timeout to a smaller value (10s by default)

https://mariadb.com/kb/en/mariadb-maxscale-24-readwritesplit/#causal_reads
https://mariadb.com/kb/en/mariadb-maxscale-24-readwritesplit/#causal_reads_timeout


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