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...
PostgreSQL Index vs InnoDB Index – Understanding the Differences
Considering the current major use-case of a database as to retrieve data, it becomes very important that its performance is very high and It can only be achieved if data is fetched in the most...
How to Monitor PostgreSQL Running Inside a Docker Container: Part Two
This is the second part of the multi-series How to Monitor PostgreSQL Running Inside a Docker Container. In Part 1, I presented an overview of docker containers, policies and networking. In this part we will...
How to Monitor PostgreSQL Running Inside a Docker Container: Part One
Monitoring is the action of watching and checking over a period of time in order to see how what you are monitoring develops and performs. You do it so you can make any necessary changes...
Deploying & Configuring MongoDB Shards with Ansible
Database systems work better when there is a distributed workload among a number of running instances or rather data is categorized in an easy manner. MongoDB utilizes sharding such that data in a given database...
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...
PostgreSQL Deployment and Maintenance with Ansible
Ansible is one of the most well-known and widely-used IT automation tools, it helps us in automating IT operational tasks such as... Bootstrapping the host (VM or bare-metal machine) from scratch Configuring hosts and services...
MariaDB MaxScale Load Balancing on Docker: Management: Part Two
This blog post is a continuation of MariaDB MaxScale Load Balancing on Docker: Deployment - Part1. In this part, we are going to focus more on management operations with advanced use cases like service control,...
An Overview of MongoDB Schema Validation
Everyone knows that MongoDB is schemaless, then why it is required to perform schema validation? It is easy and fast to develop the application with MongoDB's schema-less behavior and use it as a proof of...
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...
How to Optimize PostgreSQL Logical Replication
Logical Replication or Pglogical is a table level, WAL based replication mechanism which replicates the data of specific Tables between two PostgreSQL instances. There seems to be a confusion between “pglogical” and “Logical Replication”. Both...