No Image

Upgrading MySQL InnoDB Cluster Metadata

2020-01-18 KENNETH 0

Upgrading MySQL InnoDB Cluster Metadata As on every release MySQL Shell 8.0.19 includes several bug fixes as well as new features. However, this release includes some significant changes: Fixes for bugs in the schema definition:  Cascading keys in multi-primary mode. Introduction of InnoDB ReplicaSet. These changes required updates to the metadata schema definition, some of which incompatible with previous versions.… Facebook Twitter LinkedIn Source: Upgrading MySQL InnoDB Cluster Metadata

No Image

A Tale of UDFs with Character Sets

2020-01-17 KENNETH 0

A Tale of UDFs with Character Sets If you are reading this blog post, you likely already know the purpose of user-defined functions (UDF) in MySQL. If you need a quick refresher on UDF’s take a look at the MySQL reference manual.  You may have created your own UDFs as well.… Facebook Twitter LinkedIn Source: A Tale of UDFs with Character Sets

No Image

A new, simple way to figure out why your recursive CTE is running away

2020-01-15 KENNETH 0

A new, simple way to figure out why your recursive CTE is running away In MySQL 8.0.1, we introduced support for recursive common table expressions (CTE). There are quite a few blog entries showcasing the feature, starting from this one, and there is also a complete documentation. Today, I would like to present a solution to a problem which nearly everybody meets when writing queries with recursive CTE’s: when infinite recursion happens, how to debug ?… Facebook Twitter LinkedIn Source: A new, simple way to figure out why your recursive CTE is running away

No Image

MySQL Shell 8.0.19 – What’s New?

2020-01-14 KENNETH 0

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.… Facebook Twitter LinkedIn Source: MySQL Shell 8.0.19 – What’s New?

No Image

MySQL Shell AdminAPI – What’s new in 8.0.19?

2020-01-14 KENNETH 0

MySQL Shell AdminAPI – What’s new in 8.0.19? The MySQL Development Team is thrilled to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.19! This release sets the bar higher, by introducing a new integrated solution based on a very well known Replication technology – MySQL InnoDB ReplicaSet!… Facebook Twitter LinkedIn Source: MySQL Shell AdminAPI – What’s new in 8.0.19?