maria-discuss team mailing list archive

[Nirbhay Choubey <nirbhay@xxxxxxxxxxx>]

On Wed, Jun 24, 2015 at 9:30 AM, Sylvain Raybaud <
sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> -----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
>
>
WSREP_SST: [ERROR] USER cannot be nil (19700101 00:05:06.%N)

Try setting wsrep_sst_auth=user:pass

- Nirbhay


> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>