This blog demonstrates how to replicate your data from your MySQL HeatWave DB system to your on-premises MySQL Server.

Having your data in the Oracle Cloud Infrastructure (OCI) and using the secure storage of MySQL HeatWave is a sound investment for any organization. However, sometimes, you need access to the data from another MySQL HeatWave DB system within OCI. You can accomplish this in various ways, including exporting the data, but what if you […]

This blog demonstrates how to replicate data from one DB system to another using the built-in replication channel feature.

Are you thinking about using MySQL HeatWave inbound replication to create a replica of your data in Oracle Cloud Infrastructure (OCI)? Have you read the MySQL HeatWave source configuration documentation and discovered that global transaction identifiers (GTIDs) are recommended for your source MySQL server? If the source you want to replicate does not have GTIDs […]

This blog explains how you can set up inbound replication without using global transaction identifiers on the source.

Learn about the two different strategies for setting up multi-primary bidirectional replication between MySQL NDB clusters. This functionality is commonly used for highly available (HA) clusters that requires continuous online operation and disaster protection.

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to sort JSON array data using JavaScript in MySQL.

Now this is far from being any observability manual for your InnoDB Cluster and let alone go into everything MySQL Shell API Admin, or the collectDiagnostics utility. You can also use the default javascript commands that we all know and love via dba.getCluster() and so on, but here’s a different take.

I just want to share something I’ve been playing with to pull out some key info from mycluster. Hope it helps someone else out there.

General setup:

select cluster_id, cluster_name, description, cluster_type, primary_mode, clusterset_id
from mysql_innodb_cluster_metadata.clusters;

Members of our cluster:

select * from …

In some previous posts, I discussed how we can use JavaScript in MySQL HeatWave and MySQL Enterprise to search and filter JSON array data. Today, I am going to show how we can sort JSON array data using JavaScript in MySQL. The Problem I have worked on applications that ingested data from third-party APIs. In most cases, we stored this data as JSON […]

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to implement more complex logic in a MySQL stored function using JavaScript.