This example takes place in root compartment, therefore there is a layer of simplicity when implemeting the deployment of an MySQL instance using OCI CLI
n.b: Those that wish to know more about the json file involved in creating MySQL instance, can run the following command:
root@deploymentmachine:/home/tests/mydb# oci db system launch --generate-full-command-json-input > createdb.json
root@deploymentmachine:/home/tests/mydb# head createdb.json
{
"adminPassword": "string",
"autoBackupEnabled": true,
"availabilityDomain": "string",
"backupNetworkNsgIds": [
"string",
"string"
],
"backupSubnetId": "string",
"characterSet": "string",
root@deploymentmachine:/home/tests/mydb#
Since this is a very simple example, our final json file to use for building the MySQL instance:
root@deploymentmachine:/home/tests/mydb# more mydb.json
{
"adminUsername": "usertest",
"adminPassword": "wildpasswp0rdhere",
"compartmentId": "ocid1.tenancy.oc1..aaaaaasomefakecompartmentidinhereaaaaa323423422",
"display-name": "MysqlSmallTest",
"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": "mysqltest",
"listener-port": 1521,
"node-count": 1,
"maxWaitSeconds": 0,
"shapeName": "MySQL.VM.Standard.E3.1.8GB",
"subnetId": "ocid1.subnet.oc1.eu-frankfurt-1.aaaaaaaafakesubnetidoverhere123242343"
}
4. To create the MySQL instance, run the following command:
root@deploymentmachine:/home/tests/mydb# oci mysql db-system create --from-json file://mydb.json
n.b: If any issues with your json file, you would receive an error output.
Suppose I have allocated only 40Gb for my dataStorageSizeInGb, I would be receivig a ServiceError as below:
root@deploymentmachine:/home/tests/mydb# oci mysql db-system create --from-json file://mydb.json
ServiceError:
{
"code": "InvalidParameter",
"message": "dataStorageSizeInGBs must be greater than or equal to 50",
"opc-request-id": "F7701BCD165B457F9A3BE0DE2A4154EE/1E2E000F4E221DE35B00BAC58EA0FBC4/5E77DF6AAB3A1D3DEEB8DF9003D0694C",
"status": 400
}
4.1 If all good when running command, for the our json file we should receive an output as following:
