maria-discuss team mailing list archive

[Sylvain Raybaud <sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>]

-----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@xxxxxxxxxxxxxxxxxxxxxxx 
> <mailto:sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>> 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-----