For those who seeks help in different areas of Software and Hardware platform

How To Backup and Restore MySQL, MariaDB Database

MySQL and MariaDB include a built-in backup utility that simplifies the process to create a backup of a database. With mysqldump, you can create a logical backup, only if your database is accessible and running.

This guide will show you how to create a backup of MySQL and MariaDB database using mysqldump utility.
Share:

How To Backup and Restore PostgreSQL Database

If you are using PostgreSQL in a production environment, it is recommended to frequently take backups to ensure that your important data is not lost. With the backups, you will be able to quickly restore if your database is lost or corrupted. The good thing is, PostgreSQL includes tools to make database backup simple and easy to restore.

This tutorial will show you how to backup and restore your PostgreSQL database.
Share:

How To Install Ansible AWX on CentOS/RHEL 7/8

AWX provides a web-based user interface, REST API, and task engine built on top of Ansible. This tutorial will walk you through the steps to set up Ansible AWX using Docker on a CentOS/RHEL 7/8.
Share:

How To Set Up a Highly Available MongoDB Sharded Cluster on CentOS/RHEL 7/8

This tutorial will walk you through the steps to set up a highly available MongoDB sharded cluster on CentOS/RHEL 7/8.

A MongoDB sharded cluster consists of the following three components:

Shard that can be deployed as a replica set.
Config store metadata and configuration settings for the cluster.
Mongos acts as a query router, providing an interface between client applications and the sharded cluster.
Share:

How To Deploy a Highly Available Fault-Tolerant MongoDB Sharded Cluster on Ubuntu 18/19/20

This tutorial will walk you through the steps to set up a highly available fault-tolerant MongoDB sharded cluster using a shared storage on Ubuntu 18, 19 and 20.04. If you are intend to use local storage, follow this tutorial.
Share:

How To Set Up a Highly Available Multi-node Hadoop Cluster on CentOS/RHEL 7/8

This tutorial will show you how to set up a  highly available multi-node hadoop cluster on CentOS/RHEL server. Please note that, this guide is specifically written for CentOS and RHEL release 7 and 8.
Share:

How To Set Up a Highly Available Multi-node Hadoop Cluster on Ubuntu 18/19/20

Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.
Share:

How To Install and Secure MongoDB on Ubuntu 18/19/20

MongoDB is a database engine that provides access to non-relational, document-oriented databases. This tutorial will show you how to install and configure MongoDB on Ubuntu. We will also explain on some basic features and functions of the database.

Note that, this guide is specifically written for Ubuntu 18.04, 19.04, 19.10, 20.04 and Debian 9, 10.
Share:

How To Set Up a Multi-node MySQL Replication Cluster on Ubuntu 18/19/20

Database clustering is particularly useful for highly active website and application. With replication, at least two or more MySQL servers act as a cluster. MySQL multi-node circular replication adds speed and redundancy. 

This tutorial is written for Ubuntu 18.04.4, 19.04, 19.10, 20.04 and Debian 9, 10 using a non-root user, which means commands that require elevated privileges are prefixed with sudo.
Share:

How To Create a Highly Available PostgreSQL Cluster on CentOS/RHEL 8

This tutorial will walk you through the steps to set up a highly available PostgreSQL cluster using Patroni and HAProxy on CentOS/RHEL 8.
Share:

How To Create a Highly Available PostgreSQL Cluster on CentOS/RHEL 7

This step by step guide will show you how to set up a highly available PostgreSQL cluster using Patroni and HAProxy on CentOS/RHEL 7. These instruction can also be applied (slight changes may be required) if you are running an earlier release of CentOS or RHEL 6.
Share:

How To Set Up a Highly Available PostgreSQL Cluster on Ubuntu 18.04

This step by step guide will show you how to set up a highly available PostgreSQL cluster using Patroni and HAProxy on Ubuntu 18.0. These instruction can also be applied (slight changes may be required) if you are running an earlier release of Ubuntu 16.04 or 17.
Share:

How To Create a Highly Available PostgreSQL Cluster using Patroni and HAProxy

This tutorial will take you through the steps to set up a highly available PostgreSQL cluster using Patroni and HAProxy on an Ubuntu or Debian server. If you wish to skip step by step guide, watch below video tutorial that will be sufficient if you are good enough to pick things up quickly.
Share:

How To Set Up a Highly Available PostgreSQL Cluster on Ubuntu 19/20

This guide will walk you through the steps to set up a highly available PostgreSQL cluster using Patroni and HAProxy on Ubuntu 19/20.04. If you wish to skip step by step guide, the below video tutorial will be sufficient if you are good enough to pick things up quickly.
Share:

How To Set Up a Highly Available Fault-Tolerant MongoDB Sharded Cluster on Ubuntu 18/19/20

This tutorial will show you how to set up a highly available fault-tolerant MongoDB sharded cluster using local storage on Ubuntu 18, 19, 20.04. If you are intend to use shared storage for this setup, follow this tutorial.
Share:

How To Set Up a Multi-node Oracle Real Application Cluster on CentOS/RHEL 7

This tutorial will walk you through the steps to set up a multi-node oracle real application cluster using (grid 18c and database 18c) on CentOS/RHEL 7. These instruction can also be applied if you are running Fedora or Oracle Linux 7.
Share:

How To Install PostgreSQL on CentOS/RHEL 8

This guide will walk you through the steps to install PostgreSQL database on CentOS/RHEL 8. These steps can also be applied if you are running Fedora or Oracle Linux.

Note: With CentOS 8 release, yum command has been replaced with dnf and in near future yum package manager will be discontinued. It is now recommended to use dnf for installing packages but if you still wish to use yum you can use it.
Share:

How To Install or Upgrade PHP on Fedora/CentOS/RHEL

This guide will show you how to install or upgrade to latest release of PHP on Fedora, RHEL and CentOS.

Note: On CentOS/RHEL 8, yum command has been replaced with dnf and in near future yum package manager will be discontinued. It is now recommended to use dnf for installing packages on CentOS/RHEL 8 but if you still wish to use yum you can use it.
Share:

How To Set Up PhpMyAdmin with Nginx on CentOS/RHEL 8

This guide will walk you through the steps to install and configure phpMyAdmin with Nginx web server on CentOS/RHEL 8.

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL/MariaDB over the Web interface. phpMyAdmin supports a wide range of database operations including (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
Share:

How To Set Up a LEMP Stack (Nginx, MariaDB, PHP) on CentOS/RHEL 8

This guide will walk you through the steps to set up a LEMP Stack on a CentOS/RHEL 8. LEMP is a combination of Linux operating system, the E(nginx) web Server, the MySQL/MariaDB relational database management system, and the PHP programming language.

Note: With CentOS 8 release, yum command has been replaced with dnf and in near future yum package manager will be discontinued. It is now recommended to use dnf for installing packages but if you still wish to use yum you can use it.
Share: