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 cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
