MySQL

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.

This blog provides an overview of the migration process between MySQL Enterprise 8.0 and MariaDB 10.3. In this blog post, we’ll go through some of the most important differences as well as the migration procedures.

This post walks you through deployment of MySQL/MariaDB Galera Cluster using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

The blog gives a detailed account of achieving cross replication between MySQL and PostgreSQL databases using two of the renowned tools of the open source community. A step-by-step demo configuration gives the audience an easy to implement guide including a summarized explanation of which tool is rated over the other.

This post walks you through deployment of MySQL/MariaDB replication using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

Database migrations are painful, as they involve a lot of steps - from creation of the target infrastructure to migrating schema and data, and oh.. a lot of testing. Some of the steps can be automated though, you can rely on Ansible. This blog post presents a playbook that can be used to assist in the process of migrating to Galera Cluster.

The WHMCS software suite relies on a MySQL database to store its data, so how do you make it highly available? This blog post shows how to migrate the existing WHMCS database from a standalone MySQL server (provided by the WHM/cPanel server itself) to a three-node MariaDB Galera Cluster to improve the database availability.

MHA (Master High Availability) is a popular failover solution used in MySQL Master-Slave topologies. It is stable and used in production by large companies such as Facebook. In this blog, we outline the most common but important issues that you might encounter when running MHA. We’ll also see how to resolve them.

HAProxy is a great piece of software, but it may just not be enough for more demanding users and environments. How do you migrate from HAProxy to ProxySQL? This blog post explains the process and shows how ClusterControl can help.

There are many Docker images for MySQL and MariaDB, but which one should you use? This blog post lists the most popular Docker images that can be found on Docker Hub, the world's largest library and community for container images.

Whether you’re planning to migrate from Oracle database to MySQL or run your new project with MySQL, you need to know how to do copies of your data. In this blog post, we will cover some of the most typical cases of the data backups with reference to Oracle backup methods. We will tell you how to guard yourself against data loss, what tools and commands to use, and how can you recover your data.

It might not be possible to avoid disasters, but with some preparation, it is certainly feasible to reduce the impact on your business. Automatic failover is one of those things. The goal of database failover automation is to minimize your downtime and reduce loss of money. However, failover can not always be automated as there are risks; false positives may lead to unnecessary escalations.

In this blog, we’ll have a look components you may use to build an automated stack, and take a closer look at ClusterControl’s failover functionality.