Planet MySQL HA Blog

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

Codership shines with other EIC-funded companies at Mobile World Congress Barcelona 2024

02/20/2024 | Galera Cluster

Codership is honored to be part of a distinguished group of 15 EIC-funded companies to present Galera Cluster with their groundbreaking products and services at the European Innovation Council Pavilion during Mobile World Congress  Barcelona, 26-29 February 2024.

Join us at EIC Pavilion-4YFN-booth 8.1A20

Learn More »

Percona Monthly Bug Report: January 2024

02/18/2024 | Percona
At Percona, we believe that transparency is key to improving our products. We are dedicated to creating top-of-the-line open-source database solutions and providing support for any issues that may arise. We encourage feedback and bug reports to help us continually improve. We stay updated on bug reports through our own platform as well as other sources to ensure we have the most up-to-date information. To make it easier for you, we have compiled a central list of the most critical bugs for your

Learn More »

Installing Galera Cluster 4 with MySQL on Ubuntu 22.04

02/15/2024 | Galera Cluster

We have in the past covered Installing Galera Cluster 4 with MySQL 8 on Ubuntu 18.04 and also Installing Galera 4 with MySQL 8 on Ubuntu 20.04, and it would seem appropriate to also cover Ubuntu 22.04 LTS (Jammy Jellyfish). We do have excellent documentation and we also have the ability for you to automate all of this via the GUI tool, Galera Manager.

Prerequisites

All 3 nodes have to have Ubuntu 22.04 LTS installed. The current version at the time of this writing is Ubuntu 22.04.3 LTS. Firewal

Learn More »

Webinar: Mastering Galera Cluster, Best Practices and New Features 27th February

02/13/2024 | Galera Cluster

Join us for an exclusive webinar tailored for database administrators and IT professionals aiming to enhance their systems’ efficiency and reliability using Galera Cluster. This session focuses on practical best practices, showcases new features, and provides an extended platform for your queries.

What You Will Learn:
* Core Best Practices: Dive into essential practices, from employing primary keys and leveraging InnoDB to deciding if to optimise read/write splits and managing AUTO_INCREMENT se

Learn More »

Resources to help you get started with Galera Manager in 2024

01/31/2024 | Galera Cluster

As we have been doing many new releases of Galera Manager lately, here are a series of new videos and blog posts to help you get started with Galera Manager.

Deploy Percona XtraDB Cluster (PXC) on Amazon Web Services (AWS) EC2 instances automatically with Galera Manager Deploy Percona XtraDB Cluster (PXC) using Galera Manager on-premises – this is the way to do it on your own hardware! Deploy MariaDB Galera to AWS EC2 in 13 minutes with Galera Manager Deploy MariaDB Galera on premises wit

Learn More »

Deploying a MariaDB Galera Cluster with Galera Manager on your own on-premise hosts

01/31/2024 | Galera Cluster

When polled, easily our most favoured method of deploying MariaDB Galera Clusters happens to be the on-premise option, when our customers and users use Galera Manager.

So to start, we will deploy 3 hosts, running Ubuntu 22.04 LTS. These are just deployed with the base operating system (OS). You are advised to read the supported OS matrix which can change as releases abound. You will need a fourth pristine host to run Galera Manager (it can be a different OS, but for ease of installation and simp

Learn More »

Deploying a MariaDB Galera Cluster with Galera Manager automatically on Amazon Web Services (AWS)

01/31/2024 | Galera Cluster

Galera Manager supports three modes for supporting your MariaDB Galera Clusters: deploying to either Amazon Web Services or DigitalOcean, deploying to your own on premises hosts, and also just monitoring your clusters. In this blog post, we will go thru houw you should deploying a 3-node MariaDB Galera Cluster via Galera Manager on Amazon Web Services Elastic Compute Cloud (AWS EC2). You will realise that this process happens with just a simple API key and instance selection, so effectively you

Learn More »

Deploying a Percona XtraDB Cluster (PXC) with Galera Manager on your own on-premise hosts

01/31/2024 | Galera Cluster

When polled, easily our most favoured method of deploying Percona XtraDB Clusters happens to be the on-premise option, when our customers and users use Galera Manager.

So to start, we will deploy 3 hosts, running Ubuntu 22.04 LTS. These are just deployed with the base operating system (OS). You are advised to read the supported OS matrix which can change as releases abound. You will need a fourth pristine host to run Galera Manager (it can be a different OS, but for ease of installation and simp

Learn More »

Deploying a Percona XtraDB Cluster (PXC) with Galera Manager automatically on Amazon Web Services

01/31/2024 | Galera Cluster

Galera Manager supports three modes for supporting your Percona XtraDB Clusters: deploying to either Amazon Web Services, deploying to your own on premises hosts, and also just monitoring your clusters. In this blog post, we will go thru houw you should deploying a 3-node Percona XtraDB Cluster via Galera Manager on Amazon Web Services Elastic Compute Cloud (AWS EC2). You will realise that this process happens with just a simple API key and instance selection, so effectively you can have a Galer

Learn More »

Unexpected Stalled Upgrade to MySQL 8.0

01/25/2024 | Percona
A multi-tenant database is a database that serves multiple clients, or tenants, who share the same database schema but have separate data sets. One way to achieve data isolation for each client is to create a separate MySQL database for each tenant. Some advantages of this approach are: It allows for easy backup and restore of individual tenant data. It simplifies the database administration and maintenance tasks, as each database can be managed independently.

Learn More »

Pages