What’s New in MySQL 9.3? Backup, JavaScript Support, and Group Replication Explained
MySQL 9.3 introduces powerful backup enhancements, JavaScript stored‑procedure support, advanced query optimization, and a new Group Replication primary‑election feature, all aimed at improving reliability, performance, and developer flexibility, making it a compelling upgrade for enterprises and developers alike.
MySQL 9.3 has been officially released, bringing significant enhancements to backup capabilities, the mysqldump tool, and user management options.
Backup improvements include a new --users option that creates logical backups of user accounts, generating convenient CREATE USER and GRANT statements. The --add-drop-user flag adds DROP USER commands to backup scripts, while --include-user and --exclude-user allow precise inclusion or exclusion of specific accounts.
For developers, MySQL 9.3 expands JavaScript stored procedure support. The Enterprise edition’s Multi‑Language Engine now fully supports the DECIMAL data type, storing it as a JavaScript string to preserve precision and offering flexible numeric handling. An integrated JavaScript Internationalization API simplifies localization tasks.
Library management gains asynchronous loading via the await keyword, and new statements ALTER LIBRARY and SHOW LIBRARY STATUS make library administration easier.
Query optimization is extended to handle more complex comparison predicates in WHERE and SELECT clauses, improving execution efficiency for sophisticated queries.
Group Replication receives a new Primary Election component that selects the most up‑to‑date secondary server during failover, reducing data inconsistency and downtime for high‑availability deployments.
Deprecated features such as the Version Tokens plugin have been removed, and the minimum value for replica_parallel_workers is now set to 1 to ensure stable replication performance.
Signed-in readers can open the original source through BestHub's protected redirect.
This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactand we will review it promptly.
21CTO
21CTO (21CTO.com) offers developers community, training, and services, making it your go‑to learning and service platform.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.
