psm MySQLCS service

Display information about a single MySQL Cloud Service instance in the identity domain.

Syntax

In the following syntax, line breaks have been added for clarity. Do not include them when entering the command.

psm MySQLCS service -s|--service-name instance-name 
    [-of|--output-format json|html|short]

Parameters

Parameter	Description
-s|--service-name instance-name	Specifies the name of the MySQL Cloud Service instance.
-of|--output-format json|html|short	(Optional) Specifies the output format of the command’s response: json—output is formatted as a JSON array. html—output is formatted as HTML short—output is formatted as a brief summary. The default output format is the one you specified when using the psm setup command to configure the psm CLI.

Examples

The following example displays information about the MySQL57–aas instance.

$ psm MySQLCS service --service-name MySQL57-aas
{
   {
    "BACKUP_DESTINATION":"BOTH",
    "CLOUD_STORAGE_CONTAINER":"Storage-Storage/Test1",
    "DATA_VOLUME_SIZE":"25G",
    "LOCAL_BACKUP_VOLUME_MOUNT":"/u01/backup",
    "LOCAL_BACKUP_VOLUME_SIZE":"50G",
    "MYSQL_PORT":"3306",
    "_platform_tools_root_":"/u01/app/oracle/tools/paas/bin/platform",
    "_tools_mount_":"/u01/app/oracle/tools",
    "_tools_root_":"/u01/app/oracle/tools/mscs",
    "adminHostName":"test1-mysql-1",
    "attributes":{
        "BACKUP_DESTINATION":{
            "displayName":"Backup Destination",
            "isKeyBinding":false,
            "type":"STRING",
            "value":"BOTH"
        },
        "CLOUD_STORAGE_CONTAINER":{
            "displayName":"Cloud Storage Container",
            "isKeyBinding":false,
            "type":"STRING",
            "value":"Storage-Storage/Test1"
        },
        "DATA_VOLUME_SIZE":{
            "displayName":"Usable Database Storage",
            "isKeyBinding":false,
            "type":"STRING",
            "value":"25G"
        },
        "LOCAL_BACKUP_VOLUME_MOUNT":{
            "displayName":"Backup Volume Location",
            "isKeyBinding":false,
            "type":"STRING",
            "value":"/u01/backup"
        },
        "LOCAL_BACKUP_VOLUME_SIZE":{
            "displayName":"Backup Volume Size",
            "isKeyBinding":false,
            "type":"STRING",
            "value":"50G"
        },
        "MYSQL_PORT":{
            "displayName":"MySQL Port",
            "isKeyBinding":true,
            "type":"INTEGER",
            "value":"3306"
        }
    },
    "backup":{
        "lastBackupDate":"Thu Jun 09 00:05:00 GMT 2016",
        "lastFailedBackupDate":"Thu Jun 09 14:47:09 GMT 2016",
        "operationInProgress":{}
    },
    "components":{
        "mysql":{
            "adminHostName":"test1-mysql-1",
            "attributes":{
                "CONNECT_STRING":{
                    "displayName":"Connect Descriptor",
                    "isKeyBinding":true,
                    "type":"STRING",
                    "value":"10.252.132.237:3306/myDOCdatabase"
                },
                "shape":{
                    "displayName":"Compute Shape",
                    "isKeyBinding":false,
                    "type":"SHAPE",
                    "value":"oc3"
                }
            },
            "componentId":2,
            "creationDate":"2016-06-07T11:58:50.000+0000",
            "instanceName":"mysql",
            "instanceRole":"NONE",
            "serviceId":2,
            "state":"READY",
            "version":"5.7",
            "vmInstances":{
                "test1-mysql-1":{
                    "componentType":"mysql",
                    "creationDate":"2016-06-07T11:58:50.000+0000",
                    "hostName":"test1-mysql-1",
                    "ipAddress":"10.252.132.237",
                    "isAdminNode":true,
                    "label":"test1 mysql MYSQL_SERVER 1",
                    "publicIpAddress":"10.252.132.237",
                    "role":"MYSQL_SERVER",
                    "servers":{
                        "MySQL":{
                            "creationDate":"2016-06-07T11:58:50.000+0000",
                            "provisionStatus":"PENDING",
                            "serverId":2,
                            "serverName":"MySQL",
                            "serverRole":"MYSQLCS_ROLE",
                            "serverStateDisplayName":"Ready",
                            "serverType":"MASTER",
                            "state":"READY"
                        }
                    },
                    "shapeId":"oc3",
                    "state":"READY",
                    "totalStorage":117760,
                    "usageType":"MYSQL_SERVER",
                    "vmId":2,
                    "vmStateDisplayName":"Ready"
                }
            }
        }
    },
    "computeSiteName":"siteB",
    "creationDate":"2016-06-07T11:58:50.948+0000",
    "creator":"creatorName",
    "domainName":"domain",
    "edition":"EE",
    "editionDisplayName":"Enterprise Edition",
    "keyComponentInstance":"mysql",
    "metaVersion":"1.0.0-160606",
    "meteringFrequency":"HOURLY",
    "meteringFrequencyDisplayName":"Hourly",
    "patching":{
        "currentOperation":{
            "operation":"NONE"
        },
        "totalAvailablePatches":1,
        "updateStatus":"NORMAL_PENDING"
    },
    "releaseVersion":"5.7.12",
    "serviceDescription":"Test1",
    "serviceId":2,
    "serviceLevel":"PAAS",
    "serviceLevelDisplayName":"MySQL Cloud Service",
    "serviceName":"Test1",
    "serviceStateDisplayName":"Running",
    "serviceType":"MySQLCS",
    "serviceVersion":"5.7",
    "state":"READY",
    "storageContainer":"Storage-Storage/Test1",
    "subscription":"HOURLY"
}

}