Re: [Maria-discuss] Can't connect to local MySQL server through socket
-----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-----
On Wed, Jun 24, 2015 at 9:30 AM, Sylvain Raybaud < sylvain.raybaud@green-communications.fr> 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@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
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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
Nirbhay Choubey -
Sylvain Raybaud