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

Using utf8mb4 on galera hosts stops maxscale connections

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.1.0
    • Component/s: GaleraMon, ReadWriteSplit
    • Labels:
    • Environment:
      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
    • Sprint:
      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

              • Assignee:
                markus makela markus makela
                Reporter:
                simon.hanmer Simon Hanmer
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: