Author: Rahul

Managing a MySQL database doesn’t always mean accessing it from the same server where it’s hosted. In many situations, especially with the rise of distributed applications and cloud services, you might need to connect to a MySQL server from a remote location. Here’s a guide on how to set this up. Step 1: Backup Your Database Before you make any changes to your MySQL configuration or grant remote access, always back up your data. Use the mysqldump command: mysqldump -u [username] -p [database_name] > backup.sql Step 2: Modify MySQL Configuration MySQL’s default setting is to listen only on the localhost…

GZIP compression is a powerful tool that can significantly improve website performance by reducing the size of files transferred between the web server and client. In this article, we will explore what GZIP compression is, why it matters, and how to enable it on Apache running on Ubuntu. What is GZIP compression? GZIP compression is a method of compressing files before sending them over the network. It works by analyzing the content of a file and finding patterns that can be replaced with shorter symbols, reducing the overall size of the file. When the client receives the compressed file, it…

Munin is a networked resource monitoring tool that can help analyze resource trends. Munin the monitoring tool surveys all your computers and remembers what it saw. It presents all the information in graphs through a web interface. This article will help you to install Munin Network Monitoring Tool on your CentOS, Fedora, and Red Hat systems. Step 1 – Enable Yum Repository First of all, you need to add enable EPEL yum repository in your system. Use the following command to install as per system architecture. yum install epel-release Step 2 – Install Munin Packages Use the following command to…

Network File System (NFS) is a distributed file system protocol. which allowing a user on a client computer to access files over a network in a manner similar to how local storage is accessed. This article will help you to install and configure NFS on Ubuntu systems and export a directory and mount it on the client system. Network Details: We have running two Ubuntu 16.04 LTS Systems in same network 192.168.1.0/24, Below given IPs are configured on server and client, which we will use in this tutorial. Server: 192.168.1.100 Client: 192.168.1.110 Step 1 – Install NFS Server on Ubuntu…

Deleting old files in Linux can help keep your system clean and free up space. If you have files older than 30 days that you no longer need, this guide will show you how to remove them step-by-step. Whether you’re a beginner or just need a refresher, you’ll find easy instructions here. We’ll start by understanding the basic commands and then move on to applying them in your terminal. This article describes you to how to find and delete files older than 30 days. Here 30 days older means the last modification date is before 30 days. 1. Delete Files…

Shell scripting is an essential skill for automating tasks on Unix-like systems, enabling users to execute sequences of commands in scripts. A fundamental concept that enhances the power and efficiency of these scripts is the use of functions. This guide aims to demystify functions in shell scripting, making them accessible to beginners. What Are Functions in Shell Scripting? In shell scripting, a function is a named block of code that performs a specific task. Just like functions in traditional programming languages, shell functions allow you to encapsulate logic, making your scripts more modular, readable, and maintainable. Functions are particularly useful…

The database is the most crucial part of any application, and as a developer, ensuring the safety of your database is crucial. MySQL, a popular database management system, uses stored procedures and triggers to automate tasks and manage data efficiently. However, these valuable components are often overlooked during backup processes, potentially leading to data loss or malfunction. In this guide, we’ll walk you through the simple steps to back up and restore MySQL stored procedures and triggers. Whether you’re a beginner or an experienced developer, you’ll find this guide easy to follow and essential for maintaining your database’s integrity. Why…

If you are getting above error while restoring backup of database in postgresql. This error means you have taken backup in plain text format. Error: pg_restore: [archiver] input file does not appear to be a valid archive Solution: To restore plain text backup using below command. Backup filename: backup-db.txt Database name: mydb # cat backup-db.txt | psql mydb I hope it will help you.

CouchDB is an open source project and NoSQL, document oriented database server. It stored data with JSON documents. It also provides web interface to access documents online. Click here to read more details about CoutchDB This tutorial will help you to install Apache CouchDB server on CentOS, RedHat 7/6 servers. Step 1 – Enabel Yum Repositories First of all, use below command to install EPEL yum repository on your system. In case epel repository package not found, use this tutorial to install epel package. yum install epel-release-7-11.noarch.rpm Now create yum repository for Apache Couchdb. Create a file /etc/yum.repos.d/apache-couchdb.repo file using…

MySQL Master-Slave replication is to set up slave server to update immediately as soon as changes done in Master server. But it will not update Master if there are any changes done on slave server. Read this article to setup Master-Slave replication. This article will help you to set up Master-Master replication between MySQL servers. In this setup if any changes made on either server will update on an other one. Setup Details: Master-1: 192.168.1.15 Master-2: 192.168.1.16 Database: mydb If you are using different – different versions of MySQL on either servers use this link to check compatibility. Step 1.…