Rainer Duffner wrote:
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?
The db is around 18G and Growing .. (average 1200 tickets a day) .. as
far as I know NDBcluster require just the indexes in memory ..I might be
wrong.
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?
Its not really a question of availability as much as performance .. in
my case the bottleneck is the db .. (the db server is dual cpu 2.8G and
6G memory) ..
the web server is very much similar spec and the performance graphs
showing no signs of stress , where the db server is in most cases at
peak (cpu and memory) ..
I have applied every patch Jesse have recomended and to be fair there
isn't a single query that I can blame ..
What do you recommend ?
Roy
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
