The latest from the MySQL community

Upgrading MySQL is often seen as straightforward — install the new binaries, restart, done. In reality, it’s more like upgrading a production jet engine mid-flight. Small changes in defaults, deprecated settings, or old privileges can lead to surprises you don’t want at 2:00 AM on maintenance night. Or even worse, see your performance deteriorating during the peak of business activity.

Fortunately, MySQL Shell ships with a utility to help validate whether your server is actually ready before you pull the trigger: util.checkForServerUpgrade().

In this post, we’ll walk you through the installation of MySQL Shell and running the upgrade checker.

Installing MySQL Shell

If you don’t already have MySQL Shell available on your server, install it first. Packages are available at:

…

Discover how to use transactions in MySQL to keep your data safe and organized—just like a diligent librarian! This beginner-friendly post explains what transactions are, why they matter, and how to use them with easy library metaphors, clear SQL examples, and essential tips for database reliability.

Data masking lets you hide sensitive fields (emails, credit-card numbers, job titles, etc.) while keeping data realistic for reporting, support, or testing. It is particularly useful when you collaborate with external entities and need to share your data for development reasons. You also need to protect your data and keep your customers’ privacy safe. Last […]

On October 10th, 2025, we released MySQL 9.5, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can see contributions related to Connector J and Connector Net, as well as to different server categories. Connector / J […]

MySQL 9.5 has been released, here is a list of the contributions we included in it. Thank you to all contributors!

On October 10th, 2025, we released MySQL 9.5, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can see contributions related to Connector J and Connector Net, as well as to different server categories. Connector / J […]

Unlock the secret to faster data searches with indexes! This post introduces beginners to the power of indexes in MySQL, using friendly library metaphors and simple SQL examples. Learn how—and why—to create indexes, understand their impact, and keep your growing database running at page-turning speed.

Manually sifting through documents like purchase orders (POs) to find specific information is a time-consuming and often frustrating task. What if you could simply ask questions in plain English and get immediate, accurate answers? This is now possible with MySQL HeatWave GenAI. MySQL HeatWave is a fully managed MySQL database service that combines transactions, analytics, […]

This post demonstrates how you can use HeatWave GenAI to transform an unstructured PDF of a purchase order into a structured, queryable format directly within your database. We'll walk through the process of loading a PO from an object store and then asking natural language questions to retrieve key details like order dates, item costs, and supplier information.

Congratulations, library explorer! You’ve journeyed from empty shelves and head-scratching table structures to a bustling digital library, complete with secure doors and well-organized stacks. Now, as you place the final book in your collection, there’s one crucial skill left before you can truly claim the title of database master: keeping your hard-earned data safe for […]