Recently we saw how we can catch audit information using invisible column, JSON data type and triggers in MySQL 8.0: Poorman’s MySQL table audit information Poorman’s MySQL table audit information – part 2 Of course, the creation of these triggers…
I really enjoyed to dig into the solution I described yesterday in this post, to generate table audit information using invisible columns and triggers. In this post, I will focus only on the solution using a JSON column to store…
Today, somebody asked me how he could track the creation of a record (who created it and when) and who and when it was last modified. Usually, this is performed in a different table, called audit table. In MySQL you…
Apache Airflow is an open-source workflow management platform for data engineering pipelines. Today we will see how we can deploy very easily Apache Airflow on a Compute instance in Oracle Cloud Infrastructure (OCI) using MySQL HeatWave Database Service (MDS). I…
Let’s start with some info about how MySQL Document Store handles JSON documents. Document Store and CRUD We know that MySQL 8.0 Document Store handles JSON documents with CRUD operations. We can add, delete and modify those documents very easily:…
MySQL Database Service on OCI is all over the tech news with the latest HeatWave ML announcement [1][2][3][4][5]. This article explains how to perform a live migration of your Azure/MySQL to OCI As Azure allows public connections directly to the…
For a future article, I was again looking into the possibility of using sysbench to generate data and load on a MySQL database. However, I needed an SSL connection which only version 1.1.0 supports (see issue 308). Alexey didn’t create…
When using cloud native application architectures, Functions have an important role for the business logic without managing any infrastructure. Functions is a serverless platform powered by the Fn Project open source engine. These Functions are mostly used to create and…
If like me you like to share some data between all your devices (presentations, keypassX file, pictures, …), you probably use a cloud platform to store all that. I do like to keep control of such solution, I used ownCloud…
This post is the final one of a series of articles on extending MySQL with the Component Infrastructure: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending…
On the previous article we saw how to easily deploy Apache Zeppelin on OCI with MySQL using Terraform. In this article we will see how we can accelerate queries enabling MySQL HeatWave. Enabling HeatWave If you used a MySQL Database…
Recently, somebody requested some help as he was trying to modify the structure of a large table. The requested modification was related in changing a fixed length string to a variable length string column. If you don’t know it yet,…