MySQL

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.

Utilizing the cloud allows your business to benefit from the cost-savings and flexibility that come with cloud computing. In this blog, we will show you how to deploy database clusters on AWS, Google Cloud or Microsoft Azure using ClusterControl.

Amazon Aurora is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. In this blog we will show you how to leverage ProxySQL to balance the load of your Aurora database.

To efficiently manage multiple ProxySQL nodes, one has to make sure whatever changes performed on one of the nodes is applied across all the nodes. Without native clustering, one has to manually export the configurations and import them to the other nodes. This blog walks you through on how to run ProxySQL native clustering with headless service on Kubernetes.