D.4 Changing the settings of an embedded database in a cluster configuration
This section describes the system definition related to a cluster that can be changed.
The system definition described in this section is the system definition that is set in the system common definition file. The system common definition file is located in the following directory:
- In Windows:
-
embedded-database-practical-directory\conf\pdsys
- In UNIX:
-
embedded-database-practical-directory/conf/pdsys
The system common definition file is created by using the ajsembdbbuild command, so edit this file after you execute the ajsembdbbuild command.
You can change the following clustering system definitions:
-
Starting the embedded database, pd_mode_conf =
You can set the following values for pd_mode_conf:
-
MANUAL1
The embedded database is started manually. However, if it terminates abnormally, it is restarted automatically.
-
MANUAL2
The embedded database is started manually. Unlike MANUAL1, if the embedded database terminates abnormally, it is not restarted automatically.
-
AUTO
The embedded database is started automatically. When the OS starts, the embedded database starts automatically. If the embedded database terminates abnormally, it is restarted automatically.
-
If the environment was set up with the -r or -f option when the ajsembdbbuild command was executed, the initial value of pd_mode_conf is MANUAL2.
Specify MANUAL1 or MANUAL2 in a cluster configuration. Change the value to match the environment that will be set up.
To edit the system common definition file:
-
On the primary node:
-
Stop the scheduler service that uses the embedded database.
-
Stop the embedded database.
-
Edit the system common definition file.
-
Start the embedded database.
-
Start the scheduler service that uses the embedded database.
-
-
On the secondary node:
After completing the tasks on the primary node, use either of the following operations to change the system common definition file:
-
Copy the system common definition file edited on the primary node to the secondary node environment.
-
Edit the system common definition file so that the result is the same as the editing result in step 3 for the primary node above.
-