All Stories

Unix history and timeline

http://wwwhttp://www.levenez.com/unix/.levenez.com/unix/

A Sysadmin's Unixersal Translator (ROSETTA STONE)

A helpful guide if you are working on multiple Unix implementation</p> http://bhami.com/rosetta.html</div>

PUPPET on Amazon EC2 (UBUNTU Machines)

PUPPET on Amazon EC2 (UBUNTU Machines) Introduction: Puppet is a system for automating system administration tasks. In the Puppet world, you define a policy (called a manifest) that describes the...

Benchmarking Load Balancers in the Cloud

nice to read article and white paper by right scale on benchmarking Load Balancers in Cloud  </p> http://blog.rightscale.com/2010/04/01/benchmarking-load-balancers-in-the-cloud/

Monitoring Windows Servers Agentlessly - WMI plugin

Tech Down Under: Part 1: Monitoring Windows Servers Agentlessly via...:</p> This how to will show how to install the open source software NAGIOS to monitor network devices such as switches,...

mysql dump of data only - no table and database schema

Mates, I want to dump the data from the tables only rather than its definition and data.</p> The problem with mysqldump is it checks if database/table exist  or not. if...

Mysql Database Backup script

Create a file called database_backup.sh and also an empty directory called mysql_backup. </p> The database_backup.sh script should have the following info : #!/bin/sh date=`date '+%m-%d-%y'` PATH="~/mysql_backup/database_name.$date" mysqldump -u database_username -pdatabase_password...

Backing Up MySQL Database

MySQL database backup can be accomplished in two ways:</p> a) Copying the raw mysql database files &b) Exporting tables to text files Copying the Mysql database Files : MySQL uses...

How to check how much free space we have in Mysql database

fire the query show table status like 'org';</p> The last column Comments gives the size of the database. If you need to have a shell script to check InnoDB_free space...

TRIMMIG IN MYSQL

Some time back I got stuck at the point in Mysql task ,I wanted to trip a part of already existing column in table and then insert into other column.</p>...

basic postgresql tips

Start and stop postgresql </p> Service postgres start Add to the chkconfig Chkconfig –level 3 postgres on to create a first user in kubuntu/ubuntu linux, type the following:~$ sudo su...

Running mysql query from shell script

This is the simple method to run a mysql query from Bash script</p> Query3="select * from ta_lookup where gds = 'wsp' and server like  'reported%';"echo   "$Query3" | mysql --host=tiber12...

Adding user to Mysql

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'somepassword';mysql> flush privileges;</p> or adding a new user to MySQL you just need to add a new entry to user table...

how to find total number of mysql slow queries

$mysqladmin -u $User -p password status  2>/dev/null | awk '{print $9}')

Taking database backup on amazon s3

http://www.timlinden.com/blog/server/backup-mysql-amazon-s3/

Recover/Reset MySQL root Password

Step # 1 : Stop mysql service</p> # /etc/init.d/mysql stopOutput: Stopping MySQL database server: mysqld. Step # 2: Start to MySQL server w/o password: # mysqld_safe --skip-grant-tables &Output: [1] 5988Starting...

What is Usenet News ?

Usenet News is a global electronic bulletin board system in which millions of computer users exchange information on a vast range of topics. The major difference between Usenet News and...

What is Tunneling ?

What is Tunneling ?</p> Tunneling is the most significant component of VPN technology.  Tunneling is the technique of encapsulating an entire data packet in the packet of another protocol format....

What are VLANs ?

What are VLANs ?</p> VLANs are broadcast domains in a Layer 2 network. Each broadcast domain is like a distinct virutal bridge within the switch. Each virtual bridge you create...

What are the advantages & disadvantages of VPN ?

What are the advantages & disadvantages of VPN ?Advantages</p>     * Reduce cost implementation (We don’t need to use lease line/ ISDN/ FR, mobile only need to dial local...