Author: Rahul

XCache is a fast, stable PHP opcode cacher. This relatively new opcode caching software has been developed by mOo. XCache optimizes performance caching the compiled state of PHP scripts into the RAM and uses the compiled version straight from the RAM. This may increase php execution 1-5 times faster than default installation. Read more about XCache. This article will help you to install and configure XCache on CentOS, RHEL and Fedora Systems. Step 1: Install XCache for PHP You can simply use yum command to install xcache for php from epel repository. If you do have installed epel repository, Enable…

PHP eAccelerator is used for improving performance of php scripts by optimize and cache them in compiled states. eAccelerator stores compiled PHP scripts in shared memory and executes code directly from it. eAccelerator typically reduces server load and increases the speed of your PHP code by 1-10 times. There are also other options available to optimize php scripts such as APC, Memcached, XCache etc. Read More Installing PHP eAccelerator PHP eAccelerator can be simply installed using yum package manager on CentOS and RHEL systems. Also we can use source code to install it. This article will help you install and…

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…

Regularly cleaning out old unused files from your server is the best practice. For example, if we are running a daily/hourly backup of files or databases on the server then there will be much junk created on the server. So clean it regularly. To do it you can find older files from the backup directory and clean them. 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 older Than 30 Days Using the find command, you can search…

What is function: A function which can also be referred to as subroutine, procedure is a block of code used for specific tasks. Function’s also have a property called reusability. This tutorial will help you to how to create and use functions in shell scripts. Create First Function in Shell Script Create your first function in shell script showing output “Hello World!”. Create a shell script “script.sh” using following code. # vim script.sh #!/bin/bash funHello(){ echo “Hello World!”; } # Call funHello from any where in script like below funHello Execute Script # sh script.sh ouput: Hello World! How to…

Stored procedures and Triggers are first introduces with MySQL 5.0. So if you are still using MySQL older version’s upgrade it to MySQL 5.0 or higher version to use these features. This article will help you with how to make a dump of Stored procedures and triggers using the mysqldump command. What is Stored Procedure? A stored procedure, by definition, is a segment of declarative SQL code that is stored in the database catalog and can be invoked later by a program, a trigger, or even a stored procedure. What is Triggers? Triggers are event-driven specialized procedures, they are stored…

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.