[Deploying Sakai] MySQL clustering

[Warwick Chapman]

Ah, ok :)

-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com


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

>  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/ee1bbf23/attachment-0001.html