MySQL doesn't set up in Full HA topology.
Bug #1360283 reported by
Sagi (Sergey) Shnaidman
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Cisco Openstack |
Invalid
|
Undecided
|
Unassigned |
Bug Description
MySQL fails to set up sometimes in Full HA installation: approx. in 30% of cases.
Galera couldn't connect to other peers.
root@control-
140822 10:25:18 [ERROR] WSREP: gcs/src/
140822 10:25:18 [ERROR] WSREP: gcs connect failed: Connection timed out
140822 10:25:18 [ERROR] WSREP: wsrep::connect() failed: 7
140822 10:25:18 [ERROR] Aborting
All logs and configs are available here:
https:/
Changed in openstack-cisco: | |
status: | Incomplete → New |
Changed in openstack-cisco: | |
status: | New → Invalid |
To post a comment you must log in.
It looks like you're bootstrapping wrong
etc0/mysql/ my.cnf: wsrep_cluster_ address = gcomm:/ /192.168. 40.3,192. 168.40. 4,192.168. 40.5 my.cnf: wsrep_cluster_ address = gcomm:/ /192.168. 40.3,192. 168.40. 4,192.168. 40.5 my.cnf: wsrep_cluster_ address = gcomm:/ /192.168. 40.3,192. 168.40. 4,192.168. 40.5
etc1/mysql/
etc2/mysql/
first node should be gcomm:// until it's all working
once it comes up and is working, then bring up the others
once all 3 are up and talking, then change first node to gcomm://ip1,ip2,ip3