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

config_sync_cluster always uses the mysql database

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.4.5, 22.08.4
    • 6.4.6, 22.08.5
    • Core
    • None

    Description

      The database used in the configuration synchronization is always the mysql database. This makes the use of the feature very strict and also prevents various features from being used with it due to where it is created. For example, creating triggers on this table is not possible as MariaDB forbids the creation of them on any table inside the mysql database, including user-created ones.

      The simple solution to this is to make the database configurable. The proposed parameter, config_sync_db, would still default to mysql but it would at least make it configurable. This would also allow the configuration synchronization user to be created with a reduced set of grants that only relate to the configured database.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.