Author: Rahul

Many times we faced issues with mirroring setup with authentication, So in this article we are going to configure database mirroring by creating endpoint and required certificates for authenticate and authorization. Follow below steps to setup database mirroring in sql server with 1 Principal server and 1 Mirror server. This article does not include witness server. So if you want automatic failover setup this article would not help you. Read this article for role of witness server Step 1. Setup Endpoint and Certificates With the first step we are going to create endpoint on both server and configure certificates for…

Keepalived is used for IP failover between two servers. It facilities for load balancing and high-availability to Linux-based infrastructures. It works on VRRP ( Virtual Router Redundancy Protocol ) protocol. We have running two load balance servers using HAProxy and now we need to implement VRRP between both servers. This tutorial will help you to configure KeepAlived, Use this tutorial to configure HAProxy on both servers. Network Scenario: 1. LB1 Server: 192.168.10.111 ( eth1 ) 2. LB2 Server: 192.168.10.112 ( eth1 ) 3. Virtual IP: 192.168.10.121 Now we are implementing ip failover setup between LB1 and LB2 servers. Graphical representation…

Virtual private server (VPS) hosting is a popular option for small businesses looking for more power and flexibility than shared hosting can offer. With a VPS, your business gets its own dedicated slice of a server, with resources that are dedicated to your business and not shared with other users. This can result in faster load times, better security, and more control over your hosting environment. In this article, we’ll look at the top 5 VPS hosting providers for small businesses. We’ll consider factors like price, scalability, and customer support to help you choose the best provider for your business.…

File creation time is stored in inode in EXT4 file system. An earlier version of EXT files systems doesn’t support file creation time. There is a crtime (create time) timestamp in the debugfs stat output. finally EXT4 supports create time just like btime in NTFS windows. Follow below instructions to how to find file creation time. Select an existing file or create a new file for testing. For this example, I am using an existing file. Step 1 – Find Inode Number of File First of all, find the inode number of any file using the following command on terminal.…

Some times MySQL replication creates problems and slave could not sync properly from the master database server. It may cause due to lots of reason’s. Only the question is how to fix it? This article will guide you to how to reset MySQL replication and it will start again from scratch. Warning: After using this tutorial, All of your bin-log files will be deleted, So if you want, you may take a backup of bin-log files first and then follow the instructions. At Slave Server: At first we need to stop slave on slave server. Login to the MySQL server…

AjaXplorer is an open source solution for creating file sharing platform with your server. It allows to share files and documents over the internet using web interface, It also available in Android application to access. Step 1: Download Archive and Extract Download AjaXplorer archive file and extract its content at document root of web server using below commands. # cd /var/www/html # wget http://kaz.dl.sourceforge.net/project/ajaxplorer/ajaxplorer/stable-channel/5.0.3/ajaxplorer-core-5.0.3.tar.gz # tar xzf ajaxplorer-core-5.0.3.tar.gz # mv ajaxplorer-core-5.0.3 ajaxplorer Step 2: Create MySQL Database and User AjaXplorer can be configured with MySQL or sqlite3 database. In this article we are using MySQL. Use following commands to create…

After adding few of tutorials about PHP optimizers like Memcached, XCache and PHP eAccelerator. Which are used to optimize php scripts by caching them in compiled state. This article will help you to configure mod_pagespeed to optimize Apache server performance. Ther are number of features availble in mod_pagespeed, Find the list of few important features: Automatic website and asset optimization Latest web optimization techniques 40+ configurable optimization filters Free, open-source, and frequently updated Deployed by individual sites, hosting providers, CDNs This article will help you to how to install mod_pagespeed Apache module on CentOS, RHEL, and Fedora systems. Step 1…

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…