-----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.rayb...@green-communications.fr > <mailto:sylvain.rayb...@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
