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 Webinar, 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

…

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 Webinar, 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

…

Since we just released Galera Manager, it seemed like a good idea to do a deployment on Amazon Web Services (AWS) using Red Hat Enterprise Linux 8 and MySQL 8.

We start by launching an EC2 instance and choosing Red Hat Enterprise Linux 8 (HVM) and most importantly, we only choose the 64-bit (x86) architecture as we do not support ARM just yet. We choose a t2.micro instance for Galera Manager since this is just a test instance, but it is well worth knowing that 10GB which is the default EBS size may be a little small if you plan on using this for sometime.

…

Codership, the leading MySQL High Availability clustering solutions company behind Galera Cluster, is pleased to announce the general availability of Galera Manager, a web-based graphical user interface (GUI) tool to easily deploy and manage your Galera Clusters. With today’s release, you can now create fully managed 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.

We now have the concept of a managed node (your typical MySQL instance) and managed host (your typical Linux instance) which you use to deploy Galera Cluster in Amazon EC2, a managed node and a monitored host for user provided hosts (on premise or …

Codership, the developers of Galera Cluster for MySQL, provides training sessions in September 2021 for EMEA and USA timezone.

The Advanced Database Administrator with Galera Cluster training course teaches you how to install and configure in real-time a Galera Cluster for your application use cases. You will participate in interactive hands-on labs. Our expert instructor will teach you how to design and maintain your Galera Cluster for MySQL high availability and scalability. If you are a DBA or been given a Galera Cluster to manage, this is the course for you, as you’ll learn how to run your Galera Cluster in an optimal fashion, from setup, performance tuning, monitoring, as well as backups and more.

For more information, please read the full CONTENT BRAKEDOWN  course.

Course Dates

EMEA: …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7 and 8.0, consisting of MySQL-wsrep 5.7.34 (release notes, download) and MySQL-wsrep 8.0.25 (release notes, download) with Galera replication library 3.34 (release notes, download) implementing wsrep API version 25 …

Codership first released a version of MySQL 5.7 with the audit log plugin back when Galera Cluster for MySQL 5.7.30 was released back in June 2020. More recently, we also added the audit log plugin to Galera Cluster for MySQL 5.6.51 in April 2021, but I guess the most important was that we also started including it in Galera Cluster for MySQL 8.0.21 too. We also started supporting it across various distributions, including Debian. For today’s exercise, we will use Galera Cluster for MySQL 8.0.23 on CentOS 7 (compatible with Red Hat Enterprise Linux 7). …

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 webinar, 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 …

Just last week we had a Galera Cluster for MySQL streaming replication feature deep dive webinar, by the person that implemented it – Seppo Jaakola. In fact, if you haven’t already read the entire story, we encourage you to read: Galera Streaming Replication: Too Big A Bite Can Choke Your Cluster. We also have the 60 minute video recording for reference.

A huge number of Galera Cluster users have always complained about having issues with large transactions (where writes hang but reads are OK), and we are certain that the correct usage of streaming replication is what will ease that burden. What constitutes a large transaction? Typically when you make big number of …

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!

While disabled by default, you can use it and configure it dynamically, and there is also the ability to monitor streaming replication progress. Come to this webinar to learn from the primary author, Seppo Jaakola, on why he implemented the feature, how you can use it, finding the optimal fragment size based on workload, and the design trade-offs for the initial release in where the focus was more on functionality over …