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

SkySQL Docker - Update MaxScale configuration to take advantage of newer features

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • None
    • N/A
    • N/A
    • None

    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

      Attachments

        Activity

          People

            esa.korhonen Esa Korhonen
            shane.johnson@mariadb.com Shane Johnson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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