maria-discuss team mailing list archive
Mailing list archive
Re: Can't connect to local MySQL server through socket
-----BEGIN PGP SIGNED MESSAGE-----
On 24/06/2015 15:00, Guillaume Lefranc wrote:
> Nope, the database is empty (I just created it with
> mysql_install_db; also all nodes are fresh installs). Only the
> first node has SYNCED in its log indeed: # grep SYNCED
> buildroot.err 700101 0:01:10 [Note] WSREP: Shifting JOINED ->
> SYNCED (TO: 0)
> The two others show neither SYNCED or any reference to mysql.sock.
> I forgot to mention in my previous mail that after starting mariadb
> in the first node I run:
> mysql -u root --execute="SET GLOBAL
> 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:
>> Does this mean that mariadb tries to sync nodes but for some
>> reason the script hangs, the nodes are never sync and remain
> I'm afraid that must be something along those lines. I have the
> following suspicions:
> * SELinux or Apparmor not disabled, causing the SST to hang
> forever. * Ports not open on the firewall (for the record you need
> 3306, but also 4444, 4567 and 4568).
Ok, I'm following this lead. I'll let you know.
> -- Guillaume Lefranc Consultant / RemoteDBA Services - MariaDB
> Corporation Ab
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
-----END PGP SIGNATURE-----