Friday, February 27, 2009

bleeding edge HA mysql cluster

I just got back from the Mysql High Availability class in Denver (thanks for the class, George!)
and it's time to implement HA mysql at Mogreet.
I'm going to start with a test setup on my dev box, to see what issues present themselves between getting, compiling, installing and then porting the Mogreet DBs. I'll blog it in case it helps anyone.

First - getting the most recent code.
The generally available version of cluster is 6.3, but there are serious improvements in 6.4, including the ability to add nodes while the cluster is up. So I'm going for the bleeding edge beta version, which is mysql-5.1.32-ndb-6.4.3 as of 2/23/09 - about four days ago. MMm - fresh software!

You can browse the current mysql 5.1.32 and cluster 6.4 snapshots here:
ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/


Here's the link:
ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.32-ndb-6.4.3


Here are my configure flags:
./configure \
--prefix=/usr/mogreet_distro/mysql-5.1.32-beta-ndb \
--enable-assembler \
--enable-profiling \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--with-fast-mutexes \
--enable-local-infile \
--disable-grant-options \
--with-ssl \
--with-innodb \
--with-plugins=federated,heap,innobase,myisam,ndbcluster,blackhole,archive \
--with-ndb-test --with-ndb-docs


And now it's compile time.
startig about 10:08am... finished 10:32.
There are errors with ndb:
make[4]: *** [ndb_mgmd] Error 1

So I'll install and see what did/did not get built.

No comments:

Post a Comment