Deploy MySQL instances

Deploying three MySQL instances with the help of OCI CLI (for more details on how to proceed with OCI CLI creation for MySQL instance, review "The basics OCI CLI" )

Each of the three database has been deployed in a different Availability Domain; Each of these three databases have the same compartmentID and subnetID

Json file for deploying 1st DB database:

root@deploymentmachine:/home/tests/mydb# more mydb1.json
{
  "adminUsername": "usertest",
  "adminPassword": "wildpassw0rd#",
  "compartmentId": "ocid1.tenancy.oc1..aaaaaaaafakecompartmentidfromhereonh3h3h3h3h3",
  "display-name": "MysqlSmallTest1",
  "availabilityDomain": "Aodz:EU-FRANKFURT-1-AD-1",
  "databaseEdition": "STANDARD_EDITION",
  "dataStorageSizeInGbs": 50,
  "dbName": "mysqlTest",
  "dbVersion": "19.6.0.0",
  "description": "Just a small mysql db test",
  "port": 3306,
  "port-x": 33060,
  "hostname": "mysqltest1",
  "listener-port": 1521,
  "node-count": 1,
  "maxWaitSeconds": 0,
  "shapeName": "MySQL.VM.Standard.E3.1.8GB",
  "subnetId": "ocid1.subnet.oc1.eu-frankfurt-1.aaaaaaaafakesubnetidfromhereonh3h3h3h3h3""
}

Deploy 1st DB with command:

root@deploymentmachine:/home/tests/mydb# oci mysql db-system create --from-json file://mydb1.json

Json file for deploying 2nd DB database:

root@deploymentmachine:/home/tests/mydb# more mydb2.json
{
  "adminUsername": "usertest",
  "adminPassword": "wildpassw0rd#",
  "compartmentId": "ocid1.tenancy.oc1..aaaaaaaafakecompartmentidfromhereonh3h3h3h3h3",
  "display-name": "MysqlSmallTest1",
  "availabilityDomain": "Aodz:EU-FRANKFURT-1-AD-2",
  "databaseEdition": "STANDARD_EDITION",
  "dataStorageSizeInGbs": 50,
  "dbName": "mysqlTest",
  "dbVersion": "19.6.0.0",
  "description": "Just a 2nd small mysql db test",
  "port": 3306,
  "port-x": 33060,
  "hostname": "mysqltest2",
  "listener-port": 1521,
  "node-count": 1,
  "maxWaitSeconds": 0,
  "shapeName": "MySQL.VM.Standard.E3.1.8GB",
  "subnetId": "ocid1.subnet.oc1.eu-frankfurt-1.aaaaaaaafakesubnetidfromhereonh3h3h3h3h3""
}

Deploy 2nd DB with command:

root@deploymentmachine:/home/tests/mydb# oci mysql db-system create --from-json file://mydb2.json

Json file for deploying 3rd DB instance:

root@deploymentmachine:/home/tests/mydb# more mydb3.json
{
  "adminUsername": "usertest",
  "adminPassword": "wildpassw0rd#",
  "compartmentId": "ocid1.tenancy.oc1..aaaaaaaafakecompartmentidfromhereonh3h3h3h3h3",
  "display-name": "MysqlSmallTest1",
  "availabilityDomain": "Aodz:EU-FRANKFURT-1-AD-3",
  "databaseEdition": "STANDARD_EDITION",
  "dataStorageSizeInGbs": 50,
  "dbName": "mysqlTest",
  "dbVersion": "19.6.0.0",
  "description": "Just a 3rd small mysql db test",
  "port": 3306,
  "port-x": 33060,
  "hostname": "mysqltest3",
  "listener-port": 1521,
  "node-count": 1,
  "maxWaitSeconds": 0,
  "shapeName": "MySQL.VM.Standard.E3.1.8GB",
  "subnetId": "ocid1.subnet.oc1.eu-frankfurt-1.aaaaaaaafakesubnetidfromhereonh3h3h3h3h3""
}

Deploy 3rd DB with command:

root@deploymentmachine:/home/tests/mydb# oci mysql db-system create --from-json file://mydb3.json

If no output errors after running command "oci mysql db-system create", check the Oracle Cloud UI:

Do not forget the Ingress rules for MySQL services:

The deployed instances have following private IPs:

10.0.0.28, 10.0.0.30, respectively 10.0.0.32