If you tried to migrate live from Amazon RDS/Aurora or any other Cloud to OCI MySQL HeatWave before December 6, 2022, you may have encountered issues with Amazon to OCI asynchronous replication. See: Live Migration from Azure Database for MySQL to MySQL Database Service on OCI This is because Amazon (an other Cloud) writes to […]

In this article, I will guide you through the process of setting up a fully functional Zabbix monitoring system on Oracle Cloud Infrastructure. The deployment and configuration of the Zabbix server and web frontend, as well as the integration with MySQL HeatWave Database Service as backend, is totally automated using OCI Resource Manager Stack (Terraform). […]

Drupal is a popular open-source content management system (CMS) that is used by businesses, governments, and organizations around the world to build and manage websites. It is known for its flexibility, scalability, and security features. On 14th December, Drupal launched the latest upgrade to its popular software. In this article, we will guide you through […]

As you know, MySQL 8.0 can be used as JSON Document Store to store your documents without being linked to any schema. You can also use CRUD operations to deal with these documents using the MySQL X DevAPI. Of course in documents, it’s possible to also store temporal attributes like date, time, datetime, … Let’s […]

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 run different tasks. They can be executed using Fn Project CLI, OCI CLI or a […]

For this last technical post of the MySQL Community Advent Calendar 2022, I will explain how to grant privileges to users in MySQL 8.0. This is an important task for anyone who is responsible for managing a MySQL database, as it allows you to control which users have access to which parts of your database. […]

Since MySQL 8.0.30, the Dynamic InnoDB Redo Log is a new feature that allows users to resize the redo log files on the fly without the need for a restart. This is a significant improvement over previous versions of MySQL, where the redo log files had to be manually resized and the database had to […]

In this blog, we will discuss what UUIDs are and how to use them in MySQL 8.0. We will also explore the advantages and disadvantages of using UUIDs and their different types.  Whether you are new to UUIDs or an experienced user, this blog will provide valuable insights and tips for using UUIDs in MySQL […]

In this blog post, we will discuss how to display long transactions in MySQL 8.0. Having transactions running for a long time can lead to performance issues and can cause the database to become unresponsive. In order to avoid these issues, it is important to monitor and manage long transactions in your database. In this […]

Apache Airflow is a powerful tool for managing and scheduling data pipelines. It allows you to define your data processing workflows as directed acyclic graphs (DAGs) and manage their execution in a scalable and reliable manner. In this blog, I will explain how to deploy Apache Airflow on Oracle Cloud Infrastructure (OCI) with MySQL HeatWave […]