Hi, Thanks all. What should I configure on sql3 then as a donor ? Or shall I leave this option unset ? Thank you! Regards, TH On 7 July 2016 at 07:11, Daniel Black wrote:

Don't get the donor name wrong or you'll be chasing phantom network error messages.

https://github.com/codership/galera/pull/109

On 06/07/16 20:00, Thorvald Hallvardsson wrote:

...

Hi,

I want to configure my cluster of 3 nodes let's call them sql1, sql2, sql3 in the way that maxscale will only balance request to sql1 and sql2 but sql3 will be only for backup/donor purposes.

My question is... how can I set permanent donor in galera ?

Is wsrep_sst_donor the thing ?

Thank you.

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

_______________________________________________ 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

It needs to match https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_nod... of the donor. On 08/07/16 10:59, Tom Worster wrote:

On 7/7/16, 2:11 AM, "Maria-discuss on behalf of Daniel Black" wrote:

...

Don't get the donor name wrong or you'll be chasing phantom network error messages.

https://github.com/codership/galera/pull/109

i couldn't make wsrep-sst-donor work with either the ip addresses from the gcomm:// wsrep_cluster_address in my.cnf or with the host names wsrep wrote in the log. i concluded i couldn't use it.

tom