Installing Vector for Linux
Vector for Linux is distributed in RPM, DEB, and non-package manager (ingbuild) format.
Install libaio
The Linux Asynchronous I/O library, libaio, must be installed before installing Vector.
Libaio has a huge performance benefit over the standard POSIX asynchronous I/O facility because the operations are performed in the Linux kernel instead of as a separate user process.
Note: The Vector installer may install libaio automatically or flag it as missing, depending on the Vector distribution you downloaded.
To install libaio
Using RPM:
rpm ‑ivh libaio*.rpm
Using the yum system update tool:
yum install libaio
Using Ubuntu:
apt-get update
apt-get install libaio1
Import GPG Public Key (RPM and DEB Only)
The RPM and DEB packages are signed with a GPG key pair to ensure their authenticity. To enable the installation process to verify the packages, the public key must be downloaded and imported into the package management system.
The GPG public key file can be downloaded from the same location as the distribution:
http://esd.actian.com/.
To import the key
Specify the key file name on the appropriate command. For example:
Using RPM:
rpm --import actian-vector-6.0.0-100-com-linux-rpm-x86_64-key.asc
Using Ubuntu:
apt-key add actian-vector-6.0.0-100-com-linux-deb-amd64-key.asc
install.sh Command--Install Vector
The install.sh command can be used for both interactive and unattended installs.
Note: Not all command flags are valid for all distribution formats.
Debian/Ubuntu: The DEB distribution installs Vector under /opt/Actian/Vector; this location cannot be changed. Only one DEB instance per machine is allowed. If you want to install Vector in a different directory or install more than one instance on a machine, download the ingbuild distribution.
This command has the following format:
install.sh [-interactive|-express] [‑acceptlicense]
[-uid uid] [-user username] [-noroot] [-usesudo]
[-withad|-noad] [-respfile filename] [-?|‑help] [instance_ID] [install_dir]
-interactive
Installs interactively, prompting for all configuration options. (For advanced users only.)
Note: For RPM and DEB installs, prompting is limited. For full control, use a response file or the GUI installer.
-express
Installs with no user prompts (implies -acceptlicense.)
-acceptlicense
Accepts all license prompts.
-uid uid
Specifies the user ID (UID) to be used when creating user. The username must exist. (Disallowed with -noroot.) (Not valid for RPM and DEB.)
-user username
Installs as username instead of actian. The username must exist. (Disallowed with -noroot.) (Not valid for RPM and DEB.)
-noroot
Installs Vector as the current user. All installation locations must exist and be writable as current user for the installation to succeed. Instance will be owned by current user. (Not valid for RPM and DEB.)
-usesudo
Installs Vector using the current user and invokes sudo for root access, locally and remotely. The instance is owned as “actian” by default. If required, the current user is used for remote connections and sudo is invoked for root access. (Not valid for RPM and DEB.)
-withad | ‑noad
Installs or excludes Actian Director.
-respfile filename
Uses filename as the response file when running setup. The absolute path to the filename must be specified. A response file lets you customize the installation. (Requires -express or ‑acceptlicense; not valid with ‑interactive.)
instance_ID
Defines a two-character string where the first character must be an uppercase letter and the second character must be an uppercase letter or a number from 0 to 9.
install_dir
Specifies the full path to the location where Vector is to be installed (II_SYSTEM).
Note: Not valid for DEBs, in which case II_SYSTEM is hard coded to: /opt/Actian/VectorVW.
-? | ‑help
Displays usage information.
Notes:
• install.sh will fail if another instance of Vector exists with the same instance ID as the one being installed.
• If logged in as a user other than "actian", after install.sh completes, do the following:
1. Log off from the current user.
2. Log on as the "actian" system user and source .ingXXsh (where XX is the instance ID), which is found in the home directory ($HOME) of the "actian" system user.
Install Vector at the Command Line
You can install Vector using the installation shell script install.sh for package manager or non-package manager (ingbuild) distributions.
To install Vector at the command line
1. Copy the distribution TGZ file to a location where other users and not just root can read it, for example, /tmp.
Running the installer from a location such as /root will not work because other users do not have read access to this directory.
2. Unpack the distribution TGZ file. For example:
tar xf actian-vector-6.0.0-100-com-linux-ingbuild-x86_64.tgz
Note: You may need to use the z option, depending on the version of tar.
actian-vector-6.0.0-100-com-linux-ingbuild-x86_64
3. Change to the directory created in the previous step. For example:
cd ./actian-vector-6.0.0-100-com-linux-ingbuild-x86_64
4. Enter the following command as the root user to run the installation utility:
./install.sh
If you are logged in as a user other than root, use sudo to run the utility:
sudo ./install.sh
The installation utility starts.
5. Respond to the installation prompts.
All components are installed as user "actian" in the location: /opt/Actian/VectorVW/.
When the installation is complete, the instance is running.
Examples of install.sh Command
The .install.sh command will install package manager or non-package manager (ingbuild) distributions.
Examples for package manager distributions:
1. Install all packages with an instance ID of V1, prompting for other configuration options:
./install.sh ‑interactive V1
2. Install all packages with the default configuration into "/opt/VectorV2", with an instance ID of V2, without further prompting:
install.sh ‑express /opt/VectorV2 V2
Note: Not valid for DEBs, whose II_SYSTEM cannot be changed.
Examples for Ingbuild distribution:
1. Install Vector with default configuration, prompting for basic configuration options:
./install.sh
2. Install Vector under /opt/VectorV2, with an instance ID of V2 with a default configuration without further prompting:
install.sh -express /opt/VectorV2 V2
3. Install Vector, prompting for all configuration options:
./install.sh -interactive
Install Vector as a User Other than root
Vector can be installed without requiring full root access by using one of the following flags on the install.sh command.
Note: These flags are supported with the ingbuild distribution only.
-noroot
Installs Vector as the current user and does not require root access. All installation locations must exist and be writable as current user.
For example:
./install.sh -noroot
-usesudo
Installs Vector using the current user and invokes sudo for root access.
For example:
./install.sh -usesudo
Install Vector Using RPM Commands
You can install Vector by invoking RPM directly.
Vector packages that can be installed include the following:
• Core--Prerequisite of all other packages
• DBMS--DBMS Server
• Net--Communications servers
• Director--Actian Director
To install a single package
Invoke RPM with the appropriate installation flags, including the path of the package you want to install, as follows:
rpm ‑Uvh path_to_directory/Vector_package.rpm
To install more than one package at a time
Pass multiple file names, specifying the path to each package, as follows:
rpm ‑Uvh path_to_directory/Vector_package.rpm path_to_directory/Vector_package2.rpm path_to_directory/Vector_package3.rpm
To install all packages in the same directory
Specify the following:
rpm ‑Uvh path_to_directory/*.rpm
To install a package into a non-default location (that is, with an II_SYSTEM value other than the default)
Use the -‑prefix flag when invoking RPM. The following command installs the specified package with II_SYSTEM=/home/actian/VectorVZ:
rpm ‑Uvh ‑‑prefix=/home/actian/VectorVZ path_to_directory/Vector_package.rpm
Notes:
• The default instance ID is VW regardless of the installation directory. To change the instance ID, you must rebuild the RPM packages with a unique name, as described in
Installing Multiple RPM Package Instances.
• All packages installed in a single instance must have the same value of II_SYSTEM. So if you use the -‑prefix flag to install the base package, you must install all subsequent packages with the same --prefix value.
• After you have installed Vector using the RPM command, you must run the service script to configure the instance.
Installing Multiple RPM Package Instances
To install multiple Vector instances on one machine using RPM, you need a unique set of package names for each instance. You must rebuild each RPM packages to include an instance ID that is unique to the machine. You can then install this package using the instructions described in
Install Vector Using RPM Commands.
To rebuild the package, use the iirpmrename command. Multiple RPMs can be specified for renaming.
For example, to rebuild the base package named actian-vector-6.0.0-000.rpm to use an II_INSTALLATION of XX, issue the following command:
iirpmrename [path_to_directory]/actian-vector-6.0.0-000.rpm XX
A new RPM package is created in the current working directory called actian-vector-XX-6.0.0-000.rpm. The package will install with II_SYSTEM=/opt/Actian/VectorXX and II_INSTALLATION=XX.
Notes:
• While you can still override the value for II_INSTALLATION using the response file or other methods mentioned above, we do not recommend it.
• The rpm-build package must be installed for iirpmrename to work.
Configure and Start the Instance
When installing Vector using the RPM command, you must complete the setup portion of the installation process by running the service script. The service script configures and starts the instance.
To configure the instance
After the installation has completed, run the service script as follows:
/etc/init.d/actian-vectorXX configure
where XX is the instance ID.
To set up Vector by running the configuration defined in a response file:
/etc/init.d/actian-vectorXX configure /path/to/response/file
The instance is configured but not started.
To run the setup programs with their default configuration and start the instance
After the installation has completed, run the service script as follows:
/etc/init.d/actian-vectorXX start
where XX is the instance ID.
The instance is configured and started.
How to Access the Instance on Linux
To access your instance, you must source the environment file that was written to the home directory ($HOME) of the operating system user ID defined during installation (the default is "actian").
The name of the environment file depends on the value of II_INSTALLATION:
.ingXXsh or .ingXXcsh
where XX is the instance ID.
To source the environment file created during installation
Issue the following command. (The following example assumes an operating system user ID of actian.)
source ~actian/.ingXXsh
For other users to access the instance and the Vector tools, they must have access to the .ingXXsh and .ingXXcsh scripts. The scripts can be copied to the home directory of any user.
Virtual Address Space Allocation (Linux)
For optimal performance, Vector by default allocates a large amount of virtual address space to be able to use it most efficiently when needed. In some circumstances, this amount can be larger than the amount of physical memory.
Some Linux distributions by default disallow reserving unlimited virtual address space. We recommend that you configure your system to allow unlimited allocation of virtual address space unless there are compelling reasons (unrelated to Vector) not to.
To check if your system allows unlimited allocation of virtual address space:
# cat /proc/sys/vm/overcommit_memory
should return 1.
# ulimit –v
should return unlimited.
To ensure the system does not limit allocation of virtual address space
Issue these commands after every system restart:
# echo 1 > /proc/sys/vm/overcommit_memory
# ulimit –v unlimited
To learn how to make this setting persistent, refer to your Linux documentation.
Alternatively, Vector can be configured to not reserve virtual address space by setting the [memory] max_overalloc configuration parameter to 0. This may limit the maximum performance your system can deliver.
Note: If your system limits allocation of virtual address space by default, such allocation is automatically turned off in Vector during installation. If you reconfigure your system after Vector is installed to allow unlimited allocation of virtual address space, then you must also set the max_overalloc parameter correctly (to 2G by default).
Configuring the High Availability Option for Red Hat Cluster Suite
The mkrc utility can generate a service script, ha_actian-vectorXX, that can be used to monitor and control the Vector instance in the cluster. The script is distributed as a template, ha.rc, in $II_SYSTEM/ingres/files/rcfiles.
Install the Cluster Service Script
To set up the cluster service for the Vector database, follow these steps:
1. Install Vector onto a shared disk, visible to all nodes to be used for failover. For example:
$ sudo -s
$ II_HOSTNAME=clustername ./install.sh HA /sharedisk1/VectorHA
2. After the DBMS setup portion of the installation process completes, set the II_HOSTNAME environment variable to the cluster name. For example:
ingsetenv II_HOSTNAME=clustername
3. Edit ~/.ingXXsh so that the host name will be set on each node. Insert at the beginning:
II_HOSTNAME=clustername
export II_HOSTNAME
4. Log in as the instance owner and source the instance environment:
$ ~/.ingXXsh
where XX is the Actian Vector instance ID.
5. Generate and install RC service scripts:
Vector:
$ source ~/.ingXXsh
$ mkrc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -i"
Edit the RC script to include the cluster name. Edit /etc/init.d/actian-vectorXX and insert the following line after export II_SYSTEM=/opt/Actian/IngresXX:
export II_HOSTNAME=clustername
Management Server for Actian Director (if installed):
$ source ~/.ingXXsh
$ mkrc -s iimgmtsvc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s iimgmtsvc -i"
Edit the RC script to include the cluster name. Edit /etc/init.d/iimgmtsvcXX and insert the following line after export II_SYSTEM=/opt/Actian/IngresXX:
export II_HOSTNAME=clustername
6. Generate the HA service script:
$ source ~/.ingXXsh
$ mkrc -s ha
7. As root, install the HA service script:
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s ha -i"
8. For each node in the cluster, copy the installation environment script to the 'actian' home directory and the RC scripts to /etc/init.d/:
$ scp ~/.ingXXsh clusternode2:/home/actian
The cluster service is configured.
9. Verify the script has been installed correctly:
$ ls -l /etc/init.d/ha_actian-vectorXX
-rwxr-xr-x. 1 root root 1064 May 29 19:34 /etc/init.d/ha_actian-vectorXX
$ chkconfig ha_ingresXX --list
ha_actian-vectorXX 0:off 1:off 2:off 3:off 4:off 5:off 6:off
Note: It should be off by default.
You should be able to start, display the status, and stop the DBMS on each node:
# systemctl start ha_actian-vectorXX
# systemctl status ha_actian-vectorXX
# systemctl stop ha_actian-vectorXX
10. Add the ha_actian-vectorXX service script into the cluster configuration as a resource.