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

Store configuration in Server

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 6.0.0
    • Core
    • None

    Description

      MaxScale should have an option to maintain all of its configuration in the Server deployment it sits in front of.

      It could store JSON or YAML files in TEXT columns, or it could normalize the data in a set of system tables. As a result, MaxScale itself becomes stateless and its configuration can be managed either by the UI or directly in Server by editing the data in the system tables.

      This is particularly helpful in the context of SkySQL. If a MaxScale instance fails, a new one can be brought up and it can pull its configuration from the primary Server instance.

      There is the challenge of seeding the Server definitions though. One option is for SkySQL to use the MaxScale REST API to seed the Servers. MaxScale can then "register itself" with the primary Server instance, storing its configuration and information there. For on premises, they would have to be added to the local config file. In fact, MaxScale could continue to use the local config file, but build and update it using data queried from Server.

      Additionally, it might be nice if Server instances could send queries to a MaxScale admin port. This port isn't backed by a database, but rather by MaxScale itself. We might be able to add MaxScale as a server definition in Server and use it to send commands to MaxScale such as "refresh configuration" or "update xyz configuration". This would help synchronous the configuration of multiple MaxScale instances. Alternatively, MaxScale could refresh its configuration every X seconds or have a button in its UI to refresh of its configuration.

      The primary objective is to make MaxScale stateless and to externalize its configuration.

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            shane.johnson@mariadb.com Shane Johnson (Inactive)
            Votes:
            1 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.