Actually I used slightly different packages for the 5.1.62 build which is the version that came with the LAMP appliance. As such I only needed to remove the packages for mysql-server-5.1, mysql-server, and mysql-server-core-5.1 and left the client and common stuff as is:
I haven't got to the InnoDB part yet as I was trying to sync two nodes with just the basic installation. As far as I can see all permissions were correct and I set the firewalls wide open. The second node can see the cluster and the UUID for the cluster is correct but it gets stuck on the initial SST(4) sync stage then crashes MySQL, restarts, gets stuck, crashes, etc...
The bootstrap node runs fine and phpMyAdmin reports the correct client and server version and the wsrep parameters are all good. The second node has a blank client UUID and the ready status stays OFF.
The tutorial at magicpoisiton looks promising and is pretty much what I did with a few minor exceptions. I placed the wsrep parameter settings into the config file at /etc/mysql/conf.d/wsrep.cnf which includes the bind to 0.0.0.0 (having commented out the bind to localhost in my.cnf). I'll try some of the different settings they give such as binding to the actual IP of the server....
different package versions?
Hi Chris
Actually I used slightly different packages for the 5.1.62 build which is the version that came with the LAMP appliance. As such I only needed to remove the packages for mysql-server-5.1, mysql-server, and mysql-server-core-5.1 and left the client and common stuff as is:
1. https://launchpad.net/codership-mysql/5.1/5.1.62-23.4/+download/mysql-se...
2. https://launchpad.net/galera/2.x/23.2.1/+download/galera-23.2.1-i386.deb
I haven't got to the InnoDB part yet as I was trying to sync two nodes with just the basic installation. As far as I can see all permissions were correct and I set the firewalls wide open. The second node can see the cluster and the UUID for the cluster is correct but it gets stuck on the initial SST(4) sync stage then crashes MySQL, restarts, gets stuck, crashes, etc...
The bootstrap node runs fine and phpMyAdmin reports the correct client and server version and the wsrep parameters are all good. The second node has a blank client UUID and the ready status stays OFF.
The tutorial at magicpoisiton looks promising and is pretty much what I did with a few minor exceptions. I placed the wsrep parameter settings into the config file at /etc/mysql/conf.d/wsrep.cnf which includes the bind to 0.0.0.0 (having commented out the bind to localhost in my.cnf). I'll try some of the different settings they give such as binding to the actual IP of the server....
Cheers
Ian