Database service MySQL 9.3 Release: Enhanced support for JavaScript

In terms of database backup, MySQL 9.3 has significantly optimized the mysqldump tool. Administrators can now easily create logical backups of user accounts through the newly added –users option, generating convenient SQL CREATE USER and GRANT statements.
Furthermore, the –add-drop-user option enables the inclusion of user deletion commands in the backup script, facilitating the process of environment migration; administrators can also utilize the –include-user and –exclude-user flags to precisely control the backup or exclusion of specific accounts, resulting in more efficient operations.
For developers, MySQL 9.3 has enhanced support for JavaScript stored procedures. In the MySQL Enterprise Edition, the Multi-Language Engine Component (MLE) has added strong support for the MySQL DECIMAL data type. By default, it stores the data in JavaScript string format to ensure accuracy, and also provides flexible options for numerical processing. Additionally, integrating the JavaScript Internationalization API makes localizing and internationalizing operations more smooth.
In terms of library management, the await keyword is used to dynamically load JavaScript libraries, optimizing asynchronous operations. The newly introduced ALTER LIBRARY and SHOW LIBRARY STATUS statements also make library management and viewing more convenient.
Meanwhile, the version has expanded the query optimization capabilities, supporting more complex comparison predicates in the WHERE and SELECT clauses, thereby enhancing the performance of complex queries.
MySQL 9.3 also introduces the Group Replication feature. The newly introduced Primary Election component can precisely select the secondary server with the latest data during failover, reducing data inconsistency and downtime. This is crucial for enterprise deployments that prioritize high availability and reliability.
Furthermore, the version has removed the deprecated Version Tokens plugin and adjusted the minimum value of the replica_parallel_workers setting to 1 to ensure stable and reliable replication efficiency.