Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Debugging JavaScript Stored Functions in MySQL
MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to debug JavaScript code used to create stored functions.
Learn PostgreSQL and SQL Quickly and Free
Learn PostgreSQL and SQL Quickly and Free
Want to learn PostgreSQL? What if you could learn PostgreSQL without having to install the database, load data, find sample data, and it was free? PGExamples.com is what you are looking for.
First, let me state that I have no connection to the website or its author. I discovered PgExercises.com by accident and was impressed by its quality and completeness. I am so impressed that I am exploring a video series on it.
MySQL NDB Cluster replication: Circular replication for active-active clusters
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.
Outbound Replication from MySQL HeatWave DB System to On-premises MySQL Server
This blog demonstrates how to replicate your data from your MySQL HeatWave DB system to your on-premises MySQL Server.
Replicating from One MySQL HeatWave DB System to Another
This blog demonstrates how to replicate data from one DB system to another using the built-in replication channel feature.
Configuring MySQL HeatWave Inbound Replication Without Global Transaction Identifiers (GTIDs)
This blog explains how you can set up inbound replication without using global transaction identifiers on the source.
MySQL NDB Cluster replication: Circular replication for active-active clusters
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.
Sorting JSON Arrays in MySQL with JavaScript
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.
Observing InnoDB Cluster: A different approach for specific info extraction
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_Release Roundup May 15, 2024
Percona software releases and updates April 30 - May 15, 2024.
Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.
Our Release Roundups showcase the latest Percona software u
Pages
Sources:
MySQL expert Diary