The latest from the MySQL community

What is it about?

When describing backup and restore scenarios, a full backup and a full restore of the database instance (mariadbd/mysqld) are usually assumed. This means that the entire database instance, including all databases (schemas), is backed up and restored.

In practice, however, the situation is often different: An entire database instance is not to be restored, but only individual databases or even individual tables, because only these have broken.

In many cases, this can be done quite easily with the tools mariadb-dump/mariadb or mysqldump/mysql (logical backup). However, if the database or table is very large, the restore will not be completed in a reasonable time (some minutes to a few hours).

This is exactly where the so-called partial physical restore comes into play. Partial stands for one or more tables (or an …

Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful […]

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss some of the options available to use when dumping database schemas and data.

MySQL 9.0 was released on July 1, 2024. This is an ‘Innovation’ release, which means it provides access to the latest features and improvements in MySQL technologies. Innovation releases are the opposite of the Long Term Support (LTS) releases, where stability is the top priority, and only needed security and other fixes are available. This […]

Introduction: In this blog, we will walk through the process of inserting data into a MySQL table using FastAPI. FastAPI is a modern, fast (high-performance), web framework for building APIs with Python based on standard Python type hints. MySQL HeatWave is a fully managed database service, powered by the HeatWave in-memory query accelerator. It’s the […]

FastAPI is a modern, fast (high-performance), web framework for building APIs with Python based on standard Python type hints.

MySQL HeatWave is a fully managed database service, powered by the HeatWave in-memory query accelerator. It’s the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one MySQL Database—without the complexity, latency, risks, and cost of ETL duplication.

Note: To fix a critical bug we did out of cycle releases – 8.0.39, 8.4.2, 9.0.1 Building on the new LTS/Innovation release model In previous blogs, MySQL announced plans to move to a new LTS/Innovation release model, planning a major LTS release every 2 years. For more details see MySQL Releases: Innovation and LTS.  Since 8.4.x […]

Note: To fix a critical bug we did out of cycle releases - 8.0.39, 8.4.2, 9.0.1 MySQL Server 9.0.1 Innovation, 8.4.2 LTS, 8.0.39, are now available for download and in the MySQL HeatWave Database Service. These are the latest General Availability (GA) releases as of July 24, 2024.

Last year, in MySQL 8.0.31, we announced how HeatWave uses the new MySQL hypergraph optimizer to get better query plans. Since then, we have continued to work on the optimizer, and starting with MySQL 9.0, it has been enabled as an opt-in feature in HeatWave MySQL. This new feature is only available in HeatWave MySQL […]

When running tests, it is sometimes useful to slow down IOs to clearly show the impact of reading from the disk.  Modern laptops and servers usually have fast local SSDs, and most cloud vendors provide, in addition to fast local disks, relatively fast network block devices (EBS for AWS and Persistent Disk for GCP).  Even when using magnetic network block devices, IOs are not guaranteed