OCI Observability and Management for Multi-Cloud Database: Amazon RDS

December 1, 2023 | 6 minute read
Jayaprakash Subramanian
Product Management, Strategic Customer Program for OCI Observability & Management / Enterprise Manager
Text Size 100%:

Multi-cloud has gained importance in recent years as companies distribute their workloads across multiple cloud providers per their unique preferences and convenience.

This blog explains how OCI Observability and Management services, such as Database Management, Stack Monitoring, Operations Insights, and Logging Analytics are used for monitoring RDS database flavors running on Amazon AWS.

Observability and Management: Multicloud Architecture
Figure 1:  Multicloud Architecture: OCI - AWS

Steps to monitor the RDS database on Amazon AWS

  1. IPsec connectivity between OCI and AWS Cloud
  2. Provisioning of AWS Native RDS and RDS Custom Databases on Amazon
  3. Installing Management Gateway and Agent on RDS instances
  4. Discover the RDS database as an External Database
  5. Enable Database Management, Stack Monitoring and Operations Insights
  6. Discover Database System on Database Management

IPsec Connectivity between OCI and AWS

Multiple options are available to establish connectivity between OCI and AWS, we are using an IPsec VPN tunnel using a Site-to-Site VPN with static routing.

Refer to this document for the exact steps:

Prerequisites for connectivity between OCI and AWS:

  1. VPC and the related subnets are created already on AWS.
  2. VNC and subnets are already provisioned on OCI.

Once the connectivity is done, OCI resources will be able to connect to AWS resources via a private network.

OCI Tunnel Status
Figure 2:  OCI Site-to-Site tunnel status
AWS Site-to-Site VPN Status
Figure 3:  AWS Site-to-Site tunnel status

Provision RDS and RDS Custom

Once the connectivity is established, create the desired databases on AWS. There are three options available to provision the databases on AWS.

  1. Amazon RDS Database for Oracle.
  2. Amazon RDS Custom for Oracle.
  3. Database on AWS EC2 instance.

Follow the documentation to create the appropriate database instance.

Install Management Gateway and Management Agent

Use Management Gateway and Management Agent to discover the RDS databases in OCI O&M. Install Management Gateway on the AWS EC2 host which has the public IP address and Management Agent (MACS) on the RDS Custom EC2 instance which is in the private-only subnet.

RDS Database management with MACS Architecture
Figure 4:  RDS Database Management with MACS Architecture

 

  • Download and Install the Management Gateway on the EC2 instance which is on the public subnet.
  • Install the Management Agent on the RDS EC2 instance. Refer to the documentation for installing Management Agent and Gateway.
  • Check the status of the Management Gateway and Management Agent on the OCI console under Observability and Management.
Management Agent list on O&M
Figure 5:  Management Agent list on O&M
  • Install the required O&M service plugins on the Management Agent.

Discover the RDS database as an External Database

After enabling the required plugins, navigate to OCI Menu -> Database Management and Administration. Select the deployment type as External under filters. Select Register External Database to register the RDS database. Refer to the documentation for the steps to discover the Databases.

O&M Database Discovery flow
Figure 6:  External Database Discovery Flow

Follow the steps to discover the CDB and PDB (RDS Custom for Oracle) and non-Container (RDS for Oracle) databases.

Enable Database Management, Operations Insights, and Stack Monitoring

Navigate to the External Database, select the container Database, and Enable Database management, Operations Insights, and Stack Monitoring Services

Enable Database Management for CDB
Figure 7:  Enable Database Management and other O&M services for CDB
Enable Database Management and other services for PDB
Figure 8:  Enable DBM and other O&M Services for PDB

 

Similarly enable all the services for Non-Container Databases.

Here we discovered CDB, PDB, and Non-Containers running on Amazon RDS.

DB Fleet - CDB,PDB, Non-CDB
Figure 9: Database Fleet for Non CDB, CDB and PDB

Similarly, enable those databases for Operations Insights capacity planning to uncover performance issues, forecast consumption, and plan capacity using machine-learning-based analytics on historical and SQL data.

RDS Databases enabled on Operations Insights
Figure 10:  RDS Databases enabled on Operations Insights (PDB & Non-CDB)

Now, "Add hosts" for Operations insights capacity planning.

RDS Hosts enabled on Operations Insights
Figure 11:  Added hosts for Operations insights capacity planning.

Monitor the RDS databases on Stack Monitoring to get full-stack visibility into the health of the Oracle Database. 

RDS Databases on Stack Monitoring
Figure 12:  RDS Databases discovered on O&M Stack Monitoring

Discover Database System on Database Management

Use Database Management services to monitor the database ecosystem such as Oracle Listeners, Automatic Storage Management (ASM), and Clusterware.

Navigate to Database Management -> Administration -> Managed Databases. Select the deployment type as External. Select Discover System on the top menu, then Select External Database System. Refer to the documentation for more details.

Review the Database system details and select Create. The progress can be monitored via the Work Request.

DB System Discovery Summary
Figure 13:  RDS Database System Discovery Summary

Post discovery, navigate to the Managed database and select the database system associated with the database.

This will discover the listener, cluster, and ASM (if available).

Conclusion

OCI Observability and Management services enable seamless integration with multi-cloud to bring the targets together to manage and monitor in a single pane. Start building the dashboards on Database Management, Operations Insights, and Logging Analytics.

Resources

To learn more about the AWS and Observability and Management Services, visit:

 

Jayaprakash Subramanian

Product Management, Strategic Customer Program for OCI Observability & Management / Enterprise Manager


Previous Post

Troubleshoot integration issues in the OCI IAM Microsoft Active Directory Bridge

Ranjini Rajendran | 3 min read

Next Post


Machine learning enhanced real time fraud detection on OCI with NVIDIA Triton Inference Server

David Chen | 9 min read