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

Where to get maxscale 6 mysql.maxscale_config table source sql

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 6.3.1
    • N/A
    • N/A
    • None

    Description

      配置maxscale 的config_sync_cluster 时，未创建mysql.maxscale_config表
      请问这个表是需要手动创建吗？如果是，我应该从哪里获取到该DDL呢？
      下面是我的配置信息：
      [MaxScale]
      threads=auto
      log_info=0
      log_debug=1
      log_notice=0
      log_warning=1
      max_auth_errors_until_block=0
      log_debug=1

      admin_host=0.0.0.0
      admin_secure_gui=0
      admin_auth=1
      admin_enabled=1
      admin_gui=1
      admin_log_auth_failures=true

      config_sync_cluster=master
      config_sync_user=smartms
      config_sync_password=*****

      =============================
      Note: smartms 的权限是确认没有问题的

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          View 11 older comments
          aroma lee added a comment -

          Yes, so I want to configure config_ sync_ Cluster, and I use the default user here. All maxscales have the same user and password

          aroma lee added a comment - Yes, so I want to configure config_ sync_ Cluster, and I use the default user here. All maxscales have the same user and password
          markus makela markus makela added a comment -

          If you have a load balancer in front of MaxScale, you need to make it so that the requests from the same client IP are sent to the same MaxScale.

          markus makela markus makela added a comment - If you have a load balancer in front of MaxScale, you need to make it so that the requests from the same client IP are sent to the same MaxScale.
          aroma lee added a comment -

          Thank you very much ,I turn on the keep session of SLB and it works normally

          aroma lee added a comment - Thank you very much ,I turn on the keep session of SLB and it works normally
          markus makela markus makela added a comment -

          OK, that's good to hear. Can we close this bug?

          markus makela markus makela added a comment - OK, that's good to hear. Can we close this bug?
          aroma lee added a comment -

          YES，Thanks

          aroma lee added a comment - YES，Thanks

          People

            markus makela markus makela
            aroma lee
            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.