[MXS-2348] Resultset checksum and query duration module Created: 2019-02-25  Updated: 2024-01-04  Resolved: 2019-11-29

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

Type: New Feature Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Epic Link: Filter Improvements
Sprint: MXS-SPRINT-93

 Description   

If a connection is mirrored to another server, it can be used to verify the integrity of and the behavior of upgraded systems. This helps figure out whether an upgraded system provides the same result as a reference system. By calculating a checksum for the resultset of the main connection and the duplicate connection, we know whether the results from the two servers are identical. Furthermore, by measuring the time it took for the query to complete changes in performance can be observed.

In 2.5 this can be easily implemented as a new router that behaves like the tee filter but instead of defining the service where the query is duplicated, the server where the result is returned is defined. Implementing it as a router also makes it much easier to calculate checksums and measure query durations.


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