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. […]
If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]
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 […]
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.
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 […]
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.