contact contact

How to create additional database instances (HP-UX and Linux)


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:

    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

  Privacy | Webmaster | Terms of use | Impressum Revision:  Mon Aug 9 17:48:49 2004  
  Copyright © 1995-2004 Marxmeier Software AG