Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
MySQL Shorts – Episode #62 is Released
The latest Episode of MySQL Shorts is now available! Check out Episode 62 on the MySQL YouTube Channel to learn how to create a stored function using JavaScript in MySQL HeatWave and MySQL Enterprise.
Using the Global `Intl` JavaScript Object in MySQL
As I mentioned in some previous posts, MySQ: HeatWave and MySQL Enterprise support writing stored functions using JavaScript. When I started playing around with this feature, I wanted to know how much support there was for global JavaScript objects. There is a lot of support for these, and in this post, we will talk about using the […]
MySQL April 2024 GA Releases Now Available
MySQL Server 8.4.0 LTS and 8.0.37 are now available for download and in the MySQL HeatWave Database Service. These are the latest General Availability (GA) releases as of April 30, 2024. New release model, first LTS Release In the summer of 2023, MySQL announced plans move to a new LTS and Innovation release model planning […]
Filtering JSON Arrays with JavaScript in MySQL
In my last post, I discussed using JavaScript to write MySQL stored functions that could search the values in a JSON array to determine if any of the elements matched a given value. In this demonstration, I will show how you can use JavaScript to filter the elements of an array and only return elements that […]
MySQL NDB Cluster replication: Dual-channel replication for redundancy
This is the third article in our blog series about MySQL NDB Cluster replication, it describes how to extend the single-channel replication from previous post with another set of MySQL servers in order to achieve redundancy. MySQL NDB Cluster is a highly available RDBMS, designed to be operated with no single point of failure (SPOF). […]
Introducing support for keyring component to plugin migration
Overview MySQL Heatwave supports migration of keys between keyring keystores, enabling DBAs to switch a MySQL installation from one keyring keystore to another. The keyring manages keystores using keyring components and keyring plugins. Before 8.4.0 release MySQL Heatwave supported the following types of keyring migrations: There were no provision for migration from a keyring component to […]
Using the Oracle Cloud Infrastructure Vault Keyring Component in MySQL Heatwave
This is the fourth article in the series dedicated on transition from keyring plugins to keyring components. In the previous article we have discussed component_keyring_encrypted_file keyring component, how different is it from the keyring_encrypted_file plugin and how to install it using a manifest and configuration file. In this post we will be discussing component_keyring_oci keyring […]
Using the component_keyring_encrypted_file Encrypted File-Based Keyring Component in MySQL
This is the third article in the series dedicated on transition from keyring plugins to keyring components. In the previous article we have discussed component_keyring_file (file-based keyring component), how different is it from the keyring_file plugin and how to install it using a manifest and configuration file. In this post we will be discussing component_keyring_encrypted_file […]
Using the component_keyring_file File-Based Keyring Component in MySQL
This is the second article in the series dedicated on transition from keyring plugins to keyring components. In the previous article we have discussed MySQL’s effort in transitioning from keyring plugins to keyring components, the advantages of keyring components over keyring plugins and how to migrate from a keyring plugin to a keyring component. In […]
Introducing Keyring Components in MySQL
In this series of articles we will explore MySQL transition from keyring plugins to keyring components, the advantages of keyring components over keyring plugins, migration from keyring plugin to keyring component and steps to initialize and configure keyring components. Motivation Before MySQL 8.0, to add a feature to MySQL, writing a plugin was the only […]