MySQL Shell 8.0.32 was released last week and includes several bugfixes as well as some new features. Let's look into what was added in this new release.

New Features

  • Upgrade Checker checks for deprecated unquoted identifiers starting with a dollar sign ($), which is deprecated since MySQL Server 8.0.32
  • Some changes were made to the logSql option and filtering options were added.
  • Support for MySQL login paths and option files (print-defaults, no-defaults, defaults-file, defaults-extra-file, defaults-group-suffix, login-path), where it reads [mysqlsh] & [client] in configuration files.
    For example, when you have a .my.cnf configured, mysqlsh will automatically connect:
$ cat ~/.my.cnf
[client]
user=root
host=lefred
password=lefreptwasswort

$ mysqlsh
MySQL Shell 8.0.32-commercial

Copyright (c) 2016, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.
Creating a Classic session to 'root@localhost'
Fetching schema names for auto-completion... Press ^C to stop.
Your MySQL connection id is 17
Server version: 8.0.32-commercial MySQL Enterprise Server - Commercial
No default schema selected; type \use <schema> to set one.
MySQL  lefred  JS > 

MySQL InnoDB ReplicaSet, Cluster & ClusterSet

These solutions automate the installation and management of MySQL deployments, making it very easy to setup High Availability and Disaster Recovery deployments.
In just a few commands, you can setup high availability and disaster recovery, meeting various business requirements. It is also used in our MySQL Operator for Kubernetes.

New features added to 8.0.32:

  • ReplicaSet replication channels are created with SSL enabled by default.
  • New MySQL Router routing option: use_replica_primary_as_rw: open or close a read-write (R/W) port on a router targeting a specific Cluster (where target_cluster is not set to PRIMARY), enabling you to use a R/W port on a Replica Cluster. The Replica Cluster continues to only accept R/O traffic. In the event of a switchover or failover, the R/W port remains unchanged. The option is configurable with MySQL Shell's AdminAPI, using: <ClusterSet>.setRoutingOption()

MySQL InnoDB ClusterSet use_replica_as_rw example

 

Shell Dump & Load Enhancements

In 8.0.21, the MySQL Shell Dump and Load tools were introduced, which makes logical dump and load a lot more flexible and faster, by making both the dump and load process multi-threaded and integrating with cloud object storage protocols (OCI Object Storage and AWS S3, now Azure Blob Storage). Ever since the initial release, several performance improvements and features were added.

 MySQL Shell Dump vs Benchmarks 

In 8.0.32, the following features were added:

  • Microsoft Azure Blob storage support for import, export, dump, and load operations.
  • Improved AWS S3 support: Support AWS environment variables & s3Region option
  • Support chunking of tables that have no PRIMARY KEY or UNIQUE KEY
  • The following options were added to the exportTable(), dumpInstance(), dumpSchemas() and dumpTables() utilities:
    • where: enables you to export the data which satisfies a SQL condition.
    • partitions: enables you to export named partitions.
    • fieldsTerminatedBy, fieldsEnclosedBy, fieldsEscapedBy, fieldsOptionallyEnclosed, linesTerminatedBy, dialect

More Information

Find the full list of features and bugfixes on https://dev.mysql.com/doc/relnotes/mysql-shell/8.0/en/news-8-0-32.html

Together with the MySQL Shell 8.0.32 release, new 8.0 releases MySQL Server, NDB Cluster, MySQL Connectors, MySQL Workbench, MySQL Router & MySQL Operator for Kubernetes happened, as well as maintenance release MySQL Server 5.7.41.
Changes in all these releases since the previous one can be viewed online on https://dev.mysql.com/doc/#current-release-notes

  • Download our MySQL Community Shell & Server packages at https://dev.mysql.com/downloads/.
  • MySQL Enterprise binaries are available on My Oracle Support: https://support.oracle.com (Choose the “Patches & Updates” tab, and then choose the “Product or Family (Advanced Search)” side tab in the “Patch Search” portlet.)
  • or use Oracle Software Delivery Cloud on http://edelivery.oracle.com/ to download MySQL Enterprise binaries.