Yup Sean
On Nov 21, 6:40 pm, Mike Lewis <[EMAIL PROTECTED]> wrote: > So what your saying is put the load balancer IP Address for the > slave.host.ip ? > > var $default = array( > 'driver' => 'mysql', > 'host' => 'slave.host.ip', > 'login' => '....', > 'password' => '.....', > 'database' => 'my_db' > ); > > - > Mike > > On Nov 21, 3:39 pm, SeanW <[EMAIL PROTECTED]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
