Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
2.4.7
-
CentOS 7
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 ?