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

MaxAdmin show service missing stats with MariaDB 5.1 MySQLBackend

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 2.0.5
    • Fix Version/s: N/A
    • Component/s: maxadmin
    • Labels:
      None
    • Environment:
      CentOS 7.3.1611

      Description

      I have setup a readconnroute service in /etc/maxscale.cnf with patched maxscale service from MXS-1244 to cope with MariaDB 5.1.62 backend Replication Cluster topology:

      [c3-server1]
      type=server
      address=10.10.80.170
      port=3306
      protocol=MySQLBackend
      myweight=100
       
      [c3-server2]
      type=server
      address=10.10.80.169
      port=3306
      protocol=MySQLBackend
      myweight=100
       
      [c3-server3]
      type=server
      address=10.10.80.171
      port=3306
      protocol=MySQLBackend
      myweight=100
       
      [c3-server4]
      type=server
      address=10.10.80.172
      port=3306
      protocol=MySQLBackend
      myweight=100
       
      [c3-server5]
      type=server
      address=10.10.80.175
      port=3306
      protocol=MySQLBackend
      myweight=100
       
      [C3-RO-Top20]
      type=filter
      module=topfilter
      filebase=/var/log/maxscale/C3-RO-Top20
      count=20
      #match=
      #exclude=
      #source=
      #user=
       
      [Read-Only Service C3]
      type=service
      router=readconnroute
      servers=c3-server1,c3-server2,c3-server3,c3-server4,c3-server5
      user=maxscale
      passwd=obfuscated
      router_options=slave
      filters=C3-RO-Top20
      weightby=myweight
       
      [Read-Only Listener C3]
      type=listener
      service=Read-Only Service C3
      protocol=MySQLClient
      port=6008
      

      I have captured with tcpdump the mysql traffic on the server hosting the MaxScale service before and after exercising "Read-Only Service C3" (30 minutes each capture).

      before

      $ tshark -nr mysql_1.pcap -q -z ip_hosts,tree
       
      ===================================================================
       IP Addresses         value	        rate	     percent
      -------------------------------------------------------------------
       IP Addresses       103450       0.057559                
        10.10.81.71         63731       0.035471         100.00%
        10.10.80.165         6829       0.003801          10.72%
        10.10.80.166         4680       0.002605           7.34%
        10.10.80.167         4676       0.002603           7.34%
        10.10.80.168         4687       0.002609           7.35%
        10.10.80.174         4687       0.002609           7.35%
        10.10.80.161         6801       0.003785          10.67%
        10.10.80.162         4666       0.002597           7.32%
        10.10.80.163         4681       0.002605           7.34%
        10.10.80.164         4670       0.002599           7.33%
        10.10.80.173         4661       0.002594           7.31%
        10.10.80.170         3423       0.001905           5.37%
        10.10.80.169         2317       0.001290           3.64%
        10.10.80.171         2316       0.001289           3.63%
        10.10.80.172         2315       0.001288           3.63%
        10.10.80.175         2322       0.001292           3.64%
       
      ===================================================================
      

      after

      $ tshark -nr mysql_2.pcap -q -z ip_hosts,tree
       
      ===================================================================
       IP Addresses         value	        rate	     percent
      -------------------------------------------------------------------
       IP Addresses       103450       0.057559                
        10.10.81.71        103450       0.057559         100.00%
        10.10.80.161         6806       0.003787           6.58%
        10.10.80.162         4674       0.002601           4.52%
        10.10.80.163         4670       0.002598           4.51%
        10.10.80.164         4664       0.002595           4.51%
        10.10.80.173         4672       0.002599           4.52%
        10.10.80.165         6806       0.003787           6.58%
        10.10.80.166         4676       0.002602           4.52%
        10.10.80.167         4666       0.002596           4.51%
        10.10.80.168         4665       0.002596           4.51%
        10.10.80.174         4678       0.002603           4.52%
        10.10.80.170         3471       0.001931           3.36%
        10.10.80.169        12966       0.007214          12.53%
        10.10.80.171        12212       0.006795          11.80%
        10.10.80.172        12543       0.006979          12.12%
        10.10.80.175        11281       0.006277          10.90%
       
      ===================================================================
      

      as it can be seen the load balancing was substantially fair for the slaves of that cluster as expected by using the readconnroute service type but the stats reported by maxadmin don't reflect this (I have introduced the weightby to make the stats more explicit with regards the achieved load-balancing).

      $ maxadmin show service "Read-Only Service C3"
      Service 0xf59120
      	Service:                             Read-Only Service C3
      	Router:                              readconnroute (0x7f46a764e140)
      	State:                               Started
      	Number of router sessions:   	723
      	Current no. of router sessions:	0
      	Number of queries forwarded:   	13212
      	Connection distribution based on myweight server parameter.
      		Server               Target % Connections
      		c3-server1           20.0%     0
      		c3-server2           20.0%     0
      		c3-server3           20.0%     0
      		c3-server4           20.0%     0
      		c3-server5           20.0%     0
      	Started:                             Thu Apr 27 08:39:21 2017
      	Root user access:                    Disabled
      	Filter chain:                C3-RO-Top20  
      	Backend databases:
      		10.10.80.170:3306  Protocol: MySQLBackend
      		10.10.80.169:3306  Protocol: MySQLBackend
      		10.10.80.171:3306  Protocol: MySQLBackend
      		10.10.80.172:3306  Protocol: MySQLBackend
      		10.10.80.175:3306  Protocol: MySQLBackend
      	Routing weight parameter:            myweight
      	Users data:                          0xf9f890
      	Total connections:                   724
      	Currently connected:                 1
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              abarbieri Andrea Barbieri
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration