[rt-users] rt-3 cluster mysql backend

[Rainer Duffner]

Roy El-Hames wrote:
> I am looking to migrate the backend (mysql) to a clustered platform 
> and was planning on using mysql 5.1.
> However rt-3.6 need Innodb and the cluster needs ndbcluster ... have 
> anyone had a work around for this .. or possibly more general have 
> anyone implemented a mysql clustered backend ..
> On google I came across 
> :http://forums.mysql.com/read.php?25,32782,32812#msg-32812 ..but 
> unless I am missing something the innodb tables would n't be 
> replicated in the suggested solution ..Any help will be greatly 
> appreciated..
> the system will be rt-3.6 / dbix 1.43 /mysql 5.1 /gentoo / apache2 
> /mod_perl2
> Roy


Last time I looked, NDBcluster still required to be able to fit the 
complete DB into RAM (apart from the other problems).
How large is your database?
Also, ISTR Jesse saying that the DB is not really the bottleneck any 
more (in most cases)  - years after years of optimizations have left 
their traces...

What are your requirements regarding the availability?



cheers,
Rainer