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

prepare for switchover by throttling writes - keep replication lag low

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • 26.10.0
    • None
    • None

    Description

      Add prepare switchover behaviour that if necessary makes writing slower so that slaves can catch up. That way, once it’s time to do the switchover, there will be no waiting.

      Can this reuse anything from sync_transaction to have new transactions wait or delay some to give time for the replica to catch up. but is it too much to have the entire transaction wait versus adding a fixed amount of ms or ascending. What about throttle filter or other to slow writes down.

      make solution smarter a little bit

      • existing connections wont have/know they need to throttle, need to atomically switch/update those

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              allen.herrera Allen Herrera
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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