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 Shorts – Top 5 Countdown – #4
For the last year, we have been producing a series of short-form videos titled “MySQL Shorts”. Each video focusses on a specific topic and are typically less than 5 minutes long. For our Advent Calendar of Content for 2024, we will be counting down the top 5 MySQL Shorts vidoes based on views as of […]
MySQL Shorts – Episode #47 Released
The latest Episode of MySQL Shorts is now available! Check out Episode 047 on the MySQL YouTube Channel. In this video we talk about how you can use a CASE operator in a JOIN to dynamically determine which column should be matched in an ON clause.
Applying Database Migrations in MySQL HeatWave With GitHub Actions
In a previous post, I talked about how we can leverage GitHub Actions to automate running tests whenever a commit is made to a specific branch of a GitHub repository. In this post, we will discuss one way we can harness GitHub Actions to apply database migration scripts to a MySQL HeatWave Database Service instance running in Oracle Cloud Infrastructure (OCI). The […]
Migrate from MariaDB to MySQL HeatWave: easier with MySQL Shell 8.2.1
I won’t cover reasons why you should migrate from MariaDB to MySQL, I already covered the topic in previous blogs and webinars: In this post, I will cover a new easier way to migrate using the latest MySQL Shell 8.2.1 and the copyInstance() utility. Previously, if you wanted to migrate to MySQL HeatWave (the name […]
MySQL Shorts – Top 5 Countdown – #5
For the last year, we have been producing a series of short-form videos titled “MySQL Shorts”. Each video focusses on a specific topic and are typically less than 5 minutes long. For our Advent Calendar of Content for 2023, we will be counting down the top 5 MySQL Shorts videos based on views as of […]
Deliver applications with machine learning-powered recommendations
Recommender systems are one of the most sought-after applications of machine learning as they’ve proven to drive significant revenue. For example, Netflix’s recommendation system drives about 80 percent of the content streamed on the platform. While we may not always realize it, personalized recommendations have a significant impact on many aspects of our lives, such […]
MySQL at DOAG 2023 – recap
Last week, from November 21 to 24, the DOAG Conference took place in Nuremberg, Germany. The MySQL Team was present at the Oracle booth. I attended the conference Thursday and Friday. There were 20 sessions tagged “MySQL” and one full day workshop dedicated to students. I delivered the first part of the workshop dedicated to […]
Performance Improvements in MySQL 8.0.35
Performance Improvements in MySQL 8.0.35 The MySQL team has recently implemented changes that significantly improve the performance of the 8.0.35 version of MySQL Enterprise Edition over the Community Edition. Benchmarks sysbench is a tool that is widely used for database benchmarks, especially for MySQL An adaptation of sysbench was used to run various OLTP […]
EXPLAIN INTO and EXPLAIN FOR SCHEMA in MySQL
EXPLAIN INTO The INTO clause for EXPLAIN introduced in MySQL 8.1 allows storing the output of an EXPLAIN query in a user variable, instead of returning it to the client. It is currently only supported for the JSON format, but that should be sufficient for most use cases. With the EXPLAIN output stored in a […]
MySQL Workshop at HKCE and PyCon HK2023 – recap.
In November 2023, we were invited by “Hong Kong Association for Computer Education” HKACE to deliver a Database Workshop with a large group of secondary school teachers. It was a great time to meet up with over 100+ teachers in a very big computer hall in Hong Kong City University. In HK secondary school education, […]