-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 24/06/2015 15:11, Guillaume Lefranc wrote:
> Sylvain,
>
> On Wed, Jun 24, 2015 at 3:06 PM, Sylvain Raybaud
> <sylvain.raybaud@green-communications.fr
> <mailto:sylvain.raybaud@green-communications.fr>> wrote:
>
>
>>
>> I forgot to mention in my previous mail that after starting
>> mariadb in the first node I run:
>>
>> mysql -u root --execute="SET GLOBAL
>> wsrep_cluster_address='gcomm://';"
>>
>>
>> Don't do the above. Since you are starting the cluster with
>> --wsrep_new_cluster, that's enough. I'm not sure of what it
>> would do but I'd rather avoid to bootstrap the cluster two
>> times.
>
> If I don't, the cluster does not start at all, all I get is a
> disconnected cluster of size 0 on node #1, exactly as described
> here:
> https://mariadb.com/blog/mariadb-galera-cluster-quirk-bootstrapping
>
>
>
> Yes, but this happens for a good reason and the manual is quite
> clear about that: You didn't set wsrep_cluster_address in your
> my.cnf. I would recommend to set it on all nodes, as it can cause
> all kinds of things to go wrong in the future (imagine you reboot
> your 1st node, it has no peers to reconnect to), plus some other
> side effects I cannot envision. So recommendation is really to have
> this set on all nodes with IP addresses of each node, in your case
> wsrep_cluster_address=gcomm://192.168.1.77
> <http://192.168.1.77/>,192.168.1.80,[IP of node 3]

Got it, doing that :)

I tried setting wsrep_sst_method to mysqldump instead of rsync and it
fails. Here are the error logs:

node #1: http://pastebin.com/UXr378mC

node #2: http://pastebin.com/4xEi2ncS

node #3: http://pastebin.com/LWvmrdAt

Still investigating.

- --
Sylvain Raybaud
www.green-communications.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJVirDlAAoJEEkkwl4JtJ9ytK4P/2d8QMDUKbN48MT1/mA4kI4x
n2Y1VOahIUWxG6YZjenAHSi96VUpzIkpk5VQvzeozIRTtmsFlfhsitwZwd8pERmu
Usse6+fptio2iHpzabyterMmyXrEcI9Dtdu9/4KBPBKs1WBdShDkmEvUJ279oaIU
uj3cuOMWo05snac3wFuSk53edCaUPT6CJfTHUn+FkmFQbRzEE89Q2IW+FKdUW23L
X9XOuabR5iu1/5FeJxmYut3yS10slByebofjQlMGFdRZ20ZD60phRjuIqr4VtgK+
Pl6wwMlAYMgrwvGxNUOzA3czm23oulfwcziFRk8DA2xkLxJyYDW8XDzGphoBWLzZ
oaQIE+ikYNFEUDPGUVvBRnVigmi2NksXz7s8ND8oSROwoXqzgH+MhR1kYdcysPKp
aEs94h7uwh1u+0wHVNFmd7xNwbZyJxeb+ICB7GxpTlLMk8EbUZzbuGiiEcZaWNb3
IOfifbs8sc5/eE3Jrds67cFaUsjAchyNLQ2eNraoiDN1b8KD6nflmU8M5bdJ9UYH
ICfpa9CSA2+qYWHWh9XfEEwb3Ugal1i/xSqlbObkVeqAlG8/PWbA5ubeBlGhzVDF
jObLYVhh5c+bKLtKXPmzi1fvvsCaSiYRvXFxetmWO+8BpL27i37dfhslyc8Fk6/j
+YwjwwY+st1sIm1oE/5M
=Lvhi
-----END PGP SIGNATURE-----

_______________________________________________
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