Categories
Products
Technologies
Top Rated docs

July 8, 2019

MySQL Replication with ProxySQL on WHM/cPanel Servers: Part One

WHM and cPanel are 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 standalone...

July 2, 2019

How to Use the Failover Mechanism of MaxScale

Ever since ClusterControl 1.2.11 was released in 2015, MariaDB MaxScale has been supported as a database load balancer. Over the years MaxScale has grown and matured, adding several rich features. Recently MariaDB MaxScale 2.2 was...

June 27, 2019

How to Setup Asynchronous Replication Between MariaDB Galera Clusters

Galera Cluster, with its (virtually) synchronous replication, is commonly used in many different types of environments. Scaling it by adding new nodes is not hard (or just as simple a couple of clicks when you...

June 13, 2019

Exploring the Different Ways to Encrypt Your MariaDB Data

Encrypting your MariaDB database, whether it is in-transit and at-rest, is one of the most important things that an organization should consider if you value your data. Organizations that deal with financial transactions, medical records,...

May 28, 2019

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...

May 14, 2019

Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL

HAProxy and ProxySQL are both very popular load balancers in MySQL world, but there is a significant difference between both those proxies. We will not go into details here, you can read more about HAProxy...

May 9, 2019

How to Deploy PostgreSQL to a Docker Container Using ClusterControl

Docker has become the most common tool to create, deploy, and run applications by using containers. It allows us to package up an application with all of the parts it needs, such as libraries and...

May 7, 2019

How to Automate Database Failover with ClusterControl

Recovery Time Objective (RTO) is the time period within which a service must be restored to avoid unacceptable consequences. By calculating how long it can take to recover from a database failure, we can know...

May 3, 2019

Introducing ClusterControl Spotlight Search

Included in the latest release, ClusterControl 1.7.2 introduces our new and exciting search functionality we’re calling “ClusterControl Spotlight.” ClusterControl Spotlight allows you to... Navigate the application faster Execute any action from any page within the...

May 2, 2019

How to Use pgBackRest to Backup PostgreSQL and TimescaleDB

Your data is probably the most valuable assets in the company, so you should have a Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident or hardware failure. A backup...

April 29, 2019

An Overview of Streaming Replication for TimescaleDB

Nowadays, replication is a given in a high availability and fault tolerant environment for pretty much any database technology that you’re using. It is a topic that we have seen over and over again, but...

April 26, 2019

Benchmarking Manual Database Deployments vs Automated Deployments

There are multiple ways of deploying a database. You can install it by hand, you can rely on the widely available infrastructure orchestration tools like Ansible, Chef, Puppet or Salt. Those tools are very popular...

Subscribe below to be notified of fresh posts