Latest Blog posts

Read all >
More

News

Read all >
More

See videos

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.

Galera Cluster Streaming Replication for Large & Long Lasting Transactions In-Depth

Length: 60

Too Big A Bite Can Choke Your Cluster but a significant improvement has come to Galera Cluster 4 for MySQL, in the form of streaming replication. When you are dealing with large (greater than 2GB in size) or long running transactions, previous releases of Galera Cluster would reject the transaction; in the current release transactions can be split into fragmented chunks and those rows can be replicated in chunks to the other nodes even before commit. This is the feature that will remove you from all cluster stall issues due to large transaction processing!

The New Galera Manager Deploys Galera Cluster for MySQL on Amazon Web Services

Length: 50

Video includes live demo how to install Galera Manager and deploy easily Galera Cluster on Amazon Web Service for Geo-distributed Multi-master MySQL, Disaster Recovery and fast local reads and writes.

Now you can monitor and manage your Galera Cluster with Graphical Interface.

“The presentation was great with lots of valuable information. We will definitely try to implement Galera Manager in our environment very soon” stated attendee of the webinar.

Galera Cluster 4 for MySQL 8 Release Webinar

Length: 58

The much anticipated release of Galera Cluster 4 for MySQL 8 is now Generally Available. Please join Codership, the developers of Galera Cluster, and learn how we improve MySQL High Availability with the new features in Galera Cluster 4, and how you can benefit from using them. We will also give you an idea of the Galera 4 short term road map, as well as an overview of Galera 4 in MySQL, MariaDB and Percona.

Learn about how you can load data faster with streaming replication, how to use the new system tables in the mysql database, how your application can benefit from the new synchronization functions, and how Galera Cluster is now so much more robust in handling a bad network for Geo-distributed Multi-master MySQL.

Choosing between MySQL Galera, MariaDB Galera and Percona XtraDB Cluster

Length: 45 min

There are many Galera Cluster distributions and sometimes differences are well worth noting. We get a lot of queries about which Galera Cluster to use, or why one should use one distribution over the other.

Learn about Galera Cluster with MySQL 5.7 from Codership, and we’ll compare it with Galera Cluster 4 with MariaDB 10.4, and Percona XtraDB Cluster 5.7 with Galera 3. This is also the webinar where we preview Galera Cluster 4 with MySQL 8.0 as well as compare it with the preview release of Percona XtraDB Cluster 8.0.

Overall, learn why distributions exists, and how you can get the most out of your Galera Cluster experience.

Planning for Disaster Recovery (DR) with Galera Cluster

Length: 50 min

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

We will discuss the business considerations including achieving the highest possible uptime, analysis business impact as well as risk, focus on disaster recovery itself, as well as discussing various scenarios, from having no offsite data to having synchronous replication to another data centre.

This webinar will cover MySQL with Galera Cluster, as well as branches MariaDB Galera Cluster as well as Percona XtraDB Cluster (PXC). We will focus on architecture solutions, DR scenarios and have you on your way to success at the end of it.

Running Galera Cluster on Microsoft Azure

Length: 50 min

Do you want to run Galera Cluster in the Microsoft cloud? Why not learn to setup a 3-node Galera Cluster using Microsoft Azure Compute Virtual Machines, and run it yourself. In this webinar, we will cover the steps to do this, with a demonstration of how easy it is for you to do.

In addition, we will cover why you may want to run a 3-node (or more) Galera Cluster (active-active multi-master clusters) instead of (or in addition to) using Azure Database for MySQL or MariaDB. We will also cover cost comparisons.

Learn about storage options, backup & recovery, as well as monitoring & metrics options for the “roll your own Galera Cluster” in Azure.

Running Galera Cluster on Amazon EC2 and comparing it to RDS and Aurora

Length: 56 minutes

Do you want to run Galera Cluster in the cloud? Why not learn to setup a 3-node Galera Cluster using Amazon Web Services (AWS) Elastic Compute Cloud (EC2), and run it yourself?

In this webinar, we will cover the steps to do this, with a demonstration of how easy it is for you to do. We will also cover how you may want to load balance traffic to your Galera Cluster using a proxy like ProxySQL.

In addition, we will cover why you may want to run a 3-node (or more) Galera Cluster (multi-master synchronous clusters) instead of using Amazon Relational Database Service (RDS) MySQL, which has the ability to have asynchronous replication (Read Replicas), and High Availability provided by DRBD (Multi-AZ). We will also cover where Galera Cluster differs from Amazon Aurora RDS for MySQL.

Learn about storage options, backup & recovery, as well as monitoring & metrics options for the “roll your own Galera Cluster” in EC2.

The MySQL High Availability Landscape and where Galera Cluster fits in

Length: 60 minutes

The MySQL Server High Availability landscape provides with a slew of tools to help you ensure that your databases keep humming. Such tools are Galera Cluster, however, it is worth looking at semi-synchronous replication with failover tools, and also the usual leader-follower asynchronous replication. Today more workloads are moving to the cloud, and what failover options do you get with Amazon RDS for MySQL or even Aurora? What about the newfangled group replication and InnoDB Cluster? And let us not forget that Galera Cluster has spawned branches too!

More