MySQL

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.

Presto is a parallel distributed SQL engine that allows you to run interactive big data analytics queries on a wide variety of data sources. In this blog, we are going to show you how you can install it and use it with your existing RDBMS systems.

This blog walks you through running PHP 5 applications with the latest version of MySQL 8.0 on CentOS 7 operating system. This blog is based on the real experience that we faced when we were working with an internal project that requires PHP 5 application to be running alongside our new MySQL 8.0 in the new environment.

Indexing is one of the ways for most databases to improve READ performance. In this blog, we’ll look in detail at how PostgreSQL and InnoDB implement indexing and look at some of the major differences between their implementations.

ClusterControl 1.7.3 includes improvements to PostgreSQL support including the ability to run multiple instances on a single host. It also includes support for new point-and-click cloud deployments to the top three cloud providers.

In this second part of how to run MySQL Replication with ProxySQL on WHM cPanel servers, we cover the post-deployment operations for maintenance, management, failover as well as advantages over the standalone setup.

In this two-part blog series, we are going to give a complete walkthrough on how to run MySQL Replication with ProxySQL on WHM cPanel servers. This first part covers the deployment of MySQL Replication and ProxySQL, as well as ProxySQL integration with cPanel via standardized hooks integration. The second part will cover management and ongoing maintenance of the setup.

Handling large data volumes is always problematic. In this blog we’ll discuss several options to make it more manageable when using MySQL or MariaDB as the database technology.