MySQL Shell 8.0.19 – What’s New?

The MySQL Development team is proud to announce version 8.0.19 of the MySQL Shell, with the following features:

  • Admin API
    • MySQL InnoDB ReplicaSet
    • MySQL Router Management Functions
    • Metadata Upgrade
    • Router Management Functions
  • Shell JavaScript Plugins: require() function enhancements.
  • Upgrade Checker Updates

MySQL InnoDB ReplicaSet

Similar to MySQL InnoDB Cluster (based on Group Replication), this release of the Shell introduces the MySQL InnoDB Replicaset which provides an easy to use management solution for MySQL Replication.…

The all new MySQL InnoDB ReplicaSet

Following MySQL InnoDB Cluster as our first, fully integrated MySQL High Availability solution based on Group Replication, MySQL Shell 8.0.19 includes MySQL InnoDB ReplicaSet which delivers another complete solution, this time based on MySQL Replication.

The basic idea for InnoDB ReplicaSet is to do the same for classic MySQL Replication as InnoDB Cluster did for Group Replication.…

Antijoin in MySQL 8

In MySQL 8.0.17, we made an observation in the well-known TPC-H benchmark for one particular query. The query was executing 20% faster than in MySQL 8.0.16. This improvement is because of the “antijoin” optimization which I implemented. Here is its short mention in the release notes:

“The optimizer now transforms a WHERE condition having NOT IN (subquery), NOT EXISTS (subquery), IN (subquery) IS NOT TRUE, or EXISTS (subquery) IS NOT TRUE internally into an antijoin, thus removing the subquery.”

MySQL Shell 8.0.18 – What’s New?

The MySQL Development team is proud to announce a new version of the MySQL Shell with the following major improvements:

  • Migration to Python 3
  • Built-in thread reports
  • Ability to use an external editor
  • Ability to execute system commands within the shell
  • Admin API Improvements:
    • New options to log all the SQL used on the different operations
    • Support for IPv6 in InnoDB Clusters
    • New function to reset the InnoDB Cluster recovery accounts
  • General maintenance and bug fixing

Python 3 Migration

Due to the coming end-of-life (EOL) for Python 2.7