mysql

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: Oracle Key Vault Gemalto KeySecure Thales Vormetric Key Management Server Fornetix Key Orchestration New! … Facebook Twitter LinkedIn Source: Using a MySQL Keyring SECRET and Asymmetric Encryption

A must-know about NOT IN in SQL – more antijoin optimization I will try to make it short and clear: if you are writing SQL queries with “NOT IN” like SELECT … WHERE x NOT IN (SELECT y FROM …) you have to be sure to first understand what happens when “x” or “y” are NULL: it might not be what you want!… Facebook Twitter LinkedIn Source: A must-know about NOT IN in SQL – more antijoin optimization

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