List:General Discussion« Previous MessageNext Message »
From:Charles Sprickman Date:July 26 2004 8:09pm
Subject:mysql libs and multiple hostnames
View as plain text  
Sorry to re-send, but I lost some mail and thought perhaps this was
answered and I missed it, but looking at the archives I don't see any
replies.

Thanks!

Charles

I have a quick question about how programs linked against the mysql C
libraries handle the following:

-assume three mysql hosts, say 10.0.0.2, 10.0.0.3, and 10.0.0.4
-assume a dns name "db.example.com" that returns the following:
 bob@xena[~]$ host db.example.com
 db.example.com has address 10.0.0.2
 db.example.com has address 10.0.0.3
 db.example.com has address 10.0.0.4

If my client program repeatedly connects to "db.example.com" and my
nameserver round-robins through those IPs, will the client also keep
cycling through those?  What is the behaviour if one of those hosts does
not respond?  Will the client application then try the next one?

Thanks,

Charles

___
Charles Sprickman
NetEng/SysAdmin
Bway.net - New York's Best Internet - www.bway.net
spork@stripped - 212.655.9344

Thread
mysql libs and multiple hostnamesCharles Sprickman26 Jul
  • Re: mysql libs and multiple hostnamesJeremy Zawodny27 Jul