2 Getting Started with Oracle Cloud Marketplace
This chapter provides an introduction to Oracle GoldenGate on the Oracle Cloud Marketplace.
Overview
Oracle GoldenGate on Oracle Cloud Marketplace provides pre-installed versions of Oracle GoldenGate and offers the same benefits, scalability, security, and robustness that you can rely on for your enterprise replication needs.
Resources
The Oracle GoldenGate image on Oracle Cloud Marketplace contains the latest Oracle GoldenGate release that is available at the time of provisioning an instance.
The Oracle GoldenGate software is installed on the compute node
under the /u01/app directory.
Supported Compute Shapes
Oracle GoldenGate runs on different OCI Compute Sizes. The following table provides details on the supported OCI Compute Sizes:
| Compute Shape | OCPU | Memory (GB) | Max Network Bandwidth |
|---|---|---|---|
| VM.Standard2.1 | 1 | 15 | 1 Gbps |
| VM.Standard2.4 | 4 | 60 | 4.1 Gbps |
| VM.Standard2.8 | 8 | 160 | 8.2 Gbps |
| VM.Standard2.16 | 16 | 240 | 16.4 Gbps |
| VM.Standard2.24 | 24 | 320 | 24.6 Gbps |
| VM Standard 3 Flex | 1 to 32 | 16 to 512 | ? |
| VM Standard E3 Flex | 1 to 32 | 16 to 512 | ? |
| VM Standard E4 Flex | 1 to 32 | 16 to 512 | ? |
For pricing details on compute nodes, please refer to OCI Pricing.
Block Storage
The following table provides details on the default block storage configuration used by Oracle GoldenGate on Oracle Cloud Marketplace.
| Volume | Default Size | Configurable |
|---|---|---|
| Boot | 50GB | Yes |
| Swap | 256GB | Yes |
| Trail | 512GB | Yes |
| Deployments | 128GB | Yes |
| Cache Manager | 128GB | Yes |
For pricing details on block storage, please refer to Oracle Storage Cloud Pricing.
Cross Cloud Functionality
Oracle GoldenGate is designed for large scale, cloud based architectures and Oracle GoldenGate on Oracle Cloud Marketplace is a key to many cloud-based solutions. By using Oracle GoldenGate from the Oracle Cloud Marketplace, you can replicate data from on premise to the Oracle Cloud, between data points within the Oracle Cloud, or even between third party clouds.
Network Recommendations
The network recommendations listed here primarily apply for Oracle to Oracle replication, but the general rules apply to all platforms supported by Oracle GoldenGate. This applies to Oracle GoldenGate on-premise, in 3rd party clouds, in the Oracle cloud, and OCI GoldenGate.
- For Capture: Network latency is critical for performance throughput of an Extract and it is recommended to ensure that the Marketplace deployment is in the same region, or as close as possible, to the database server.
- For Replicat: If you run Oracle GoldenGate remotely (on a separate server from the database that Oracle GoldenGate is applying changes to) then the round trip ping time must be less than 5ms.
- For Oracle GoldenGate to Oracle GoldenGate communication: The Oracle GoldenGate trail files grows at about 30-40% of the generated redo log volume (if you are capturing 100% of the data). That means that Oracle GoldenGate sends about 30-40% of the generated redo log volume across the network. If the network is not able to scale to this volume, then you can enable compression on the trail file data being sent across the network. This compression can typically achieve 8:1 compression ratios or better. You can also modify the TCP window socket size and buffers as well.
The following table provides a matrix on cross cloud support for replication by using Oracle GoldenGate on the Oracle Cloud Marketplace:
Table 2-1 Oracle GoldenGate Cross-Cloud Support
| Technology | Remote Capture | Remote Apply |
|---|---|---|
|
Oracle Cloud Infrastructure |
Yes |
Yes |
|
Amazon Web Services (AWS) |
Yes |
Yes |
|
Microsoft Azure |
Yes |
Yes |
| Google Cloud Service | Yes | Yes |