To enable HA for Oracle GoldenGate to make Oracle GoldenGate highly available, additional installation and configuration operations are required. These operations supplement the standard installation and standard configuration of the Oracle GoldenGate instance.
The procedure in this section describes the installation and configuration of an Oracle GoldenGate instance.
The following resource group is created in this procedure.
Storage Resource group to contain the following resource:
Storage resource (required in the case of failover resource groups, but optional for multiple master resource groups)
Database resource group, to contain the following resources:
Database resource
GoldenGate resource
Logical hostname for the resources (required in the case of failover resource groups)
Before You Begin
Ensure that the /etc/netmasks file has IP-address subnet and netmask entries for all logical hostnames. If necessary, edit the /etc/netmasks file to add any missing entries.
In failover topologies, Oracle GoldenGate requires shared storage, so you must make your storage highly available. For example, you can create a resource group containing the HAStoragePlus resource managing the global file systems.
# clresourcegroup create storage-rg
Specifies the name of the resource group to be created. Choose a unique name for each resource group within the cluster.
# clresourcetype register SUNW.HAStoragePlus
# clresource create -g storage-rg \ -t SUNW.HAStoragePlus \ -p filesystemmountpoints=mountpoint-list \ hsp-rs
Specifies that the resource is to be added to the Oracle GoldenGate storage resource group.
Specifies that the resource is an instance of the SUNW.HAStoragePlus resource type.
Specifies a list of valid mount points for the file system. For more information, see the SUNW.HAStoragePlus(5) man page.
Specifies the name of the resource that you are creating.
The resource is created in the enabled state.
# clresourcegroup online -M storage-rg
Specifies that the resource group is to be brought into the managed state.
Specifies the name of the resource group to be brought online.
The Oracle GoldenGate instance resource group can be configured as a failover or multiple master resource group to contain the resource for the database and the Oracle GoldenGate resource. If the Oracle GoldenGate instance is configured as a failover resource, the logical hostname for this resource is also contained in the Oracle GoldenGate resource group.
To create a failover resource group, run the following command:
# clresourcegroup create db-rg
To create a multiple master resource group, run the following command:
# clresourcegroup create \ -p Maximum_primaries=value \ -p Desired_primaries=value \ db-rg
Specifies the maximum number of primary nodes for this multiple master resource group.
Specifies the desired number of primary nodes for this multiple master resource group.
Specifies the name of the resource group to be added. This name can be your choice but must be unique for the resource groups within the cluster.
If the resource group that you created in Step 6 is configured as a multiple master resource group, skip this step.
# clreslogicalhostname create -g db-rg db-logical-hostname
Specifies the name of the resource group.
Specifies the logical hostname db-logical-hostname of the Oracle GoldenGate resource. By default, the name of the logical host resource is set to the same name as this. If you wish to specify a separate name, then place the name of the resource at the end of the command listing.
# clresourcegroup online -M db-rg
Specifies that the resource group is to be brought into the managed state.
Specifies the name of the resource group that needs to be brought online.
Install your database software and make the database highly available using an Oracle Solaris Cluster resource.
The following is a list of several databases and a link to the corresponding documentation.
If you plan to use Oracle as the database, configure the Oracle Solaris Cluster HA for Oracle data service. For more information about the data service, see Oracle Solaris Cluster Data Service for Oracle Database Guide .
If you plan to use MySQL as the database, configure the Oracle Solaris Cluster HA for MySQL data service. For more information about the data service, see Oracle Solaris Cluster Data Service for MySQL Guide .
You also can develop your own resource type or use a generic data service to make your database highly available. For more information, see Oracle Solaris Cluster Data Services Developer’s Guide .
If you have a specific agent associated with your database, then use the configuration procedure for the data service in your database.
Follow the instructions in the Oracle GoldenGate installation manual to install the Oracle GoldenGate software. You will also need to configure the replication between the different Oracle GoldenGate instances.