Failover and Load Balancing

Failover

tbJDBC provides capability to recover some resources automatically when you initiate a connection in a typical application or TAC configuration, or when the connection is lost during a job processing. This capability is referred to as failover.

Configuring Failover

To use the failover capability, specify the URL of DriverManager.getConnection() in a description format and configure FAILOVER.

Set FAILOVER to one of the following values.

The following example enables failover. When an attempt to connect to svr1 fails, an automatic reattempt occurs to connect to svr2. If all attempts to connect to every server fail, an error occurs.

Connection conn = 
    DriverManager.getConnection("jdbc:tibero:thin:@(description=(failover=session)" +
                                "(address_list="+ 
                                "(address=(host=svr1)(port=8629))"+ 
                                "(address=(host=svr2)(port=7629))"+
                                ")(DATABASE_NAME=TACUAC))", "tibero", "tmax");

Failover-related Connection Properties

The following property specifies the maximum number of reattempts to reestablish a connection when the failover capability is enabled.

• failover_retry_count

The following properties prevent a client from waiting for a connection infinitely when the client cannot detect a disconnection because of an error.

• login_timeout

• read_timeout

• self_keepalive

Load balancing

tbJDBC provides also an ability to distribute users across multiple nodes in a typical application or TAC configuration, to increase the efficiency of database servers. This ability is referred to as load balancing.. To use the load balancing capability, specify the URL of DriverManager.getConnection() in a description format, and add (load_balance=on).

The following example enables load balancing to distribute users to svr1 and svr2 when initiating connection to servers.

Connection conn = 
    DriverManager.getConnection("jdbc:tibero:thin:@(description=(load_balance=on)"
+
                                "(address_list="+ 
                                "(address=(host=svr1)(port=8629))"+ 
                                "(address=(host=svr2)(port=7629))"+ 
                                ")(DATABASE_NAME=TACUAC))", "tibero", "tmax");