Hi Tom,

I feel this is more an example than a general recommendation.

In production we don't usually change weights for a three-node cluster. You may want to change weights in specific configurations only (e.g. 2 nodes in a datacenter and 1 node in another datacenter).

Best,

On Sun, Dec 27, 2015 at 2:43 PM Tom Worster <fsb@thefsb.org> wrote:

In the Galera docs I read

When configuring quorum weights for three nodes, use the following pattern:
node1: pc.weight = 2
node2: pc.weight = 1
node3: pc.weight = 0
Under this pattern, killing node2 and node3 simultaneously preserves the Primary Component on node1. Killing node1 causes node2 and node3 to become non-primary components.
The wording makes it sound as though this is a general recommendation. But, iiuc, this cluster of 3 nodes has a single point of failure: node1. How is this desirable?
Tom
_______________________________________________
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