This section explains points to consider when creating applications while in database multiplexing mode.
See
Refer to the Cluster Operation Guide (Database Multiplexing) for information on database multiplexing mode.
Refer to "Application Development" in the Cluster Operation Guide (PRIMECLUSTER) for points to consider when creating applications using the failover feature integrated with the cluster software.
If an application connection switch occurs while in database multiplexing mode, explicitly close the connection and then reestablish the connection or reexecute the application.
The table below shows errors that may occur during a switch, and the corresponding action to take.
State | Error information (*1) | Action | |
|---|---|---|---|
Server failure | Failure occurs during access | 57P01 57P02 YE000 26000 40001 | After the switch is complete, reestablish the connection, or reexecute the application. |
Accessed during system failure | 08001 | ||
Switch to the standby server | Switched during access | 57P01 57P02 YE000 26000 40001 | |
Accessed during switch | 08001 | ||
*1: Return value of SQLSTATE.
