[MXS-406] Galeramon to set the preferred donor nodes Created: 2015-10-14  Updated: 2017-12-01  Resolved: 2017-01-17

Status: Closed
Project: MariaDB MaxScale
Component/s: galeramon
Affects Version/s: None
Fix Version/s: 2.1.0

Type: New Feature Priority: Major
Reporter: markus makela Assignee: Massimiliano Pinto (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Sprint: 2017-25

 Description   

Galeramon should be able to control which nodes are the preferred as the donor with the wsrep_sst_donor variable. This would allow joining nodes to choose "slave" nodes which will allow MaxScale to influence the donor choosing process.

The monitor could execute SELECT @@wsrep_node_name; on a non-master node of the cluster and then assign the preferred SST donor node with SET GLOBAL wsrep_sst_donor=my_donor_node1.

MariaDB [(none)]> select @@wsrep_node_name;
+-----------------------+
| @@wsrep_node_name     |
+-----------------------+
| localhost.localdomain |
+-----------------------+
1 row in set (0.00 sec)
 
MariaDB [(none)]> set global wsrep_sst_donor = "localhost.localdomain";
Query OK, 0 rows affected (0.00 sec)



 Comments   
Comment by markus makela [ 2017-01-04 ]

http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-sst-donor

Comment by Massimiliano Pinto (Inactive) [ 2017-01-17 ]

Server 0x1723b00 (server1) [galera000]
priority 1700000000000000000000001

Server 0x1722d20 (server2) [galera001]
priority 9700

Server 0x17211d0 (server4) [galera003]
prioity not set

2017-01-17 08:56:31 debug : [galeramon] Sending SET GLOBAL wsrep_sst_donor = "galera003,galera000,galera001" to all slave nodes

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