Chapter 7: Load Balancing, Failover, and Component Availability

Modifying the client connection information

On UNIX platforms, set these values in your interfaces file:

Server1
   master tcp ether Server1-host 5000
   query tcp ether Server1-host 5000
   hafailover Server2

Server2
   master tcp ether Server2-host 5001
   query tcp ether Server2-host 5001
   hafailover Server1

On Windows platforms, set these values in the%JAGUAR%\ini\sql.ini file:

[Server1]
master=NLWNSCK,Server1-host,5200
query=NLWNSCK,Server1-host,5200
hafailover=Server2

[Server2]
master=NLWNSCK,Server2-host,5300
query=NLWNSCK,Server2-host,5300
hafailover=Server1