Deploying on OCI with the starter package – half 4 (connecting to the database)

Let’s now see how we are able to connect with our MySQL HeatWave DB System, which was deployed with the OCI Hackathon Starter Equipment in half 1.

We’ve got a number of potentialities to hook up with the DB System, and we are going to use three of them:

1. utilizing MySQL Shell within the command line by way of the compute occasion
2. utilizing MySQL Shell for Visible Studio Code in your improvement machine
3. utilizing Cloud Shell

MySQL Shell within the command line

MySQL Shell is already put in on the Compute Occasion. Generally, if it’s not put in robotically, it’s as a result of the chosen compute form is simply too small. This was the case with the always-free
VM.Normal.E2.1.Micro form. That is mounted within the final model of the stack.

From the deployed compute occasion, when SSH-connected, you’ll be able to launch MySQL Shell and connect with the MySQL HeatWave DBSystem utilizing its non-public IP.

Let’s see all this in video:

MySQL Shell for Visible Studio Code

If we configure the OCI config on our machine, we are able to use MySQL for Visible Studio Code to hook up with the MySQL HeatWave DBSystem by way of a bastion host.

We have to create or replace our ~/.oci/config file to make use of a brand new API Key for our consumer.

OCI Console’s Cloud Shell

You too can use the Cloud Shell from the OCI Console to hook up with your MySQL HeatWave DBSystem.

You want first to make use of an “Ephemeral non-public community” that makes use of your VCN and your non-public subnet:

Then you definately join utilizing the DBSystem’s non-public IP, like within the video:

Conclusion

We noticed how to hook up with the MySQL HeatWave Database occasion utilizing MySQL Shell. Now we are able to create databases, tables, and extra.

Within the following article, we are going to see find out how to join from our programming language.