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

Unable Load-Balancing(readconnroute) with MaxScale

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Incomplete
    • Affects Version/s: 2.3.4
    • Fix Version/s: N/A
    • Component/s: readconnroute, Router
    • Labels:
      None
    • Environment:
      VMware
      3node GaleraCluster & MaxSacle & appserver

      Description

      Hi,
      I have found some strange thing.
      When using 2.2.16 and 2.2.20 then load-balancing is well.
      But when I change version to 2.3.4 then unable to load-balancing.

      Changed things are like below.
      1.rpm -e maxscale-2.2.20-1.x86_64
      2.rpm -Uvh maxscale-2.3.4-1.centos.7.x86_64.rpm
      3.systemctl restart maxscale

      But back to the 2.2.20 then load-balancing is again well.

      I think, this is bug or routing configuration is changed.
      How can I solve this problem???

      Thank you.

      [root@router ~]# cat /etc/maxscale.cnf
      [maxscale]
      threads=auto
       
      [dbserv1]
      type=server
      address=192.168.116.111
      port=3306
      protocol=MariaDBBackend
       
      [dbserv2]
      type=server
      address=192.168.116.112
      port=3306
      protocol=MariaDBBackend
       
      [dbserv3]
      type=server
      address=192.168.116.113
      port=3306
      protocol=MariaDBBackend
       
      [Galera-Monitor]
      type=monitor
      module=galeramon
      servers=dbserv1, dbserv2, dbserv3
      user=monitor_user
      passwd=my_password
      monitor_interval=2000
       
      [Galera-Service]
      type=service
      router=readconnroute
      router_options=synced
      servers=dbserv1, dbserv2, dbserv3
      user=maxscale
      passwd=maxscale_pw
      enable_root_user=true
       
      [Galera-Listener]
      type=listener
      service=Galera-Service
      protocol=MariaDBClient
      port=4306
      #socket=/tmp/DB.cluster
       
      [CLI]
      type=service
      router=cli
       
      [CLI-Listener]
      type=listener
      service=CLI
      protocol=maxscaled
      socket=default
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Seonghwan Kim Seonghwan Kim
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: