Database Load Balancing with ProxySQL & AWS Aurora
ProxySQL is a proven solution that helps database administrators dealing with the requirements for high availability of their databases. Because it is SQL-aware, it can also be used for shaping the traffic heading towards databases...
MySQL Load Balancing: Migrating ProxySQL from On-Prem to AWS EC2
Migrations between different environments are uncommon in database world. Migrations from one provider to another one. Moving from one datacenter to another. All of this happens on a regular basis. Organisations search for expense reduction,...
ProxySQL Native Clustering with Kubernetes
ProxySQL has supported native clustering since v1.4.2. This means multiple ProxySQL instances are cluster-aware; they are aware of each others' state and able to handle the configuration changes automatically by syncing up to the most...
How to Run PHP 5 Applications with MySQL 8.0 on CentOS 7
Despite the fact that PHP 5 has reached end-of-life, there are still legacy applications built on top of it that need to run in production or test environments. If you are installing PHP packages via operating...
MySQL Replication with ProxySQL on WHM/cPanel Servers: Part Two
In the first part of the series, we showed you how to deploy a MySQL Replication setup with ProxySQL with WHM and cPanel. In this part, we are going to show some post-deployment operations for...
MySQL Replication with ProxySQL on WHM/cPanel Servers: Part One
WHM and cPanel is no doubt the most popular hosting control panel for Linux based environments. It supports a number of database backends - MySQL, MariaDB and PostgreSQL as the application datastore. WHM only supports...
Handling Large Data Volumes with MySQL and MariaDB
Most databases grow in size over time. The growth is not always fast enough to impact the performance of the database, but there are definitely cases where that happens. When it does, we often wonder...
Migrating from MySQL Enterprise to MariaDB 10.3
While it shares the same heritage with MySQL, MariaDB is a different database. Over the years as new versions of MySQL and MariaDB were released, both projects have differed into two different RDBMS platforms. MariaDB...
Database Automation with Puppet: Deploying MySQL & MariaDB Galera Cluster
In the previous blog post, we showed you some basic steps to deploy and manage a standalone MySQL server as well as MySQL Replication setup using the MySQL Puppet module. In this second installation, we...
An Overview of PostgreSQL & MySQL Cross Replication
This blog is aimed at explaining an overview of cross replication between PostgreSQL and MySQL, and further discussing the methods of configuring cross replication between the two database servers. Traditionally, the databases involved in a...
Database Automation with Puppet: Deploying MySQL & MariaDB Replication
Puppet is an open source systems management tool for centralizing and automating configuration management. Automation tools help to minimize manual and repetitive tasks, and can save a great deal of time. Puppet works by default...
How to Automate Deployment of MySQL Galera Cluster using s9s CLI and Chef
In our previous blog, we showed how devops can automate your daily database tasks with Chef. Now, let's see how we can quickly deploy a MySQL Galera Cluster with Chef using s9s CLI. Setting up...