maria-discuss team mailing list archive

[Thorvald Hallvardsson <thorvald.hallvardsson@xxxxxxxxx>]

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