MySQL

In this blog post, we are going to deploy a high-available setup for our private "Dropbox" infrastructure using Nextcloud, GlusterFS, Percona XtraDB Cluster (Galera Cluster), ProxySQL with ClusterControl as the automation tool to manage and monitor the database and load balancer tiers.

New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the second part we will show you how to enable Streaming Replication and what the results could look like when you use it.

New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the first part of this blog we will tell you about this new feature and how you can use it.

Amazon EC2 is a very popular environment to deploy your infrastructure on and MySQL Galera is a very popular high availability solution for MySQL. How do they work together? In this blog post we will show how one can deploy the latest version of Galera Cluster on Amazon EC2.

Hosting your database with a cloud provider, such as Microsoft Azure, still requires you to prepare and define your disaster recovery policy. In this blog, we will cover all of the backup and restore methods Azure offers for MySQL.

This is the second part of a two-part series. Here we look into designing a geo-distributed MySQL Galera Cluster and explain how it can be easily deployed using ClusterControl

What is the best way to create a geo-distributed cluster? Can Galera Cluster be used for such scenario? What are the cons of Galera compared to regular MySQL replication? This blog attempts to answer those questions.

MySQL Galera Cluster 4.0 is the new kid on the database block with very interesting new features. Currently it is available only as a part of MariaDB 10.4 but in the future it will work as well with MySQL 5.6, 5.7 and 8.0. In this blog post we would like to go over some of the new features that came along with Galera Cluster 4.0.

ClusterControl as a proactive monitoring tool also comes with a troubleshooting toolset to help users troubleshoot and fix the database issues as they happen. This blog post looks into each of the troubleshooting tools in greater details.

Cloud Providers provide great options when it comes to failover, but they may not be right for every application. In this blog post we will spend a bit of time analysing the pros and cons of using the DBaaS solutions compared with designing an environment manually or by using a database management platform, like ClusterControl.

Designing a large system that is fault-tolerant, highly-available, with no Single-Point-Of-Failure (SPOF) requires proper testing to determine how it would react when things go wrong. In this blog we will explore the failover and failback operations of Amazon RDS using Aurora.

Almost all cloud vendors provide some sort of high availability options in their managed relational databases. In this blog we are going to explore the failover handling for MySQL SQL nodes on Google Cloud Platform

Drupal is a CMS designed to create everything from tiny to large corporate websites. Failover comes in handy for any admin as it can eliminate long hours of downtime caused by corruption the need for maintenance. In this blog we’ll discuss how you can implement database failover for your MySQL or PostgreSQL databases.

Amazon Aurora Serverless provides an on demand, auto-scaling, high-availability relational database that only charges you when it’s in use. Almost all aspects of MySQL are handled automatically by Aurora Serverless including scaling. This blog post documents our way to understand the automatic scaling behaviour of this database technology.

In the final post in our three-part blog series comparing MySQL Galera Cluster offerings we explore Microsoft Azure. Azure isn’t known for being open-source friendly, but in this blog we look at its features such as security, pricing, monitoring, backups and which setup is best for your Galera Cluster.

WordPress is, by far, the most popular CMS in the world powering millions of websites from small to large. But how can you ensure the unavailability of your database will not impact the website? In this blog post we will show how to achieve failover for your WordPress website using ClusterControl.

While GCP (Google Cloud Platform) does not provide direct support for MySQL Galera Clusters it does offer a wide-variety of efficient and powerful services that you can leverage. In this blog we’ll discuss this options and how you can use them to build a highly-available Galera setup.

In this blog post, we compare automatic failover times for Amazon Aurora, Amazon RDS for MySQL, and MySQL Replication deployed and managed by ClusterControl. The type of failover that we are going to do is slave promotion in case of master goes down, where the most up-to-date slave takes over the master role in the cluster to resume the database service.

While Amazon RDS does not provide direct support for MySQL Galera Clusters, in this blog we will explore several approaches from technology, instance type, and pricing that you can leverage to use Amazon to host your highly-available Galera setup.

Disaster recovery environments can be expensive. Luckily, they don’t always have to be. This blog post explains how to us Amazon AWS to set up a DR solution on a shoestring budget.