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

Support config sync with Xpand

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 6.4.4
    • N/A
    • N/A
    • None
    • Xpand 6.0.5, MaxScale 6.4.4
    • MXS-SPRINT-172

    Description

      Xpand doesn't have a mysql database and it does not implement the current set of JSON functions that MaxScale uses. Support for config synchronization can be added by making the database configurable (MXS-4499) and changing the SQL to do the JSON manipulation in MaxScale.


      Original description:

      Environment

      • Xpand 6.0.5
      • MaxScale Version: 6.4.4

      Steps to Reproduce

      1. Set up Xpand and then run this SQL:

      CREATE DATABASE mysql;
      GRANT ALL on mysql.* TO 'sync_user'@'%' IDENTIFIED BY 'secure_password';
      

      2. Set up MaxScale Clustering with this config:

      # Globals
      [maxscale]
      config_sync_cluster = XpandMonitor
      config_sync_user = sync_user
      config_sync_password = secure_password
      

      3. View the MaxScale Logs

      Observed Behavior

      This error is repeated every five seconds:

      2022-12-02 21:44:29   warning: (ConfigManager); Failed to update node state to ‘Failed to update server ‘XpandBootstrap’’ for hostname ‘ip-10-0-0-48.us-east-2.compute.internal’: Query ‘UPDATE mysql.maxscale_config SET nodes = JSON_SET(nodes, CONCAT(‘$.’, JSON_QUOTE(‘ip-10-0-0-48.us-east-2.compute.internal’)), ‘Failed to update server \’XpandBootstrap\’’) WHERE version = 1 AND cluster = ‘XpandMonitor’’ failed. Error 1046: [11285] No database selected.
      

      Also, the record is not updated in mysql.maxscale_config

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            Paul.rothrock@mariadb.com Paul Rothrock
            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.