![]() ![]() ![]() ![]() ![]() ![]() |
This chapter provides an overview of the process of installing the database for use with WebLogic Network Gatekeeper.
Note: | Individual files names are given in the form: filename<version>.type. As an example, the file referred to as jrockit-j2sdk<version>.bin.gz could have the full name jrockit-j2sdk1.4.2_05-linux-ia32.bin.gz |
Although there are substantial differences among the installation procedures for each type of database, all installation types include the following basic steps:
Use these instructions if you are using Oracle 10g with RAC as your database. For more information on using WLS RAC with multidatasource configuration, see also http://download.oracle.com/docs/cd/E13222_01/wls/docs100/jdbc_admin/oracle_rac.html.
Note: | This is the only database configuration supported for production environments that require High Availability. |
Oracle 10g RAC must be installed on dedicated servers not running in the cluster building up the WebLogic Network Gatekeeper.
Define the number or of processes to be equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity
) times the number of Network Gatekeeper servers in the cluster. MaximumCapacity is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 for both datasources.
Network Gatekeeper must be configured with an additional set of parameters to make it work correctly with the database. This action is performed during the domain configuration phase. See Configuring the Domain for Network Gatekeeper for more information.
Follow the instructions in this section if you are using a Oracle 10g single instance as your database.
The Oracle 10g instance must be installed on a dedicated server not running in the cluster building up the WebLogic Network Gatekeeper.
Define the number or of processes to be equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity
) times the number of Network Gatekeeper servers in the cluster. MaximumCapacity is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 for both datasources.
Network Gatekeeper must be configured with an additional set of parameters to make it work correctly with the database. This action is performed during the domain configuration phase. See Configuring the Domain for Network Gatekeeper for more information.
Follow the instructions in this section if you are using MySQL as your database.
Note: | MySQL is not supported in environments that require High Availability. |
MySQL can be installed either on a server in the cluster building up the WebLogic Network Gatekeeper or on a separate server. If it is installed in the cluster, it should be in the same server as the Network Tier.
Before you start, make sure you have the appropriate installation binaries (4.1.22 and higher bugfix releases for 4.1) for your platform. The binaries can be downloaded from http://www.mysql.com.
The following is a summary of the commands needed to install MySQL on some versions of Linux. You should check the specific instructions for your version. It assumes an installation directory of /usr/local:
groupadd mysql
useradd -g mysql mysql
cd /usr/local
ln -s /usr/local/mysql-standard-<version> mysql
cd mysql
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
chgrp -R mysql .
bin/mysqld_safe --user=mysql &
max_connections
is equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity
) times the number of Network Gatekeeper servers in the cluster. MaximumCapacity is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 for both datasources. For example:[mysqld]
set-variable=max_connections=400
You should also add settings for default character set and storage engine:
set-variable=default-character-set=<desired character set>
Note: | The recommended character ste is latin1. If you need to use a multibyte character, such as UTF-8, you should select the InnoDB storage engine. |
set-variable=default-storage-engine=<desired default storage engine>
Note: | The recommended default storage engine is MYISAM. |
The Windows version is available with a GUI installer. Detailed instructions on using the installer are available at the MySQL web site. Unless you need to install the database in a non-standard location, you can select Typical Install.
You can also use the Instance Configuration Wizard to do configuration basics. (Use the default choice unless specified below):
Note: | The recommended usage type is Non-transactional Database unless you are using a multibyte character set such as UTF-8, in which case you should use Multifunctional or Transactional. |
wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity
) times the number of Network Gatekeeper servers in the cluster. MaximumCapacity is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 for both datasources. Use the dropdown menu. You can change this value later if necessary.Note: | The recommended character set is Latin1. If you need to use a multibyte character set such as UTF-8, make sure you have selected Multifunction or Transactional as your usage type. |
GRANT ALL ON *.* TO <Network Gatekeeper database user>@'<ip-address>' IDENTIFIED BY '<password>'
You must do this for every IP address in the cluster.
CREATE DATABASE <database name>
![]() ![]() ![]() |