Categories
Products
Technologies
Top Rated docs

September 10, 2019

Comparing Galera Cluster Cloud Offerings: Part Three Microsoft Azure

Microsoft Azure is known to many as an alternative public cloud platform to Amazon AWS. It's not easy to directly compare these two giant companies. Microsoft's cloud business -- dubbed commercial cloud -- includes everything...

August 23, 2019

Comparing Galera Cluster Cloud Offerings: Part One Amazon AWS

Running a MySQL Galera Cluster (either the Percona, MariaDB, or Codership build) is, unfortunately, not a  supported (nor part of) the databases supported by Amazon RDS. Most of the databases supported by RDS use asynchronous...

August 23, 2019

Building a MySQL or MariaDB Database Cold Standby on Amazon AWS

High Availability is a must these days as most organizations can’t allow itself to lose its data. High Availability, however, always comes with a price tag (which can vary a lot.) Any setups which require...

August 19, 2019

A Guide to MySQL Galera Cluster Restoration Using mysqldump

Using logical backup programs like mysqldump is a common practice performed by MySQL admins for backup and restore (the process of moving a database from one server to another) and is also the most efficient...

June 27, 2019

How to Setup Asynchronous Replication Between MariaDB Galera Clusters

Galera Cluster, with its (virtually) synchronous replication, is commonly used in many different types of environments. Scaling it by adding new nodes is not hard (or just as simple a couple of clicks when you...

June 26, 2019

Database User Management: Managing Roles for MariaDB

It’s always a headache... you need to add a new user role or change some privileges, and you need to assign it one... by... one. This is a regular duty, especially in large organizations, or...

June 7, 2019

What's New in MariaDB Cluster 10.4

In one of the previous blogs, we covered new features which are coming out in MariaDB 10.4. We mentioned there that included in this version will be a new Galera Cluster release. In this blog...

October 10, 2017

Monitoring Galera Cluster for MySQL or MariaDB – Understanding Metrics (Updated)

To operate any database efficiently, you need to have insight into database performance. This might not be obvious when everything is going well, but as soon as something goes wrong, access to information can be...

February 29, 2016

Webinar Replay: How to Build Scalable Database Infrastructures with MariaDB & HAProxy

Thanks to everyone who participated in last week’s live webinar on how CloudStats.me moved from MySQL to clustered MariaDB for high availability with Severalnines ClusterControl. The webinar included use case discussions on cloudstats.me’s database infrastructure...

November 9, 2015

Understanding the MySQL Galera Cluster and MariaDB Cluster Diagnostic Logs

In a previous post, we discussed the error log as a source of diagnostic information for MySQL. We’ve shown examples of problems where the error log can help you diagnose issues with MySQL. This post...

August 25, 2015

How to Preform an Online Upgrade of MariaDB Galera Cluster 5.5 to MariaDB 10

The MariaDB team released a GA version of MariaDB Galera Cluster 10 in June 2014. MariaDB 10 is the equivalent of MySQL 5.6, and therefore, packed with lots of great features. In this blog post,...

July 15, 2015

How to Avoid SST When Adding a New Node to MySQL Galera Cluster

State Snapshot Transfer (SST) is a way for Galera to transfer a full data copy from an existing node (donor) to a new node (joiner). If you come from a MySQL replication background, it is...

Subscribe below to be notified of fresh posts