Thanks Frédéric! So what you're saying is that the current DNS based method for selecting a server is round robin, correct?
On Jan 20, 12:16 am, Frédéric Sidler <[email protected]> wrote: > Neither scalr, not mysql-proxy, nor sqlrelay can propose you to send your > request to the less loaded mysql server. > If you find the "graal", tell me. I'm interested too. But I never found any > other solution than the Round Robin mode. > > On Wed, Jan 20, 2010 at 5:07 AM, Robert <[email protected]> wrote: > > I was asked a question today that I think I know the answer to, but I > > need to confirm and I can't seem to find it written out anywhere. > > > If we have a farm with N MySQL slave instances, how do we select which > > instance to open the connection to? For example when I'm going to do a > > read I need to connect to a slave, but which one? Ideally we'd like > > to select the most lightly loaded instance. > > > I think the answer is that using the domain name for instances of that > > role will randomly (or maybe round-robin) select an instance of that > > role. That doesn't guarantee that the instance we select will be the > > lightest loaded instance, but in general all instances will be loaded > > to about the same level. > > > Is that correct? If not, please clarify. > > > -- > > You received this message because you are subscribed to the Google Groups > > "scalr-discuss" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<scalr-discuss%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/scalr-discuss?hl=en. -- You received this message because you are subscribed to the Google Groups "scalr-discuss" 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/scalr-discuss?hl=en.
