Hey pete:<br>ndb is a pseud cluster solution provided for mysql it acts as loadbalancer and failover solution. And actually ultramonkey layer 7 is using it for mysql loadbalancing.<br>Unfortunatelly ndb doesnt work well by itself.
<br>Thanks mate <br><br>Offtopic:Do you guys have a kind of meeting everyweeks or something like that?(im new in london-england-europe)<br><br><br><div><span class="gmail_quote">On 3/27/07, <b class="gmail_sendername">Pete Ryland
</b> <<a href="mailto:pdr@pdr.cx">pdr@pdr.cx</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;">On 27/03/07, xx xx <
<a href="mailto:garciaj@gmail.com">garciaj@gmail.com</a>> wrote:<br>> Oh yeah is mature and should be stable (to stay in the current kernel).<br>> I'm already using ultra monkey with ndb it works almost perfect theres some
<br>> issues but are fully ndb related.<br><br>Do you mean nbd, the netblock device?<br><br>> Have you ever tried to loadbalance mysql ? should be """"EASY"""" , i mean<br>> the replicacation is very ""stable"" since
3.23 so i think it can be done<br>> easly with libpcap (while mysql is compiled without ssl).<br>> I mean the basic idea is to separate what is "select" statements from<br>> modification statements (inserts alter updates bla bla).
<br><br>Perhaps the Ultramonkey-L7[1] stuff may help with that. I'm pretty<br>sure it's all geared towards web stuff, but with a bit of work could<br>probably be made to work with mysql as well (I'm not that familiar
<br>with the workings of recent mysqls, I'd usually favour postgres for<br>serious work, but perhaps look at the mysql docs to see what options<br>they suggest for the type of solution you are after). Anyway, this is
<br>probably not the ideal way to do it: in my opinion, it would be better<br>only to use load balancing between the clients and the frontends of<br>your system if you can.<br><br>> Thank you very much pete it was really helpfull.(ipvs howto)
<br><br>No problem.<br><br>Pete<br><br>[1] <a href="http://ultramonkey-l7.sourceforge.jp/index_en.html">http://ultramonkey-l7.sourceforge.jp/index_en.html</a><br><br>--<br><a href="mailto:ubuntu-uk@lists.ubuntu.com">ubuntu-uk@lists.ubuntu.com
</a><br><a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk">https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk</a><br><a href="https://wiki.kubuntu.org/UKTeam/">https://wiki.kubuntu.org/UKTeam/</a><br></blockquote>
</div><br>