Steps to deploy MDS ( MySql Database Service) @ Oracle cloud

Sathishkumar Rangaraj
Sep 4, 2022
2 min read

Updated: May 3, 2024

Introduction:

What is MDS ?

MySQL Database Service is a fully managed Oracle Cloud Infrastructure native service, developed, managed, and supported by the MySQL team in Oracle

For more information refer here

By using MDS ( Managed Database Service) , we can easily deploy MySql at Oracle Cloud

Why MDS ?

There are many advantages of running MySql as MDS at Oracle cloud

Disclaimer: Above information in chart , is my personal observation. It may be right or may be wrong. no-where associated to oracle

As we see in above chart, various tasks automated by MySQL (MDS) across the entire stack. Everything, which typically need to manually take care in an on-prem environment in terms of hardware, storage, OS and MySQL is automated in oracle cloud.

Architecture - Data Pipe Line

Before, deploying, we will understand how the architecture looks like

Since, MDS deployed in private end point, to access MDS, we should have client instance running in same subnet which acts as jump server or Bastion service at Oracle cloud.

In this demo, we have Compute Instance ( Client VM/Instance) runs in 10.0.0.36 on the same subnet of MDS (10.0.1.120)

So, to access MDS, we should connect via Compute Instance (Client VM/Instance). Since this Client VM/Instance has public ip which starts from 146.x.x.x , this compute instance can be accessed from any machine i.e for example from your laptop

Deployment Procedure

1/ Create Virtual Cloud network

2/ Configure Other network components like

- Dynamic Routing GateWay ( DRG)

- Attach DRG to VCN

- Remote Peering Connectivity ( Optional. However, RPC is required if we like to

create DR site )

- Configure Rules (Route Table)

Add port 3306 and 33060 to access connection of MySql

3/ Once network setup is completed, we can proceed to MDS creation wizard

Note: MDS can be created in any of these types

- 'Standalone' ( Single Instance ) or

- 'High Availability' ( 3-instances MySql DB system with automatic

failover and Zero Data Loss )

- 'Heat Wave' ( MySql DB System that allows Heat-Wave for

accelerated query processing with high performance )

you can watch complete steps here.

4/ Since MDS runs in private network, to access MDS, we should configure compute instance ( client m/c) in same subnet.

- This compute instance acts as jump server to connect MDS.

- Install MySql Shell and associated rpm in client m/c

5/ Test connection from Client m/c @ OCI

6/ MySql WorkBench (optional)

Mysql Work bench is user friendly tool , used to manage MySql Database.

it provides a visual console to easily administrate MySQL environments and gain better visibility into databases. We can download from MySql-Downloads

Once MySql Workbench is installed, proceed to connection parameters