Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Setup Disaster Recovery for OCI MySQL Database Service
When you create a MySQL Database Service instance in OCI, you have the choice between 3 types: If you have minutes as RTO (Recovery Time Objective) in case of a failure, you must choose a High Availability instance that will deploy a Group Replication Cluster over 3 Availability Domains or 3 Fault Domains. See Business […]
Point-in-Time Recovery in OCI MDS with Object Storage – part 1
To setup point-in-time recovery for MDS using Object Storage, these are the prerequisites: In this article, I won’t focus on how to create a MDS instance, a compute instance, enable backups and Object Storage Bucket, this is easy and there is already a lot of literature about them (you can also check several of my […]
Point-in-Time Recovery in OCI MDS with Object Storage – part 2
In part 1 of the series about Point-in-Time Recovery in OCI MDS, we saw how to stream the binary log to Object Storage. In this blog post, we will see how we can restore the data up to certain point. The high level process is simple: The scenario We have an application that constantly write […]
Oracle MySQL Scores Big Race Victory at Silverstone
GT Cup 2021 For racing, as for the cloud, performance matters; and a few second faster will make a difference between win and lose. Team Greystone GT and Oracle MySQL Database Service with HeatWave score maiden race win with Mason and Lancaster in GT Cup Greystone GT became race winners for the first time as Rich Mason […]
MySQL Database Service: Authenticate using OCI IAM
Overview Identity is a critical component of security. The OCI MySQL Database Service (MDS) enables DBAs to leverage existing OCI User Identites and Group Memberships for authentication into MySQL Database Service Instances, providing increased security, centralized management, and ease of use. Using this feature, an MDS instance can validate a connecting user via the users OCI IAM API Key. This enables DBAs to centrally manage MDS […]
Faster CRC32-C computation in MySQL 8.0.27
In this post I’d like to explain a big optimization in CRC-32C computation, inspired by a paper by Gopal, V., et al.: “Fast CRC computation for iSCSI Polynomial using CRC32 instruction” from Intel, which landed in MySQL 8.0.27 and hugely increases the processing speed (the improvement for ARM64 architectures is more pronounced for reasons explained […]
MySQL 8.0 – InnoDB Parallel Threads for Online DDL Operations
MySQL 8.0.27 introduced a new variable to control the maximum of parallel threads InnoDB can use for creating (sorting and building) secondary indexes: innodb_ddl_threads. This new variable is coupled with another new variable: innodb_ddl_buffer_size. If you have fast storage and multiple CPU cores, tuning these variables can speed up secondary index creation. For this example, […]
Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System
This post is the first of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. In this first article we will start by creating a MySQL DB System and a Compute instance in OCI. One of the […]
MySQL Query Optimization: Top 3 Tips
MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries. One – The MySQL Query Optimizer wants to optimize your […]
Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System
This post is the second of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. Before we start, I would like to highlight that the fastest and recommended way to import data to a MySQL DB System […]