You would want to evaluate Mysql cluster properly before you use it.It has high resource utilization especially memory and it keeps ur network busy by just doing the replication.<br>I haven't heard much sucess with the mysql cluster as yet and it still is a work in progress before it gains high use.
<br>The livejournal pdf document mentioned above is a nice place to start for such things.<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://danga.com/words/2005_oscon/oscon-2005.pdf" target="_blank">
http://danga.com/words/2005_oscon/oscon-2005.pdf</a><br><br><br><div><span class="gmail_quote">On 10/13/06, <b class="gmail_sendername">Serhat Sakarya</b> <<a href="mailto:serhat@sakarya.nl">serhat@sakarya.nl</a>> wrote:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><span class="q">On 10/13/06, <b class="gmail_sendername">Kevin Burton</b> <<a href="mailto:burton@tailrank.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
burton@tailrank.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
We really suffer from MySQL replication scalability issues. Basically you can scale reads but not writes.......<br clear="all"><br>I'm
thinking of migrating some portions of our app to MySQL cluster because
basically it's an all memory DB and (in theory) should scale linearly
if we need to index more data.
</blockquote></div><br></span>
It's not going scale linearly in practice exactly because you're going
to have writes and communication overhead between the nodes. With a
memcached backend, you'll get much closer to actual linear scalability
because there is no internal communication necessary.<br>
<br>
I would be looking more for the advantage of failover/reliability in
clustering the DB backend and use memcached for the actual scalability.<br>
<br>
Regards,<br><span class="sg">
<br>
Serhat<br>
</span></blockquote></div><br>