ProxySQL Cluster Deployment

ProxySQL is a high performance database aware proxy for MySQL and MariaDB servers. ProxySQL can be deployed in a cluster and supports dynamic routing of SQL traffic to multiple backend database servers for high availability and efficient workload management. ProxySQL Installation The following deployment is based on Ubuntu 22.04 with…

Redis HA Deployment with Sentinel

Redis is an open-source in-memory key-value data store. It can be used as a database, cache, and message broker. It supports various data structures such as strings, hashes, lists, sets, and sorted sets, with atomic operations for manipulating them. Redis also supports simple, powerful commands for working with data, such…

Storage High Availability Using DRBD

DRBD provides replication of storage across multiple servers. Its a software solution to perform block level replication. DRBD is able to perform real-time replication of data which is transparent to the upper layer applications. The replication can be done synchronously or asynchronously. The DRBD block replication requires a raw disk…

MariaDB Galera Cluster Setup

Database High Availability can be done in two modes. One is Primary-Secondary configuration which allows one DB server to act as Primary and perform Read-Write operations. The data is replicated to Secondary nodes which can perform Read-Only operations. Another mode is Multi-Master configuration which allows Multiple DB Servers to act…

Domain Name Filtering using PowerDNS Resolvers

The PowerDNS Recursor is a high-performance DNS recursor with built-in scripting capabilities. The following guide outlines the deployment methodology and installation instructions for performing Domain Name filtering via DNS servers. The solution includes PowerDNS Recursor application deployed on Ubuntu 20.04 servers.The domain block list will be stored in SQLITE3 database…

Global Server Load Balancing via DNS

The following guide outlines the deployment methodology and installation instructions for DNS based Global Load Balancing service. The solution includes PowerDNS Authoritative application deployed on Centos 7.9 servers. The application supports static as well as dynamic DNS records. The dynamic records contain small snippets which can perform different checks based…