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