Documentation Home
MySQL Shell for VS Code

MySQL Shell for VS Code  /  View MySQL Resources  /  ORACLE CLOUD INFRASTRUCTURE View

Pre-General Availability: 2023-05-24


The ORACLE CLOUD INFRASTRUCTURE view lists all of the configuration profiles defined in the ~/.oci/config file on your system. MySQL Shell for VS Code identifies and highlights your default profile, if indicated, by checking the definition in ~/.oci/oci_cli_rc.

For example, the following figure shows that the mysqltooling (us-ashburn-1) profile is indicated as the default. A refresh action in the toolbar enables to update your profile information, including all of the compartment nodes contained under each profile.

Figure 3.3 MySQL Shell for VS Code - OCI View

Content is described in the surrounding text.

To open profiles in ORACLE CLOUD INFRASTRUCTURE view, you must first create a connection to your existing account in an Oracle Cloud Infrastructure (OCI) tenancy (see Section 4.2.5, “Configure a Connection Using MySQL Database Service (MDS)”).

Each profile contains a hierarchical listing for:

  • Your default compartment (identified by a highlighted folder icon).

  • An OCI compartment tree for each configuration profile's tenancy.

  • All subordinate compartments, MySQL DB Systems, Compute Instances, Bastions, and Load Balancers of the given compartment.

The next figure shows an open /(Root Compartment) with its subordinate Development compartment node also open. Under the node is a compute instance, MDS DbSystem (and endpoints), a bastion host, and more.

Figure 3.4 MySQL Shell for VS Code - OCI Endpoints

Content is described in the surrounding text.

Each of the child nodes in MySQLRestServices entry (except for the load balancer) has a specific context menu with actions.

MySQL DB System actions

  • Create Connection via Bastion Service

  • Create MySQL Router Endpoint on new Compute Instance

Endpoint actions

  • Open SSH Bastion Session

  • Delete Compute Instance

Bastion actions for DB systems

  • Set as Current Bastion

  • Delete Bastion

  • Refresh When Bastion Reaches Active State