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

React to SERVER_TOO_MUCH_LAG status

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • 26.10
    • readwritesplit
    • None

    Description

      The new SERVER_TOO_MUCH_LAG status that's to be added in MXS-6571 needs to be detected by readwritesplit. If detected, the router should behave as if sync_transaction=soft is in effect but with a very low initial value of sync_transaction_timeout. While the SERVER_TOO_MUCH_LAG status is observed, the router should gradually increase the timeout for the transaction sync until the status bit disappears. The exact algorithm for the incrementing needs some research and experimentation but an initial version of linear increase of 5ms per minute should be a reasonable starting point.

      The value of sync_transaction_timeout could act as the hard limit above which the timeouts would never increase. This guarantees a reasonable rate of progress without triggering timeouts. The current default of 10 seconds could be lowered to 1 second to make it so that a commit will at most take one second. This is more suitable for the sync_transaction=soft mode which is a feature that's more generally usable compared to the synchronous replication of the sync_transaction=hard mode.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 5d
                  5d
                  Remaining:
                  Remaining Estimate - 5d
                  5d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.