|
Title: | How to create additional database instances (HP-UX and Linux) |
Document: | 1092064904 |
Author: | Michael Marxmeier (mike at marxmeier.com) |
Keywords: | eloqdb6,instance,HPUX,Linux |
How to create additional database instances (HP-UX and Linux)
This is a simple procedure and basically the same as creating
the first instance.
-
A separate configuration file is needed. Either copy the default
configuration file or copy or the existing eloqdb6.cfg
The name of the configuration file is arbitrary.
Copy the default configuration file:
$ cd /etc/opt/eloquence6
$ cp /opt/eloquence6/newconfig/config/eloqdb6.cfg eloqdb6_2.cfg
When copying an existing eloqdb6.cfg file the existing volume entries
(in the [Volumes] section at the end) need to be removed.
-
Optional: In case the new eloqdb6 instance should run as a different
user/group you should create them now. Otherwise use the same user/group
as with the previous instance.
-
Optional: It is recommended to add a (separate) service name for the
new eloqdb6 instance in the /etc/services file and specify
a port for it. This allows to use the service name instead of the
port number and also documents port number usage.
eloqdb2 8202/tcp # Test server
In this example, the service name is eloqdb2 and the port number 8202.
-
Edit your new configuration file. The following
changes are required/recommended.
- Title = test
-
This allows to distinguish the servers in the process listing.
- Service = eloqdb2
-
This specifies the service name the eloqdb6 instance
should use (a port number, such as 8202 may be used as
well )
- ServiceHttp = 8203
-
In case the HTTP status is enabled, a different port number
must be used for each instance.
- UID = eloqdb
GID = eloqdb
-
Specify the user/group to run this eloqdb6 instance.
- LogFile = /data/log/eloqdb6_2.log
-
If a log file is used it is recommended to use a different log file
for each eloqdb6 instance.
-
Configure autostart for the second eloqdb6 instance. This is defined
in config file /etc/rc.config.d/eloquence6
An entry like below should be added at then end of this file:
ELOQDB6_CFG[1]=eloqdb6_2.cfg
ELOQDB6_ID[1]=test
This specifies the configuration file for the second eloqdb6 instance
(this assumes it resides in the /etc/opt/eloquence6 directory) and
names the instance with the id "test".
-
Create the volume files. This is the same procedure as with the first
instance. However the configuration file needs to specified on the
command line.
$ dbvolcreate -c /etc/opt/eloquence6/eloqdb6_2.cfg db01.vol
$ dbvolextend -c /etc/opt/eloquence6/eloqdb6_2.cfg -t log db02.vol
...
-
Start the server.
/sbin/init.d/eloq6 start test
The id "test" was defined in /etc/rc.config.d/eloquence6
and may be used to specify this instance (also works for stop, etc).
To access the "other" instance the database name needs to specify
the service/port number of the instance (eg. :eloqdb2/DB).
An easier (recommended) alternative is to set the EQ_DBSERVER
environment variable to specify the server.
export EQ_DBSERVER=:8202
|
|