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
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
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
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?