Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
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 […]
Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave !
This post is the third and last 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. We can now start a query on our MDS instance that has been populated with >200M rows: SQL > SELECT […]
Tips to Optimize MySQL Applications Query Performance
Performance issues are often stubborn things to cure. Suddenly a query or operation seems slow, or slower-ish. Sadly, the database is often pointed at as the culprit by developers who are either positive their code cannot be at fault or those who see databases as a mysterious box that does odd things at the direction […]
MySQL Performance Tuning: Top 10 Easy Tips
MySQL is a proven, reliable database that is quick to set up easy to maintain, and has outstanding performance. However, that performance can usually be improved with the judicious use of the following tips that are all easy to implement. The best way to proceed is to work with one schema or database and go […]
Deploy WordPress on OCI using MySQL Database Service
In this post, I describe you how to deploy WordPress on OCI using MySQL Database Service. I wrote some Terraform recipes that you can find on my GitHub repository: oci-wordpress-mds. I will show how easy it’s to deploy directly from OCI’s dashboard using Resource Manager’s stack. I will also share the recent additions. The first think […]