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 Oracle Analytics Cloud with MySQL HeatWave
MySQL HeatWave is the MySQL DBaaS provided by Oracle in OCI and some other clouds. Compared to the vanilla MySQL, one of the key features of the service is that it allows you to run analytics queries (aka OLAP) very quickly using the HeatWave cluster. You can also run such queries on files using LakeHouse. […]
Debugging JavaScript Stored Functions in MySQL
Recently, I have written extensively about using JavaScript to create stored functions in MySQL. I have talked about searching, filtering, and sorting JSON array data. I have discussed using top-level JavaScript objects such as Intl and Math. Today, I will talk about debugging stored functions written in JavaScript. The Problem Debugging MySQL stored functions, even those written in SQL, can be arduous. […]
MySQL NDB Cluster replication: Circular replication for active-active clusters
This is the fourth article in our series about MySQL NDB Cluster replication. We’ve now got so far into the details that data can not only be replicated from one cluster to the other but also back to the first again, we call this circular replication and it enables locating clusters in disparate places to […]
Outbound Replication from MySQL HeatWave DB System to On-premises MySQL Server
Having your data in the Oracle Cloud Infrastructure (OCI) and using MySQL HeatWave’s secure storage is a sound investment for any organization. Still, sometimes, there is a need to have access to the data outside of OCI. You can accomplish this in various ways, including exporting the data, but what if you need real-time data […]
Replicating from One MySQL HeatWave DB System to Another
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 […]
Configuring MySQL HeatWave Inbound Replication Without Global Transaction Identifiers (GTIDs)
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 […]
MySQL NDB Cluster replication: Circular replication for active-active clusters
This is the fourth article in our series about MySQL NDB Cluster replication. We’ve now got so far into the details that data can not only be replicated from one cluster to the other but also back to the first again, we call this circular replication and it enables locating clusters in disparate places to […]
Sorting JSON Arrays in MySQL with JavaScript
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 […]
More JavaScript in MySQL
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 […]
Shenzhen CLOU Electronics Strengthens its Data Security and Regulatory Compliance with MySQL Enterprise Edition
“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: […]