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.

“By choosing MySQL Enterprise Edition, we are able to protect our data at significantly lower costs. This underscores the value of MySQL Enterprise Edition in generating profits for businesses with budget constraints. We are now relying on MySQL Enterprise Edition to scale our business globally.”  – Wenhu Liao, Product Manager, Shenzhen CLOU.   Background:   […]

This is a case study for the use of MySQL Enterprise Edition at Shenzhen CLOU Electronics. MySQL Enterprise Edition stood out as a robust solution for organizations seeking to safeguard their sensitive data.

In my last three posts, I discussed searching JSON array data, filtering JSON array data, and using the global Intl object when creating MySQL stored functions. These examples were relatively simple functions and, essentially, one-liners. In this post, I will create another stored function with more complex business logic. The Business Rules Let’s assume we have a requirement to return a given number of […]

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.

Episode #62 of MySQL Shorts in now available!