← Back to team overview

maria-discuss team mailing list archive

Re: Can't connect to local MySQL server through socket

 

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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
> 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

> 
>> Does this mean that mariadb tries to sync nodes but for some
>> reason the script hangs, the nodes are never sync and remain
>> unusable?
> 
> 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

- -- 
Sylvain Raybaud
www.green-communications.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJViqtSAAoJEEkkwl4JtJ9yDtMP/RC8SkWQSd4iU2FMJn8Hj1LW
K4Y9n0FETIu7pUpFiqAg13l+4ocEblv+SlYPPzAI5bdpBPVTA+EG7ypkyQgolPxX
5TQUUGjIM0rN675IVcDQalX8KPytSR8LkNDvB95oE71fKjOB9Ne71P8YpfdRMZgU
9Y7HMFPxckJulZOcoKb/4erOC9txgn69MY9YZ4QVQKahxK6vKfnbOOkS88SHNojy
KYeLrMWR6Jk0wmPz4ivMveRzJfGrCI8cxWGi26btxGfhWXUvq2/Wv0nYrfByN9ZH
kRd7Lo5RHnTzwT+EGNVtgkesA1L6UNgUo/N3fW8hGSnpIFuK+4CMcHjAsG6IxXVl
iX1uP4H56OydRZh3tzdnY7+vjAN6dz6J6bo1X/mtaUMcKk+f/whkbxy6+Ggeq92d
gWjoECDPJUd4R5JzTy4uMDhstg3RKX0KL32AGajPUJmFLAhmA9vkSRh1Wz9MVIBQ
/cPMSndhLFjlSRJAfdh2GHy8y1xCjLHxR7k1qQqf7AhKTYCE2Pq21ZTYRdJZkP6S
vo0W+KXcV4CvR0+rT15DJCUodwSak+r6GOCJ86koVs64JtcSyuLaqTKvtn0AjX4y
r+JG5G9WwKcbAx77BQk75EmL86rnuICFaXhXqe6HYs0Pi7xFuKCtLYZrAFtn2r5H
YhApUDevV8dNh4Vwl6wn
=iVBf
-----END PGP SIGNATURE-----


References