[Deploying Sakai] MySQL clustering

[Kusnetz, Jeremy]

NDB doesn't support foreign  keys, and can be slow joining when the data
is on different nodes.  Besides the Sakai documentation states in
multiple places that NDB won't work.

 

NDB works best for simple queries without joins and databases that do
not need foreign keys. 

 

From: warwick.chapman at gmail.com [mailto:warwick.chapman at gmail.com] On
Behalf Of Warwick Chapman
Sent: Thursday, March 18, 2010 8:55 AM
To: Kusnetz, Jeremy
Cc: production
Subject: Re: [Deploying Sakai] MySQL clustering

 

Why won't NDB clustering work?

 

I did an implementation for a 100% uptime production line management
system last year where read/writes were shared between nodes in the
MySQL Cluster (NDB).  They still use it, seems solid and faster than the
single system they had before...

 

Notes from that one attached.

On Thu, Mar 18, 2010 at 2:15 PM, Kusnetz, Jeremy <JKusnetz at apus.edu>
wrote:

I'm not talking about NDB clustering, I know that won't work.

Has anyone run Sakai with MySQL replication, writes going to a master
and reads going to many slaves?

Any success with MySQL Proxy to redirect write and read requests?

What about using a commercial/community clustering software like
Continuent http://www.continuent.com/ ?

It's not clustering, but what about an alternate high performance engine
like solidDB?

We are in the early stages of deploying Sakai and I'm thinking about
long term scalability.
_______________________________________________
production mailing list
production at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/production

TO UNSUBSCRIBE: send email to
production-unsubscribe at collab.sakaiproject.org with a subject of
"unsubscribe"

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100318/24b35d90/attachment.html