What is PowerDNS? PowerDNS is a MySQL-based DNS server, written in C++ and licensed under the GPL. PowerDNS can be managed through a web interface (PowerAdmin). This guide shows how to install it on CentOS.   1. Installing MySQL [root@server ~]# yum -y install mysql mysql-server   2. Create system startup links for MySQL [root@server [...]

Nginx (pronounced “engine x”) is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Debian Squeeze server with PHP5 support (through FastCGI) and MySQL support. I do not issue any guarantee that this [...]

Nginx (pronounced “engine x”) is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 11.04 server with PHP5 support (through PHP-FPM) and MySQL support. I do not issue any guarantee that this [...]

This tutorial provides step-by-step instructions on how to install MySQL Admin tool on an Ubuntu 11.04 system and how to connect to a remote host with it. This should also work on most Debian based operating systems. I do not issue any guarantee that this will work for you!   Installing MySQL Administrator First we find [...]

UPDATED: January 31st, 2011: Python 2.6 now is in the normal EPEL repositories. There are some changes in the explanations below I’ve always hated Centos, probably because I’ve never been in a situation where I had to deal with the network security (other than the obvious stuff to ward off cross-site-scripting attacks and the such). [...]

How can I find all the file descriptors used by a process such as httpd (Apache web server) or mysqld (MySQL Database server)? You can use /proc file system or the lsof command to find all the file descriptors used by a process. /proc File System Example Find out process ID using the ps command, [...]

This article explains how to install OCS Inventory NG Server 2 on Linux Server. Prepared by Rafael Marangoni, from BRLink Consultoria Linux Team. Introduction OCS Inventory is a great software to make inventories. The NG Server is formed by: communication server, deployment server, and administration console. Click here to know how it works. The computers [...]

How can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers a quick and painless method of repairing those tables. Login to your server via SSH and change directories to the database that is having problems. cd /usr/local/mysql/var/[DBNAME]/ You will need to replace [DBNAME] with the [...]

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. [...]

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases [...]