The Stroz

In a post from last year, I talked about how we can view the SQL queries that are run whenever we use the MySQL Document Store API to return JSON documents. If you did not know, when using the Document Store API, the commands are translated into SQL and executed against the database. Sometimes, it is helpful to view the queries to understand how the data is retrieved or manipulated. Now that Database Management in Oracle Cloud Infrastructure is available for MySQL HeatWave instances, I discovered a slightly easier method for viewing these queries.

Apr 30, 2024
4 minutes

This is the sixth (and final) post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a MySQL HeatWave inbound replication channel.

Apr 26, 2024
6 minutes

This is the fifth post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a configuration for MySQL HeatWave instances and how to create a new instance using this configuration.

Apr 18, 2024
12 minutes

This is the fourth post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a read replica of a MySQL HeatWave instance.

Apr 16, 2024
5 minutes

This is the third post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. In this post, we will discuss how to create a backup of a MySQL HeatWave instance and create a new MySQL HeatWave instance from that backup.

Apr 12, 2024
6 minutes

This is the second post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. In this post we will discuss how to list MySQL HeatWaves instances in a compartment and how to update some of the information pertaining to the instance.

Apr 10, 2024
10 minutes

In a previous series, we discussed how we can leverage the TypeScript/JavaScript SDK for Oracle Cloud Infrastructure (OCI) to manage MySQL HeatWave instances. This new series demonstrates how to use the OCI CLI to complete similar tasks. In this post, we will show how to create a MySQL HeatWave instance and retrieve reference information that can help create this new instance.

Apr 08, 2024
14 minutes

This post is the last in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically retrieve reference data that may be needed to manage MySQL HeatWave instances using the SDK.

Apr 04, 2024
7 minutes

This post is the sixth in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically update data of a backup of a MySQL HeatWave instance.

Apr 02, 2024
6 minutes

This post is the fifth in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically create a backup of a MySQL HeatWave instance and create a ‘waiter’ to indicate when the backup is complete.

Mar 13, 2024
8 minutes