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

Using utf8mb4 on galera hosts stops maxscale connections

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.0.1
    • 2.1.0
    • galeramon, readwritesplit
    • Centos 7.1 64 bit
      3 x galera hosts - mariadb=10.1.18, galera=25.3.18-1
      1 x maxscale hosts - maxscale 2.0.1

      installed using 64 bit rpms from mariadb repositories
    • 2016-21, 2016-22, 2016-23, 2016-24, 2017-25

    Description

      Our hosts in the galera cluster are configured to use character set utf8mb4. If we try and configure maxscale to connect with this configuration, it will fail with errors such as :

      [Galera Monitor] Failed to connect to server 'nnnn1.co.uk' (10.10.1.41:3306) when checking monitor user credentials and permissions: Can't initialize character set unknown (path: compiled_in)
      [Splitter Service] Failed to connect to server 'nnnn1.co.uk' (10.10.1.41:3306) when checking authentication user credentials and permissions: 2019 Can't initialize character set unknown (path: compiled_in)
      

      If we change the galera hosts to use character set utf8, this works without issue.

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              simon.hanmer Simon Hanmer
              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.