[MXS-1156] Support heartbeat and retry syntax for Binlog Router Created: 2017-03-02  Updated: 2017-08-31  Resolved: 2017-08-31

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: None
Fix Version/s: 2.2.0

Type: Task Priority: Major
Reporter: VAROQUI Stephane Assignee: Massimiliano Pinto (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MXS-1155 Define a set of features for better i... Closed
Sprint: 2017-39, 2017-40

 Description   

The best practice for defining a slave is to set short heartbeat checks ,
this task would enable to do
CHANGE MASTER TO master_connect_retry=%d, master_heartbeat_period=%d as
documented in the the manuals and KB



 Comments   
Comment by Massimiliano Pinto (Inactive) [ 2017-08-30 ]

[BinlogServer]
type=service
router=binlogrouter

master_retry_count=10
connect_retry=60
heartbeat=300

or

router_options=master_retry_count=10,connect_retry=60,heartbeat=300

Comment by Massimiliano Pinto (Inactive) [ 2017-08-30 ]

maxadmin show services

....

Number of connect retries: 0
Connect retry interval: 60
Connect retry count limit: 1000

Comment by Massimiliano Pinto (Inactive) [ 2017-08-30 ]

MariaDB [(none)]> change master to master_connect_retry=60, master_heartbeat_period=300;

master_retry_count can onlt be changed in maxscale.cnf file.

Comment by Massimiliano Pinto (Inactive) [ 2017-08-31 ]

Merged to develop with Documentation update.

Generated at Thu Feb 08 04:04:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.