If you have PostgreSQL running in your environment, managing it from command-line might be bit difficult as you have to remember all the db commands and syntax.

If you are MySQL DBA, you might notice that there is a slight difference in the syntax for few of the commands in PostgreSQL. Also, some of the DBA concepts in PostgreSQL are slightly different than MySQL.

Using phpPgAdmin, you can pretty much do all PostgreSQL DBA activities from a web-based console. You don’t have to worry about remembering PostgreSQL DBA commands or syntax.
[continue reading…]

Redis is an in-memory key-value pair database.

Redis is extremely fast, as the operation happens in the memory. Redis also provides on-disk persistence and built-in replication.

In Redis, you can use these data structures: 1) String 2) Hash 3) List 4) Set 5) Sorted Set.

There is no integer or float data type in Redis. But, you can use string as integer, and there are few String commands that will allow you to manipulate string values are numbers.

In this tutorial, we’ll explain all the following Redis string (and number) commands with examples.
[continue reading…]

When you are using Chef to manage all your servers and network equipments, you should first create cookbooks and appropriate recipes.

On all your remote servers, you’ll use chef-client to execute the recipes from the cookbook.

In this tutorial, we’ll explain how to use knife command to create and manage your Chef cookbooks.
[continue reading…]

If your application is performing lot of deletes and updates on MySQL database, then there is a high possibility that your MySQL data files are fragmented.

This will result in lot of unused space, and also might affect performance.

So, it is highly recommended that you defrag your MySQL tables on an ongoing basis.

This tutorial explains how to optimize MySQL to defrag tables and reclaim unused space.
[continue reading…]

The easy way to manage an Amazon AWS EC2 server is from the AWS management console GUI.

But, if your environment has multiple servers, then it gets bit tedious to manage it from the AWS GUI.

Also, if you are Linux sysadmin, you would prefer to manage your EC2 instances from the command line.

Pretty much anything that you can do from AWS console UI can be done from the command line.
[continue reading…]

If you have Oracle database running on your environment, even if you are a developer or linux sysadmin, you might end-up doing some basic DBA tasks on development instance.

One of the essential DBA task is to manage UNDO on your Oracle database.

Oracle will temporarily store the data manipulation transactions in the UNDO area until those transactions are permanently committed.

This tutorial will explain everything that you need to know to manage UNDO on your Oracle database.
[continue reading…]

When you get your hands on a chromebook, the first thing that you’ll notice is the keyboard looks different.

Chromebook is missing DELETE and CapsLock Key (along with few other keys) that you are used to seeing in a keyboard.

This tutorial explains everything that you need to know about your Chromebook keyboard shortcuts.
[continue reading…]