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.
node 1 ip .81
node 2 ip .82
node 3 ip .83
node 4 ip .100
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.