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

maxscale [mysql monitor] / infinidb [mysql cluster replication]

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.2.1
    • Component/s: mariadbmon
    • Labels:
      None
    • Environment:
      Debian Jessie 8.2
      Maxscale 1.2.1

      Description

      Hi,

      I tried to setup mysql monitor from maxscale on mysql replication on 3 infinidb nodes (master/slave/slave) but I have this error :

       Error : No Master can be determined

      As you can see, my replication is up on master/slaves and from maxscale mysql monitor host I can connect to all dbs nodes :

       
      mysql -hum1 -umaxscalerepl -pmaxscalepass -e "show slave status"
      mysql -hum2 -umaxscalerepl -pmaxscalepass -e "show slave status"
      mysql -hum3 -umaxscalerepl -pmaxscalepass -e "show slave status"
      ...
       
      | Waiting for master to send event | 192.168.56.10 | idbrep      |        3306 |            60 | mysql-bin.000010 |                1078 | relay-bin.000003 |           251 | mysql-bin.000010      | Yes              | Yes               |                 |                     |                    |                        |                         |                             |          0 |            |            0 |                1078 |             545 | None            |                |             0 | No                 |                    |                    |                 |                   |                |                     0 | No                            |             0 |               |              0 |                |
       
      ...

      Here my configuration :

       
      [maxscale]
      threads=3
      log_trace=1
       
      [um1]
      type=server
      address=192.168.56.10
      port=3306
      protocol=MySQLBackend
       
      [um2]
      type=server
      address=192.168.56.12
      port=3306
      protocol=MySQLBackend
       
      [um3]
      type=server
      address=192.168.56.17
      port=3306
      protocol=MySQLBackend
       
      [MySQL Monitor]
      mysql51_replication=true
      type=monitor
      module=mysqlmon
      servers=um1,um2,um3
      user=maxscalerepl
      passwd=maxscalepass
      monitor_interval=10000
       
      [RWSplitRouter]
      type=service
      router=readwritesplit
      servers=um1,um2,um3
      user=maxscalerepl
      passwd=maxscalepass
       
      [RWSplitListener]
      type=listener
      service=RWSplitRouter
      protocol=MySQLClient
      port=3306

      and ouput from maxadmin how servers :

      Server 0x3676ae0 (um1)
      	Server:				192.168.56.10
      	Status:               		Running
      	Protocol:			MySQLBackend
      	Port:				3306
      	Server Version:			5.1.73-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 0x36769d0 (um2)
      	Server:				192.168.56.12
      	Status:               		Slave, Running
      	Protocol:			MySQLBackend
      	Port:				3306
      	Server Version:			5.1.73-log
      	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
      Server 0x36768c0 (um3)
      	Server:				192.168.56.17
      	Status:               		Slave, Running
      	Protocol:			MySQLBackend
      	Port:				3306
      	Server Version:			5.1.73-log
      	Node Id:			3
      	Master Id:			-1
      	Slave Ids:
      	Repl Depth:			-1
      	Number of connections:		0
      	Current no. of conns:		0
      	Current no. of operations:	0

      Where is the problem please ?

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            no way
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.