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.
