Latest Blog posts

Read all >
More

News

Read all >
More

See videos

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

Length: 56

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 Cluster stand out compared to the rest? Here are a few selected features that may pique your interest:
* Galera 4 is standard in MariaDB Galera Cluster since MariaDB Server 10.4. Note that Galera Cluster is built-into MariaDB Server.
* The mysql database contains new tables: wsrep_cluster, wsrep_cluster_members, wsrep_streaming_log, and wsrep_allowlist.
* Streaming replication allows replicating transactions of an unlimited size, i.e. greater than 2GB.
* GTID handling with Galera Cluster and MariaDB Server are synchronised, thus you have seamless replication of MariaDB GTIDs to other nodes in the cluster.
* wsrep_mode to help you replicate MyISAM, and Aria storage engines.
* You can migrate from unencrypted replication to TLS Galera communications without any downtime.
* A JSON interface for wsrep node state, including progress logging for State Snapshot Transfers (SSTs). This also includes the IP allowlist for Galera Cluster nodes that can make the requests (currently a unique feature to MariaDB Server).
* Rolling upgrades from MariaDB Server 10.4 to later, are supported.

There are plenty more, considering there are **enterprise only features** like the Blackbox for Galera troubleshooting, encrypting of the gcache, and more. While we are at it, we will also cover the MariaDB MaxScale features that are Galera Cluster specific.

Mastering Galera Cluster, Best Practices and New Features

Length: 59 min

This webinar is 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 settings.

* Advanced Configuration: Uncover advanced techniques for error monitoring, configuring Galera across networks, and fine-tuning the gcache for optimal performance.

* Innovative Features: Stay ahead with insights on implementing Non-Blocking Operations for seamless schema changes, coordinating distributed transactions with XA transactions, and securing your GCache through encryption.

* Protocol and Network Enhancements: Discover the latest advancements in handling unstable networks, protocol improvements, and explore new options to elevate your cluster operations.

Have in-depth questions or faced intricate production challenges? This extended Q&A session is your opportunity to seek advice, clarify doubts, and engage directly with Galera Cluster experts.

Deploy MariaDB Galera on premises with Galera Manager

Length: 15

Watch the 15 minutes video to learn how to EASILY deploy MariaDB Galera on premises using Galera Manager

Deploy MariaDB Galera to AWS EC2 in 13 minutes with Galera Manager

Length: 13

Watch the 13 minutes video to learn how to EASILY deploy MariaDB Galera on AWS EC2 using Galera Manager

Using Galera Manager for Percona XtraDB Cluster on premises installation

Length: 7 mins

Watch the 7 minutes video to learn how to EASILY deploy Percona XtraDB Cluster (aka Galera Cluster) using Galera Manager

Deploy Percona XtraDB Clusters (aka Galera Clusters) on Amazon EC2 with Galera Manager and manage and monitor them (mins video)

Length: 15 min

This 15 minutes video explains how you can easily deploy Percona XtraDB Clusters (aka Galera Clusters) on Amazon EC2 with Galera Manager and manage and monitor them.

Recording: Launch in 15 minutes, in Amazon and on-premises, manage and monitor Percona XtraDB Clusters with the NEW Galera Manager

Length: 45

As with every Galera Manager release, we consider a huge amount of features, and we always improve the UI and functionality based on your feature requests, to ensure that as a user, you’re happier, but more importantly, more efficient in production.

One of the biggest feature requests was to have Percona XtraDB Cluster (PXC) be launched and managed from a Galera Manager, and we have delivered as such. Galera Manager is free, not only monitors your PXC nodes, but also deploys PXC for you, such that it is a fully-managed service. We do not require the complexity of Kubernetes to get deployed, either. And Galera Manager comes from the developers of Galera Cluster, Codership.

In this webinar we will cover:

* Create a 3-node Galera Cluster branch with Percona XtraDB Cluster (PXC), in Amazon Web Services (AWS) (it works on DigitalOcean too, as well as on premise, but the demonstration will focus on AWS)
* Deploy a 3-node Percona XtraDB Cluster (PXC) on your existing on-premise infrastructure
* Cost comparisons between what we offer and other managed services (including a comparison with Percona Monitoring and Management – PMM)
* Utilizing the over 600 monitoring metrics to effectively manage your Galera Cluster

We are going to be mostly live demo focused and will answer your questions as well.

Webinar recording: Upgrade Ihres MySQL 5.7 Galera Clusters auf MySQL 8.0 ohne Ausfallzeiten

Length: 49 minutes

Sie haben sicher schon davon gehört, dass MySQL 5.7 im Oktober 2023 das End of Life (EOL) erreicht hat. In diesem Webinar zeigen wir Ihnen, dass die Migration von MySQL 5.7 Galera Cluster nicht schwierig ist. MySQL 8.0 ist seit 5 Jahren allgemein verfügbar, und das Galera Cluster für MySQL 8.0 hat sich seit über 3 Jahren im Markt bewährt. Es ist also wirklich an der Zeit, sich auf die Migration vorzubereiten.

Im ersten Webinar dieser Reihe werden wir uns mit den neuen Funktionen von Galera Cluster mit MySQL 8 befassen:

* Die neuen Funktionen von Galera Cluster für MySQL 8, von denen Sie profitieren können, einschliesslich der in der Galera Cluster Enterprise Edition (EE) verfügbaren Funktionen
* Wie man eine Migration von MySQL 5.7 auf MySQL 8.0 plant
* Dinge, die vor der Migration getestet werden sollten
* Häufige Fallstricke bei einer solchen Migration
* Wie Sie sicherstellen, dass Ihr Galera Cluster während der Migration ohne Ausfallzeiten weiterläuft

Über Galera Cluster Support Subskriptionen und Migrations-Support informieren wir sie gerne persönlich. Bitte wenden Sie sich an uns, wir helfen Ihnen gerne weiter.

Oli Sennhauser, Fromdual
Sakari Keskitalo, Codership, the developers of Galera Cluster

Upgrade your MySQL 5.7 and older Galera Clusters to MySQL 8.0 with no downtime

Length:

We are sure you’ve probably already heard that MySQL 5.7 is going to reach End of Life (EOL) by October 2023. We are here to tell you that the migration from MySQL 5.7 need not be scary — MySQL 8.0 has been Generally Available for five years, and the Galera Cluster product for it, has been hardened for over three years, so it is truly time to get ready to migrate. This video includes LIVE DEMO how to do upgrade with NO DOWNTIME!

In our first session of the series, we are going to cover:

* the new features of Galera Cluster with MySQL 8 that you might benefit from, including what is available in Galera Cluster Enterprise Edition (EE)
* how to plan a migration from MySQL 5.7 or older to 8.0
* things to test for, before migrating
* common pitfalls of said migration
* how to ensure your Galera Cluster keeps humming along with no downtime

Don’t forget that Codership offers migration support to help you before and during your migration.

Here link to 1 day migration training https://galeracluster.com/2023/06/galera-cluster-5-7-or-older-to-8-0-migration-training-mariadb-and-pxc-covered-as-well/

 

A step-by-step video on how to install Galera Cluster on premises using Galera Manager

Length: 20 minutes

A step-by-step video on how to install Galera Cluster on premises, on user provided hosts using Galera Manager in 15 minutes. With Galera Manager you can manage and monitor your Galera Clusters on premises.

Galera Manager provides charts for monitoring the host and database metrics, to ensure the proper and efficient functioning of your cluster. There are over 620 metrics to choose from. Galera Manager is fully web-based, and will work in any standard web browser to administer and monitor your clusters to make sure that your set up is healthy.

A step-by-step video on how to install Galera Cluster in an Amazon EC2 using Galera Manager

Length: 15

A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager in 15 minutes. With Galera Manager you can manage and monitor your Galera Cluster in Amazon EC2. Galera Cluster in Amazon EC2 is more cost effective and comes with stronger high availability and control than using Amazon RDS.

Galera Manager Webinar recording: Managed Galera Clusters For You

Length: 55 minutes

This has been a gigantic year for Galera Manager, that if you’ve tried our releases from earlier this year to what we have today, we’ve taken on feedback to improve the UI plus add features that make our users happier and more efficient in production. In this webinar we will cover:

-How to create a 3-node Galera Cluster automatically, in Amazon Web Services and DigitalOcean
-How to deploy a 3-node Galera Cluster on your existing infrastructure
-How to use Galera Manager to manage your already existing and deployed 3-node Galera Cluster Enterprise Edition
-Cost comparisons between what we offer and other managed services
-Utilizing the over 600 monitoring metrics to effectively manage your Galera Cluster
-We are going to be mostly live demo focused and will answer your questions as well.

Managed Galera Clusters on DigitalOcean (Galera Manager webinar recording)

Length: 56

In our April 2022 release of Galera Manager, we included the ability to have fully managed clusters on DigitalOcean. This means you can create a 3-node Galera Cluster, automatically, in under ten minutes, with just an API key, billed directly to your DigitalOcean account.
In this webinar we will cover:

-Why you would consider running a Galera Cluster on DigitalOcean (in addition to our support of Amazon Web Services (AWS))
-Cost comparisons between where we offer managed services
an actual demonstration of launching a Galera Cluster on DigitalOcean
-Utilizing the over 600 monitoring metrics to effectively manage your Galera Cluster
-Your questions and answers on Galera Manager

Galera Cluster State of the Art presentation Percona Live 2022

Length: 50 mins

Galera Cluster State of the Art presentation at Percona Live 2022 Austin Texas. Codership’s CEO Seppo Jaakola explains the recent Galera Cluster, Galera Manager and Galera Load Balancer development and future roadmap.

Galera Manager is now GA with ability to launch clusters on premise and in the AWS cloud

Length: 55 mins

This is a new era in deploying, managing and monitoring your Galera Cluster for MySQL, with the recently released Galera Manager, now Generally Available (GA). Galera Manager is a web-based graphical user interface (GUI) tool that allows you to fully manage clusters in Amazon Web Services, you can also deploy clusters on user provided hosts (on premise or in the cloud) and you can also fully monitor your existing clusters.

In this video, we will cover:
Deploying a fully managed cluster in AWS
Deploying a cluster on user-provided hosts
Monitoring an existing cluster
How we have chosen to use CLONE SST for MySQL 8 deployments
How you can successfully deploy all the various servers that we support
Utilising the over 600 monitoring metrics to effectively manage your Galera Cluster

Watch the packed video for discussions and LIVE DEMOS and take your Galera Cluster deployments further with Galera Manager.

Disaster recovery with Galera Cluster 2021 edition (3 datacenters with 9 Galera Cluster nodes demo)

Length: 60 mins

Disaster Recovery with Galera Cluster 2021 Edition video with 3 datacenter (Singapore, London, San Fransisco) 9 Galera Cluster nodes demo!

We talk a lot about Galera Cluster for MySQL being great for High Availability, but what about Disaster Recovery (DR)? Database outages may occur when you lose a data centre due to power outages or natural disaster, so why not plan appropriately in advance?

In this video, we will discuss the business considerations including achieving the highest possible uptime, focus on business impact, risk mitigation, and disaster recovery itself. What scenarios are right for you: fully synchronous replication across various data centres? A mix of synchronous and asynchronous to an offsite location?

We will discuss Galera Cluster, mixed setups, the use of proxies, and also evaluate some third party solutions. We will debunk claims about how Galera Cluster might not work across data centers, tell you how to successfully do this across data centres, with performance tuning settings for all the segments. Galera 4 has also been released, making the networking protocol a lot more robust, and the changes will be discussed.

This video will focus on architecture solutions, DR scenarios and how to ensure you are successful at the end of it all.

More