Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2348

Resultset checksum and query duration module

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Icebox
    • Fix Version/s: 2.5.0
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: