Most of those protocols are balanced at layer 4 (IP and port), the load balancer has no knowledge of the underlying protocol. Just balance port 3306 across your slaves, it'll work just fine.
Sean On Nov 21, 12:18 pm, Mike Lewis <[EMAIL PROTECTED]> wrote: > I realize that but as far as I know Load Balancers only these > protocols: > > HTTP > HTTPS > FTP > POP3 > SMTP > IMAPv4 > DNS > Telnet > LDAP > > I'm not to sure if connecting to a DB is anywhere in there. > > So from a application standpoint is there anyway to do some rotation > and/or random act to using multiple slave servers. > > - > Mike > > On Nov 21, 9:08 am, SeanW <[EMAIL PROTECTED]> wrote: > > > For multiple slave servers I'd look at a load balancer, either > > hardware or ipvs + heartbeat. There's more than just "which server do > > I send it to?", there's also making sure the server is alive and not > > too lagged. > > > Sean > > > On Nov 20, 8:24 pm, Mike Lewis <[EMAIL PROTECTED]> wrote: > > > > I saw a post about setting up one slave server (http:// > > > groups.google.com/group/cake-php/browse_thread/thread/58ea010f930fab6c/ > > > df64d493b24d5a67?lnk=gst&q=master+slave+mysql&rnum=1), but I'm > > > assuming thats not how you set up multiple slave servers. Quoting > > > fromhttp://www.alertra.com/article446.php: > > > > "If necessary, set up multiple slave servers all replicating from the > > > same master. Design your application to distribute SELECT queries > > > across all available slaves in some type of rotating or random > > > fashion. Once this basic infrastructure is in place, you can simply > > > add more slaves as query volume increases." > > > > Is there a simple way of doing this in CakePHP? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
