MySQL

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.

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.

ProxySQL 2.0 has been released recently with quite a few interesting features, including causal reads, SSL for frontend connections and native support for Galera Cluster. In this blog post, we will explore these new features.

Good system administrators and devops hate performing mundane tasks and constantly look for ways at automating themselves out of the job. There are plenty of automation tools out there to help the cause. But if automation is a no brainer, why aren’t more people doing it? In this blog post we compare three ways of deploying a MySQL Galera cluster - manual, Ansible playbook and ClusterControl.

In case of master failure in a MySQL Replication setup, the most updated slave can be promoted to new master and all slaves repointed to the new master. But once the failed master has been fixed, what is the best way to re-introduce it as master, so as to restore the original topology.

This blog post shows how to perform the MySQL master failback operation.