Setting up a 4 node XtraDB cluster for eval at work. The first three notes went pretty smoothly, but number 4 is another story. It was working then I ran apt-get upgrade and it wont restart. Well it did restart once I ran another apt-get to install a utility and boom mysql won’t restart.
So a few questions
I can’t find a answer to how wsrep_cluster_address=gcomm://192.168.0.83:3306 should be set see lot of different answers on the internet.
I have:
node 1 ip .81
wsrep_cluster_address=gcomm://
node 2 ip .82
wsrep_cluster_address=gcomm://192.168.0.83:3306
node 3 ip .83
wsrep_cluster_address=gcomm://192.168.0.81:3306
node 4 ip .100
wsrep_cluster_address=gcomm://192.168.0.82:3306
I’ve seen on net saying point 2-4 at node 1, others saying daisy chain them.
Then when a node won’t restart no errors just the warning " WSREP: no nodes coming from prim view, prim not possible"
Any idea what’s wrong things were working until the apt-get upgrade and now everytime I run apt-get it stop mysql and restart it.
Can’t someone at least say how the gcomm should be configured?
I have:
node 1 ip .81
wsrep_cluster_address=gcomm://
node 2 ip .82
wsrep_cluster_address=gcomm://192.168.0.83:3306
node 3 ip .83
wsrep_cluster_address=gcomm://192.168.0.81:3306
node 4 ip .100
wsrep_cluster_address=gcomm://192.168.0.82:3306
I’ve seen on net saying point 2-4 at node 1, others saying daisy chain them.
first node works when set to nothing, but other info say set it to and address once 2nd and 3th nodes are up.