Install s3cmd/s3tools Debian/Ubuntu

1. Register for Amazon AWS (yes, it asks for credit card)

2. Install s3cmd (following commands are for debian/ubuntu, but you can find how-to for other Linux distributions on

3. Get your key and secret key at this link

4. Configure s3cmd to work with your account

5. Make a bucket (must be an original name, s3cmd will tell you if it’s already used)

Hbase Query Table List

Query Table List


Retrieves the list of available tables. Set Accept header to text/plain for plain text output. Set Accept header to text/xml for XML reply. Set Accept header to application/json for JSON reply. Set Accept header to application/x-protobuf for protobufs. If not successful, returns appropriate HTTP error status code. If successful, returns the table list in the requested encoding.

Examples: (I use a REST server on port 59999)

Installing MySQL 5.5.12 on Ubuntu 10.04 (Lucid)

Here we have a step by step tutorial for installing MySQL 5.5.12 on a machine with a fresh install of Ubuntu 10.04 (lucid).

I could not find a tutorial and we needed MySQL 5.5 over MySQL 5.1 for one of our development farms.

Let’s start:

Get MySQL 5.5.12

Change directory into mysql-5.5.12 and make && make install

Chown/Chgrp and copy files

Start the services and create MySQL users

Task: MySQL list databases MySQL is a simple command-line tool. MySQL is command line and it is very easy to use. Invoke it from the prompt of your command interpreter as follows:


You may need to provide mysql username, password and hostname, use:

To list database type the following command

information_schema and mysql are name of databases. To use these database and to list available tables type the following two commands:
mysql> use mysql;Output:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Now list tables:

Hbase Shell

To run the shell,

You’ll be presented with a prompt like the following:

Type ‘help’ followed by a return to get a listing of commands.


General Notes

GENERAL NOTES: Quote all names in the hbase shell such as table and column names. Don’t forget commas delimit command parameters. Type <RETURN> after entering a command to run it. Dictionaries of configuration used in the creation and alteration of tables are ruby Hashes. They look like this:

{‘key1’ => ‘value1’, ‘key2’ => ‘value2’, …}