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

Readconnroute router_options=slave gives me the master

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 1.4.1
    • 2.1.0
    • readconnroute
    • None

    Description

      Hi,

      I have setup a 4+1(unweighted backup ndoe)+1 arbitrator galera cluster and MaxScale with a readconnroute router. When I execute SELECT @@hostname it always gives me the master.

      Any idea what I did wrong, is there a bug?

      # Generated by OceanDBA Configurator 0.5 Date:2016-04-13.
      # https://www.oceandba.com/configurator/
      # 
      # The configuration file is available at the following URL:
      # https://www.oceandba.com/configurator/dl/genconf/0001-0afb650a-570e0e7e-ce5a-de71bb52/maxscale.cnf
      # 
      # Copy the content in /etc/maxscale.cnf or any preferred location.
      # Create maxscale user and monitoring user in your databases
      # Default maxadmin password is: mariadb
      # Logs can be found in /var/log/maxscale
      # 
      [maxscale]
      threads=4
       
      [Galera Monitor]
      servers=db01,db02,db03,db04
      type=monitor
      module=galeramon
      user=mariadb_monitor
      passwd=monitor_pass
      monitor_interval=1000
      available_when_donor=1
      # disable_master_failback=0
       
      [Master Connection Router]
      servers=db01,db02,db03,db04
      type=service
      router=readconnroute
      localhost_match_wildcard_host=1
      user=maxscale_user
      passwd=maxscale_pass
      router_options=master
       
      [Master Connection Listener]
      type=listener
      service=Master Connection Router
      protocol=MySQLClient
      port=3309
       
      [Slave Connection Router]
      servers=db01,db02,db03,db04
      type=service
      router=readconnroute
      localhost_match_wildcard_host=1
      user=maxscale_user
      passwd=maxscale_pass
      router_options=slave
       
      [Slave Connection Listener]
      type=listener
      service=Slave Connection Router
      protocol=MySQLClient
      port=3312
       
      [RW Split Router]
      servers=db01,db02,db03,db04
      type=service
      router=readwritesplit
      localhost_match_wildcard_host=1
      user=maxscale_user
      passwd=maxscale_pass
      max_slave_connections=100%
      router_options=master_accept_reads=0,slave_selection_criteria=LEAST_GLOBAL_CONNECTIONS
      disable_sescmd_history=1
       
      [RW Split Listener]
      type=listener
      service=RW Split Router
      protocol=MySQLClient
      port=3310
       
      [CLI]
      type=service
      router=cli
       
      [CLI Listener]
      type=listener
      service=CLI
      protocol=maxscaled
      port=6603
      address=127.0.0.1
       
      [db01]
      type=server
      address=db01
      protocol=MySQLBackend
      port=3306
       
      [db02]
      type=server
      address=db02
      protocol=MySQLBackend
      port=3306
       
      [db03]
      type=server
      address=db03
      protocol=MySQLBackend
      port=3306
       
      [db04]
      type=server
      address=db04
      protocol=MySQLBackend
      port=3306
      

      Attachments

        Activity

          People

            tturenko Timofey Turenko
            michaeldg Michaël de groot
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.