To See GNU/Linux on all Desktops in this world.

How to setup Linux loadbalancer using: LVS + ldirectord + heartbeat 2 on CentOS

Steps to setup heartbeat-2.1.4 on centos 5.2.

In this document you will find procedure how to setup lb01 and lb02 as loadbalancer for 2 or more web servers. In this example I have used only 2 webservers i.e web01 and web02. In total there are 4 virtual servers. All four servers are virtual servers. I am using Xen as dom0. 

After installing base operating system (I have installed CentOS 5.2) we need to install following packages on both loadbalancer linux boxes. As heartbeat is not available with standard packages you will need to download it.

How to convert / migrate image based vm (guest / dom-U) to LVM based vm (virtual machine)-(Guest / dom-U) using xen.

Hi all, In this article we will learn how to install virtual machine on sparse file (image file) and how to migrate / move it to LVM based storage / disk. It is recommended to use LVM based partition to install virtual machines for productions environment, as you may experience performance issues if you use images (sparse files) to install virtual machine.

How to install virtual machine on image based disk ...

Details about default mysql-server configuration file my.cnf - Part 1

In this video tutorial you will learn about default configuration file my.cnf for mysql server. you can add / change various configuration parameters in this file so that when ever you restart server, new configuration values will get in effect.
On Ubuntu /etc/mysql/my.cnf OR on centos / redhat / fedora it is /etc/my.cnf

http://www.youtube.com/watch?v=brQ0sRbY1VU&feature=youtu.be
OR
http://www.dailymotion.com/video/x10t024_mysql-video-tutorial-my-cnf-bro...

[mysqld]
user = mysql
port = 3306
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld.sock

Mysql command line client (mysql) overview linux / ubuntu / centos / redhat /fedora

This video tutorial will teach you about various / different command line (CLI) options available with mysql command to connect to mysql-server.
–user is same as -u
–host is same as -h
–password is same as -p
–port is same is -P (this is upper case P) for port
–help | -? for more options i.e mysql –help
-e — execute sql statement from command line mysql -e ‘show databases;’
-D –database – select particular database
-H –html — produce output in html format
-X –xml — produce output in xml format
-t –table — produce output in table format

Configure sendmail to start logging Subject in maillog

Hi Friends,
In this article we will learn how to configure sendmail so that you can log "Subject" in /var/log/maillog as by default sendmail does not log Subject to maillog file.

How To Disable User Account in Linux

This short how to will show how to disable a user account under linux. This might be useful in the situation where you don’t want to permanently remove the user, but you just want it disabled and no longer able to use the system. The user will still receive emails for example, but he will not be able to login and check them out.

How To Disable User Account in Linux

This short how to will show how to disable a user account under linux. This might be useful in the situation where you don’t want to permanently remove the user, but you just want it disabled and no longer able to use the system. The user will still receive emails for example, but he will not be able to login and check them out.

Increase max_connections in mysql without restarting mysqld service.

By default in mysql database server max_connections is set to 100. This value indicates how many maximum concurrent connections mysql server can handle. If mysql reaches to it maximum (max) limit then you can see errors like "too many connections". I assume that you have enough hardware resources (Mainly RAM )to handle more connections, here with this article I will share a TIP to increase max_connections in mysql.

As we know my.cnf is default configuration file for mysqld service and by default it is located in /etc directory unless and until you have changed it.

How to install and configure AMAND backup server and client on LINUX

Hi all, In this article we will learn how to install amanda backup server and cofigure it to start taking backups. It is completely free and based on GPL License. we don't need to pay any license fee to use this software in live/production environment.

Steps to install amanda backup server.

  1. Install centos 5.2 x86_64.
  2. Get rpm from www.amanda.org/download.php for latest stable version of amanda server. E.g amanda-backup_server-2.6.1p2-1.rhel5.x86_64.rpm
  3. install this downloaded rpm using #rpm –ivh command

PostgreSQL Cheat Sheet

PostgreSQL Cheat Sheet

CREATE DATABASE

CREATE DATABASE dbName;

CREATE TABLE (with auto numbering integer id)

CREATE TABLE tableName (
 id serial PRIMARY KEY,
 name varchar(50) UNIQUE NOT NULL,
 dateCreated timestamp DEFAULT current_timestamp
);

Add a primary key

ALTER TABLE tableName ADD PRIMARY KEY (id);

Create an INDEX

CREATE UNIQUE INDEX indexName ON tableName (columnNames);
Syndicate content

Back to top