MySQL backups with mysqlhotcopy

March 18th, 2012

MySQLPreviously I have written about MySQL backups using mysqldump. But there is another way to backup MySQL databases and that is by using a perl script included with MySQL called mysqlhotcopy. Things to note about mysqlhotcopy are:

Read more »»

Memory usage of a process under Linux

February 29th, 2012

Linux command line programFinding out the memory usage of a process under Linux can be a bit confusing. That is because Linux doesn’t have one number for a process’ memory usage.

Read more »»

Installing MaraDNS on CentOS Linux

February 6th, 2012

Linux command line programMaraDNS is a lightweight alternative opensource DNS server for Linux. MaraDNS has some really interesting characteristics:

  • Low memory usage – On an OpenVZ VPS ( no vswap ) MaraDNS uses about 5MB of RAM as opposed to 90-100MB for the venerable BIND.
  • Separation of recursive nameserver and authoritative nameserver – If you only need an authoritative nameserver for your domain names you can skip starting up the recursive nameserver service.
  • Ease of installation – MaraDNS is easier to install than other alternative nameservers like tinydns.
  • Excellent documentation – The documentation on the MaraDNS site is quite good at explaining things in simple language.

So let’s take a look at how we can get started with MaraDNS on CentOS Linux.

Read more »»

Finding out disk space usage using Linux shell

January 28th, 2012

Linux command line program

Finding out your disk space usage using the shell or command line in Linux is easy once you know how. This article takes a look at the different commands that tell you your disk space usage at different levels of the file system i.e. from entire disk volumes/partitions all the way down to individual files and directories.

Read more »»

Backup and restore MySQL databases

December 20th, 2011

MySQLMySQL comes with a utility called mysqldump that allows you to take a backup of your MySQL database. It generates a text file containing SQL statements that you can use to recreate your database on any MySQL server.

Read more »»