Latest Blog posts

Read all >
More

News

Read all >
More

See videos

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.

Installing Galera Manager to Deploy a Galera Cluster in Amazon Web Services (AWS) in 15 minutes

Length: 15 minutes

This video tutorial describes how to install Galera Manager in 15 minutes while also deploying a Galera Cluster in Amazon Web Services (AWS), all in an automated fashion!

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!

Galera Cluster® Best Practices: DDL and Schema Upgrades

Length: 52

We will show how Galera Cluster executes DDLs in a safe, consistent manner across all the nodes in the cluster, and the differences with stand-alone MySQL. We will discuss how to prepare for and successfully carry out a schema upgrade and the considerations that need to be taken into account during the process.

TAKING FULL ADVANTAGE OF MULTI-MASTER GALERA CLUSTER®

Length: 47 MIN

In this part, we will discuss important topics related to multi-master setups:
* Practical considerations when using Galera in a multi-master setup
* Evaluating the characteristics of your database workload
* Preparing your application for multi-master
* Detecting and dealing with transaction conflicts

Galera Cluster Best Practices for DBAs and DevOps part 1

Length: 50 min

In the first part of Galera Cluster best practices series, we will discuss the following topics:

* ongoing monitoring of the cluster and detection of bottlenecks;
* fine-tuning the configuration based on the actual database workload;
* selecting the optimal State Snapshot Transfer (SST) method;
* backup strategies

More