MySQL Shell 8.0.21 includes some exciting new utilities to create a logical dump and do a logical restore, with a focus on ease of use, performance and integration. In MySQL Shell 8.0.17, we already introduced a multi-threaded CSV import utility util.importTable()…
What’s New in MySQL Shell 8.0.21
The MySQL team is proud to announce the general availability of version 8.0.21 of the MySQL Shell.
MySQL Shell Logical Dump and Load Utilities
A new suite of logical dump utilities was introduced in MySQL Shell 8.0.21.
util.dumpInstance(), util.dumpSchemas() and util.loadDump()…
Hiding instances on MySQL InnoDB Cluster/ReplicaSet
MySQL Router is a core component of InnoDB Cluster/ReplicaSet that enables the automatic routing of client traffic to the right instances of your database architecture. Router can automatically adapt to topology changes, however, there are some scenarios on which one would certainly benefit from having the possibility to tag an instance with a certain attribute that indicates a specific behavior change to Router’s default behavior.…
MySQL Shell AdminAPI – What’s new in 8.0.21?
The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.21!
As always, we have listened to the growing community of users and introduced a very useful feature for any production deployment of MySQL InnoDB Cluster or ReplicaSet.…
The MySQL 8.0.21 Maintenance Release is Generally Available
The MySQL Development team is very happy to announce that MySQL 8.0.21 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.21 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
A Tale of Two Password Authentication Plugins…
A long long time ago (in a galaxy far away… cue the music!) MySQL added support for an authentication plugin which is now known as mysql_native_password. The mysql_native_password plugin uses SHA1 hash to
- Store the password(SHA1(SHA1(password)) in mysql.user table
- Authenticate user
One of the good traits of this plugin is that it allows authentication using challenge-response mechanism which made it possible to verify identity of the client on an unencrypted channel without having a need to send the actual password.…
MySQL Shell 8.0.20 – What’s New?
The MySQL Development team is proud to announce version 8.0.20 of the MySQL Shell, with the following features:
- Admin API
- Improvements on the admin account handling for MySQL InnoDB cluster and MySQL InnoDB ReplicaSet as well as for MySQL Router
- Command line integration for MySQL InnoDB ReplicaSet
- Isolation of InnoDB ReplicaSet operations
- Connection compression options.
MySQL Shell AdminAPI – What’s new in 8.0.20?
The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.20!
Following the previous exciting release, on which InnoDB ReplicaSet was introduced, we focused on improving the management of ReplicaSets but also, most importantly, InnoDB cluster.…
The MySQL 8.0.20 Maintenance Release is Generally Available
The MySQL Development team is very happy to announce that MySQL 8.0.20 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.20 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Using a MySQL Keyring SECRET and Asymmetric Encryption
For an encrypt only or decrypt/encrypt applications
The following is an example of how to allow applications to asymmetrically encrypt data using a public key. In MySQL 8.0.19 support for the SECRET datatype was added to our Keyring technology. With this technology, users can securely manage their own keys using:
Oasis KMIP protocol implementations:
…