Hi, SET GLOBAL wsrep_desync=1 will set a node as desynced and will cause MaxScale to stop sending traffic to it (provided you use router_options=synced in your maxscale.cnf config file) -GL On Mon, Jul 4, 2016 at 11:25 AM Thorvald Hallvardsson < thorvald.hallvardsson@gmail.com> wrote:
Hi guys,
I need some help as I'm preparing to expand my existing Galera cluster. Generally the purpose of it is I need to replace 3 VMs I have a cluster running on to 2 physical servers I have been given for that purpose.
My idea was to join 2 physical cluster to the existing cluster of 3 and then remove all 3 VMs from the cluster leaving 2 physical nodes within. I have a arbitrator box within the cluster as well.
The config at the moment contains 2 maxscale proxy nodes on the front balancing the read queries across the entire cluster of 3 and write queries to the elected master.
What I want to achieve is as I said above but + I will need another help with maxscale to expand and then shrink the cluster down to 2 nodes afterwards. I have had a situation before when I had to do a simple config change on the Galera cluster and I was trying to mark nodes and put them into maintenance mode to stop traffic coming to them but the commands like set server NODE master didn't actually do anything. I had situations when I had 2 masters in the cluster for a second because then something was happening that my manually selected master was becoming a slave again. I couldn't find anything on the internet what would point me into right direction and explain the whole procedure in details.
My cluster is quite busy at the moment even overnight so there is no perfect time to do anything on it. I need to do it the least disruptive way and the most controlled way as well. Hence I'm asking for help and suggestions as I found both Galera and maxscale documentation very very brief not actually providing any decent details or procedures. I found much more help from Percona but descriptions don't match sometimes.
Please help.
Regards, TH _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation