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

Master / Slave Status of Servers not detected for RW split

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.1.0
    • 1.2.0
    • mariadbmon
    • None
    • Ubuntu 14.04
      MariaDB 10.0.17

    Description

      I just tried to use the RW Split Router but don’t get it work because skygw_err1.log says:

      ---	Logging is enabled.
      2015-04-22 18:38:54   Error : No Master can be determined

      My replication works. Master and Slave Servers are running MariaDB 10.0.17.

      My configuration looks like:

      [maxscale]
      threads=4
       
      [RW Split Service]
      type=service
      router=readwritesplit
      servers=db1, db2
      user=maxscale
      passwd=PASSWORD
      localhost_match_wildcard_host=1
      enable_root_user=1
       
      [RW Split Listener]
      type=listener
      service=RW Split Service
      protocol=MySQLClient
      port=3306
      socket=/tmp/ClusterMaster
       
      [db1]
      type=server
      address=10.150.10.31
      port=3306
      protocol=MySQLBackend
       
      [db2]
      type=server
      address=10.150.10.32
      port=3306
      protocol=MySQLBackend
       
      [Replication Monitor]
      type=monitor
      module=mysqlmon
      servers=db1, db2
      user=maxscale
      passwd=PASSWORD
       
      [CLI]
      type=service
      router=cli
       
      [CLI Listener]
      type=listener
      service=CLI
      protocol=maxscaled
      address=localhost
      port=6603

      output of "/usr/local/mariadb-maxscale/bin/maxadmin -pmariadb show servers" says:

      Server 0x1bd9d30 (db1)
      	Server:				10.150.10.31
      	Status:               		Running
      	Protocol:			MySQLBackend
      	Port:				3306
      	Server Version:			10.0.17-MariaDB-1~trusty-log
      	Node Id:			1
      	Master Id:			-1
      	Slave Ids:			
      	Repl Depth:			-1
      	Number of connections:		0
      	Current no. of conns:		0
      	Current no. of operations:	0
      Server 0x1bd9b10 (db2)
      	Server:				10.150.10.32
      	Status:               		Running
      	Protocol:			MySQLBackend
      	Port:				3306
      	Server Version:			10.0.17-MariaDB-1~trusty
      	Node Id:			2
      	Master Id:			-1
      	Slave Ids:			
      	Repl Depth:			-1
      	Number of connections:		0
      	Current no. of conns:		0
      	Current no. of operations:	0
       

      Whats the Problem?

      Attachments

        Activity

          People

            markus makela markus makela
            monotek André Bauer
            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.