This chapter describes how to set up database multiplexing mode, and how to check it.
Users who perform setup and operations
Setup and operations of the database multiplexing mode must be performed by the instance administrator user.
The instance administrator user must also be registered as a database superuser.
Note
When executing the initdb command, specify the -U option, and only perform operations in which the instance administrator user (who is the command execution user) is also a database superuser.
If an operation in which the instance administrator user is not a database superuser is performed, Mirroring Controller will be unable to connect to the instance, and therefore will not be able to perform error monitoring for the database multiplexing mode.
Before starting the setup, ensure that the times in both servers match, by using the operating system time synchronization feature, for example.
The tolerated difference is approximately one second.
If the system times are not synchronized (because the tolerated difference is exceeded, for example), problem investigation may be affected.
Perform the procedure in the table below to set up database multiplexing mode.
Database multiplexing mode uses the streaming replication feature. If you know how to set up streaming replication, the setup of database multiplexing mode will be easy.
Step | Task | Refer to | |
|---|---|---|---|
Primary server | Standby server | ||
1 | Installation | ||
2 | Preparing the backup disk | ||
3 | Setting up database multiplexing mode | 6.3.1 Setting up Database Multiplexing Mode on the Primary Server | |
4 | Creating, setting, and registering the instance | 6.3.2 Creating, Setting, and Registering the Primary Server Instance | |
5 | Setting up database multiplexing mode | 6.4.1 Setting up Database Multiplexing Mode on the Standby Server | |
6 | Creating, setting, and registering the instance | 6.4.2 Creating, Setting, and Registering the Standby Server Instance | |
7 | Confirming the streaming replication status | ||
8 | Setting up the PL/extJava environment | ||
9 | Creating applications | ||
10 | Checking the behavior | ||
Explanations for each step are provided below.
Information
The setup procedure is also the same when changing the mode on a single server to database multiplexing mode. In this case, omit the installation of Symfoware Server and the creation of the instance.
Refer to "7.7.2 Changing from Single Server Mode to Database Multiplexing Mode" for details.
The primary and standby server can be pseudo-configured on the same server for system testing, for example. In this case, the setup can be performed using the same procedure, however there will be some supplementary steps.
Before performing the setup, refer to "Appendix C Supplementary Information on Building the Primary Server and Standby Server on the Same Server".
