Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Using JavaScript to Search JSON Arrays in MySQL
A few months ago, it was announced that MySQL now supports writing stored functions and stored procedures using JavaScript. This post will discuss a case in which JavaScript searches values in an array. Please note that this functionality is only available in MySQL Enterprise Edition or MySQL HeatWave. The Problem We can search values in arrays […]
Viewing MySQL Document Store Queries in HeatWave Using Database Management
In a post from last year, I talked about how we can view the SQL queries that are run whenever we use the MySQL Document Store API to return JSON documents. If you did not know, when using the Document Store API, the commands are translated into SQL and executed against the database. Sometimes, it is helpful to view […]
In-Database Machine Learning Model Development using Oracle’s MySQL Heatwave
MySQL is one of the most widely used databases in the world, second only to the Oracle database, and MySQL Heatwave is also available in all major clouds (Azure, AWS, GCP, and OCI). MySQL-HW is an extension of MySQL that allows one to swiftly resolve queries across large volumes of in-memory data, up to several hundreds […]
Creating a MySQL HeatWave Replication Channel with the OCI CLI
This is the sixth (and final) post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a MySQL HeatWave inbound replication channel. Prerequisites Before you can run any of the examples below, you need to install the OCI CLI. If you do not have […]
MySQL NDB Cluster replication: Single-channel replication
This is the second article in our series about MySQL NDB Cluster replication, it focuses on the basic concepts which are neccessary to be familiar with in order to build the more advanced configurations with redundancy, improved scalabilty and performance. The two basic logical components used for MySQL NDB Cluster replication are: The preceding […]
Creating a MySQL HeatWave Configuration with the OCI CLI
This is the fifth post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a configuration for MySQL HeatWave instances and how to create a new instance using this configuration. Prerequisites Before you can run any of the examples below, you need to install […]
MySQL Shorts – Episode #60 is Released
The latest Episode of MySQL Shorts is now available! Check out Episode 60 on the MySQL YouTube Channel to learn how to create a new admin user on a MySQL HeatWave instance.
EMEA MySQL Meetups in April & May 2024! – UPDATED!
We are happy to announce a couple of MySQL Meetups happening in Germany and Czech Republic in April and May 2024! Please find the details below and feel free to register for those free of charge MySQL Meetups! MySQL Meetup Prague, Czech Republic: MySQL Document Store & Helidon Together MySQL Meetup in Berlin & Frankfurt, […]
Creating a MySQL HeatWave Read Replica with the OCI CLI
This is the fourth post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a read replica of a MySQL HeatWave instance. Prerequisites Before you can run any of the examples below, you need to install the OCI CLI. If you do not have […]
Backing up and Restoring a MySQL HeatWave Instance with the OCI CLI
This is the third post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. In this post, we will discuss how to create a backup of a MySQL HeatWave instance and create a new MySQL HeatWave instance from that backup. Prerequisites Before you can run any of the examples below, you […]