Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Successful RDS to OCI MySQL HeatWave Migration with Replication Channel Filters
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 […]
How to Deploy Zabbix with MySQL HeatWave Database Service in OCI
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). […]
How to grant privileges to users in MySQL 8.0
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. […]
Dynamic InnoDB Redo Log in MySQL 8.0
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 […]
MySQL & UUIDs
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 […]
Welcome Drupal 10 ! – How to easily deploy Drupal 10 on OCI with MySQL HeatWave
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 […]
MySQL Cluster 8.0.31 Transparent Data Encryption
With MySQL Cluster you can now from version 8.0.31 use transparent data encryption (TDE). Together with the encrypted backup feature it encrypts all data persisted on disk for tables that uses the Ndb storage engine in MySQL. This complements other already existing features that encrypts data at rest in MySQL. TDE encryption uses XTS-AES and […]
MySQL 8.0 Document Store – How to deal with date & time
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 […]
MySQL 8.0: How to display long transactions
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 […]
Using OCI Serverless Functions and API Gateways to create logical dumps of a MySQL HeatWave Database Service with MySQL Shell
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 […]