Deploying MySQL on OCI using OpenTofu
I could have set MySQL between parenthesis in the title as this article is more about how to use OpenTofu to deploy on OCI. I will explain how to install OpenTofu and how to use it to deploy on OCI.…
Category MySQL
JSON in MySQL HeatWave: why is data or my query not off-loaded to HeatWave Cluster ?
We recently saw that we can benefit from using JSON documents with MySQL HeatWave cluster in OCI (HeatWave accelerator for MySQL Database Service). However sometimes the data can’t be loaded to HeatWave Cluster or the query cannot use it. And…
MySQL Document Store in OCI with MySQL HeatWave
Since the release of MySQL 8.0, the MySQL X Dev API has provided users with the convenient ability to utilize MySQL without the need to write a single line of SQL! MySQL X Dev API brings the support for CRUD…
WordPress in OCI with MySQL HeatWave Read Replicas and MySQL Router R/W Splitting
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB.…
MySQL data archiving: another use for HeatWave Lakehouse
The ability to store data on Object Storage and retrieve it dynamically when necessary is a notable advantage of Lakehouse when managing MySQL historical data we would like to archive. Let’s illustrate this with the following table: You can notice…
