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

Possible SwitchOver When Master & Slave status is "Maintenance"

    XMLWordPrintable

Details

    Description

      [DB_190_nbc]
      type=server
      address=192.168.101.190
      port=13306
      protocol=MariadBBackend
      priority=2
       
      [DB_191_biznet]
      type=server
      address=192.168.101.191
      port=13306
      protocol=MariadBBackend
      priority=1
       
      [MariaDB-Monitor-testing]
      type=monitor
      module=mariadbmon
      servers=DB_190_nbc,DB_191_biznet
      user=maxscale
      password=90AF8370A0805BCDBB221C772BA54755
      monitor_interval=1000
      auto_failover=false
      detect_stale_master=true
      failover_timeout=10
      auto_rejoin=true
      failcount=5
      master_failure_timeout=2
      verify_master_failure=true
      switchover_timeout=90
      replication_user=maxscale
      replication_password=90AF8370A0805BCDBB221C772BA54755
      detect_stale_slave=true
       
      [Read-Write-Service-testing]
      type=service
      router=readwritesplit
      servers=DB_190_nbc,DB_191_biznet
      user=maxscale
      password=90AF8370A0805BCDBB221C772BA54755
      master_failure_mode=fail_on_write
      strict_multi_stmt=false
      use_sql_variables_in=master
      master_reconnection=true
      delayed_retry=true
      delayed_retry_timeout=20
      transaction_replay=true
      max_sescmd_history=60
      prune_sescmd_history=true
      connection_timeout=36000
      filters=Hint
       
      [Read-Write-Listener-testing]
      type=listener
      service=Read-Write-Service-testing
      protocol=MariadbClient
      port=13306
      authenticator=MariaDBAuth
      authenticator_options=lower_case_table_names=true
      

      I have trouble when I manually switchover using command

      maxadmin call command mariadbmon switchover MariaDB-Monitor-Test DB_191_biznet DB_190_nbc
      

      "errors":[
        {
          "detail": "Slave catchup timed out on slave 'DB_191_biznet'."
        },
        {
          "detail": "Switchover DB_190_nbc -> DB_191_biznet failed."
        }
      ]
      

      so whether possible switchover when I set Master & slave to maintenance first and after that I Switchover manually ?

      Attachments

        Activity

          People

            Unassigned Unassigned
            febridev febriyant
            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.