My next task was to get MySQL multi-master replication working with Galera/wsrep but I can't get second node to sync. I believe the problem lies in the MySQL version 5.1 that comes in the LAMP appliance and the available memory in a micro instance - there are reported issues of high memory usage in wsrep in older builds.
Have you managed to get Galera working with 5.1?
When I get a moment I intend to try the Percona XtraDB cluster which is built for MySQL 5.5 and latest Galera/wsrep on a core Ubuntu 10.04 LTS Lucid for which they have a Debian package and multi node deployment tool. I may also try the SeveralNines ClusterControl for MySQL 5.5 Galera which uses an additional instance as a cluster monitor.
wish i could say the same for galera/wsrep
My next task was to get MySQL multi-master replication working with Galera/wsrep but I can't get second node to sync. I believe the problem lies in the MySQL version 5.1 that comes in the LAMP appliance and the available memory in a micro instance - there are reported issues of high memory usage in wsrep in older builds.
Have you managed to get Galera working with 5.1?
When I get a moment I intend to try the Percona XtraDB cluster which is built for MySQL 5.5 and latest Galera/wsrep on a core Ubuntu 10.04 LTS Lucid for which they have a Debian package and multi node deployment tool. I may also try the SeveralNines ClusterControl for MySQL 5.5 Galera which uses an additional instance as a cluster monitor.