Configure Oracle Connection

Course Project: Configure connection load balancing

During the simulation, you configured Net8 for connection load balancing by editing the tnsnames.ora file.
The code you created should look something like this:

PETS_USA =
   (DESCRIPTION =
     (LOAD_BALANCE=ON)
     (FAILOVER=ON)
     (ADDRESS_LIST =
       (ADDRESS = 
        (PROTOCOL = TCP)
        (HOST = PORTLAND.HOUSEOPETS.COM)
        (PORT = 1521))
       (ADDRESS = 
        (PROTOCOL = TCP)
        (HOST = SEATTLE.HOUSEOPETS.COM)
        (PORT = 1521))
       (ADDRESS = 
        (PROTOCOL = TCP)
        (HOST = DAVIS.HOUSEOPETS.COM)
        (PORT = 1521))
     )
     (CONNECT_DATA =
      (SERVICE_NAME = HOUSEOPETS.COM)
     )
   )

Oracle Database Administration

Here are suggested answers to your questions.

List the other components that must be configured and the parameters you must use to complete the connection load balancing for the example in the simulation.

Answer 1: The database itself must be started up with these parameters in place: SERVICE_NAMES (set to a common name for all nodes); INSTANCE_NAME (a unique name for each instance); and MTS_DISPATCHERS (to configure the dispatchers for the database instance). Also, the listener for the database must be configured with an address entry for all of the nodes that are to share load balancing.

Why does load balancing make sense for a distributed set of servers that connects its nodes via the Internet?

Answer 2:

Connection load balancing would help in two important ways. First, because the Internet can sometimes lose service to certain geographic areas, a node in the area that lost service can be supported by the databases in other geobraphic areas that did not lose service. Second, the database load would be distributed to all the nodes evenly, regardless of which node first received the connection request, so no single node becomes overloaded.