Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

17 Years of Insecure MySQL Client !

Yes, this is a catchy title, but it is true, and it got you reading this post :-).  Another title could have been “Please load this mysql-dump: what could go wrong ?”.  As you guessed, loading a dump is not a risk-free operation.  In this post, I explain how the insecure MySQL client makes this operation risky and how to protect against it. And if you think this post is not Jean-François Gagné

Learn More »

dbdeployer Tutorial on Mac

Not very long ago (well, maybe a little longer, this post is in draft for more than a year), in the spawn of less than 5 days, I suggested many colleagues to reproduce a problem they had with MySQL in a "more simple environment".  Such more simple environment can be created with dbdeployer.  dbdeployer is a tool to create "MySQL Sandboxes" on a Mac (laptop or desktop) or on Linux (vm, Jean-François Gagné, QC, Cana

Learn More »

Introducing Tungsten Cluster & Tungsten Replicator v7.1.2

04/04/2024 | Continuent

We are excited to announce the release of Tungsten Cluster and Tungsten Replicator version 7.1.2, packed with enhancements, new features, and important bug fixes. This release focuses on improving installation and deployment processes, enhancing command-line tools, and addressing critical issues to ensure a seamless experience for our users.

Behavior Changes

In this version, we have made some changes that might affect existing scripts and integration tools. It's essential to revi

Learn More »

Release Roundup April 2, 2024

04/01/2024 | Percona
Percona software releases and updates March 18 - April 2, 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

Learn More »

Galera Manager March 2024 Release now includes UI improvements and a SSH console tab

03/28/2024 | Galera Cluster

Codership is please to announce a new release of Galera Manager. This brings the installer to version 1.13.0 (you can check this by typing: ./gm-installer version which will report gm-installer version 1.13.0 (linux/amd64)) and the actual Galera Manager GUI to 1.8.4. Users will notice many usability improvements, and multiple fixes for issues filed at the galera-manager-support issue tracker.

The biggest facing user items in this release include a “jobs” tracker. It can be a flat list or a hie

Learn More »

Creating a Standby Cluster With the Percona Operator for PostgreSQL

03/26/2024 | Percona
In this video, Nickolay Ihalainen, a Senior Scaling Specialist at Percona Global Services, explains how to set up replication with standby clusters for Kubernetes databases using Percona’s open-source tools, including the Percona Operator for PostgreSQL A Standby Cluster is a backup version of your main database. It’s there to keep your data safe and make sure your database can keep running even if something goes wrong with the main one.

Learn More »

Galera Cluster for MySQL 8.0.36 released

03/26/2024 | Galera Cluster

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36 (release notes, download), with Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High Availability solutions.

There have been some notable changes in the Galera replication library 4.18. We fixed bugs ar

Learn More »

Open Door MongoDB Chats

03/25/2024 | Percona
Let’s talk about MongoDB! This week, Jan Wieremjewicz, Senior Product Manager, and Michal Nosek, Pre-Sales Enterprise Architect at Percona, made two series of videos covering basic to advanced concepts in MongoDB and backups. Le’s explore them together! Enterprise Scale Backups for MongoDB with Open Source Software In the first video about enterprise-scale backups for MongoDB using open-source software, Jan and Michal discuss the challenges and solutions associated with backing up large data

Learn More »

MariaDB Galera Cluster – the wsrep allowlist

03/21/2024 | Galera Cluster

If you’ve used Galera Cluster for sometime, you might have already realised that with Galera 4, you have 3 new tables in the mysql database: wsrep_cluster, wsrep_cluster_members, and wsrep_streaming_log. We document this quite well in Galera System Tables. Join us for a Webinar: Top tips to drive your MariaDB Galera Cluster performance with new features. If you are a MariaDB Server user, you’ll notice that since MariaDB Server 10.10, there is yet another.

MariaDB [mysql]> show tables like

Learn More »

Webinar: Top tips to drive your MariaDB Galera Cluster performance with new features

03/20/2024 | Galera Cluster

MariaDB Server has built in Galera Cluster since the 10.0 releases, and plenty of joint engineering happens between Codership and MariaDB Corporation and the MariaDB Foundation. Galera Cluster as you may already know is a synchronous multi-primary (multi-master) replication solution, that has automatic node provisioning, with parallel replication, no secondary lag, with built-in automatic conflict detection and handling, plus components to allow load balancing.

So where does MariaDB Galera Clust

Learn More »