This is the second article of the series dedicated to MySQL trending. As I wrote before, understanding your workload and seeing the evolution of it over time can help anticipating problems and work on solutions before the breakdown. This article…
This is the first article of a new blog series related to MySQL books. Let’s start with MySQL Workshop, a practical guide to working with data and managing databases with MySQL written by Thomas Pettit and Scott Cosentino. The editor…
We are getting many requests for migration from MariaDB to MySQL. Here is a quick guide and steps to follow: On the MariaDB server: Create a logical dump of MariaDB (using MySQL Shell) Create a dedicated user for replication [optional]…
In a previous post, I explained how you can collect and plot metrics using MySQL Shell. This is a new series of article where I will explain how to read and understand some of the generated graphs. Understanding your workload…
When it’s time for a new MySQL release, it’s also time to thank our contributors ! Released on April 26th, MySQL 8.0.29 contains several contributions from our awesome Community and on behalf of the entire MySQL Team, I would like…
I could have also called this article When Pandas meet Dolphins in MySQL Shell. Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL. Since then, the MySQL…
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…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.