What’s New in MySQL 9.0 Innovation Edition? Key Features and Improvements

MySQL 9.0 Innovation Edition, released on July 1, 2024, introduces major changes such as the removal of the mysql_native_password plugin, new PREPARE support for event statements, expanded Performance Schema tables, JSON‑formatted EXPLAIN ANALYZE output, Windows installer fixes, and several MySQL Shell enhancements.

InnovationEditionMySQLShellPerformanceSchema

0 likes · 4 min read

What’s New in MySQL 9.0 Innovation Edition? Key Features and Improvements

Aikesheng Open Source Community

Oct 21, 2020 · Databases

Introducing MySQL 8.0.21 Enhanced Logical Backup and Restore Tool

This article introduces MySQL 8.0.21's built‑in multi‑threaded logical backup utility, compares it with legacy tools like mysqldump and mysqlpump, demonstrates usage of dump_instance, dump_schemas and load_dump with Python‑style code snippets, and summarizes performance results and recovery steps.

BackupLogicalBackupMySQLShell

0 likes · 7 min read

Introducing MySQL 8.0.21 Enhanced Logical Backup and Restore Tool

Aikesheng Open Source Community

Mar 2, 2020 · Databases

Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router

This tutorial explains how to create and operate a MySQL InnoDB ReplicaSet—deploying sandbox instances, configuring a replica set with primary and secondary roles, adding nodes, performing manual primary switches and failure recovery, and using MySQL Router to provide an automatic read/write endpoint, while highlighting current limitations.

DatabaseReplicationGTIDInnoDB

0 likes · 8 min read

Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router