Writing database commands output to a file using Linux `tee` Command.
# mysql -u root -h 127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.8 MemSQL source distribution (compatible; MySQL Enterprise & MySQL Commercial) Copyright (c) 2000, 2011, Oracle…
SQL to MongoDB Mapping Chart
The following table presents the various SQL terminology and concepts and the corresponding MongoDB terminology and concepts. SQL Terms/Concepts MongoDB Terms/Concepts database database table collection row document or BSON document column field index index table joins embedded documents and linking…
How do we copy ‘Yum Repositories Configs’ from one server to another
Imagine, you have java package not available in your SERVER#1 and you know it is available with SERVER#2. Then you can copy the require yum repositories configs from SERVER#2 to SERVER#1 as below and do a yum install. 1) Check…
[MemSQL]: Cluster set-up
Step 1: Install the below required packages on all the servers which you want to make MemSQL Cluster. Required Packages for MemSQL Installation :- —————————————— [root@hostname rpms]# ls -lhtr total 118M -rw-r–r– 1 mongod games 2.8M May 14 06:43 binutils-2.20.51.0.2-5.36.el6.x86_64.rpm…
Hadoop – Single node set-up
< Hadoop – Single node set-up document > 1) Create hadoop group & user [root@myhostname hpadmin]# groupadd hadoop [root@myhostname hpadmin]# [root@myhostname hpadmin]# adduser -g hadoop hadoop OR [root@myhostname hpadmin]# adduser -g hadoop hduser [root@myhostname hpadmin]# 2) Download & Install the…
[Hadoop] HBase Installation
http://www.apache.org/dyn/closer.cgi/hbase/ [root@my-master-host 2]# tar -zxvf hbase-0.98.3-hadoop1-bin.tar.gz [root@my-master-host 2]# ll -lhtr -rw-rw-r– 1 hpadmin hpadmin 64M Jul 14 05:44 hbase-0.98.3-hadoop1-bin.tar.gz drwxr-xr-x 7 root root 4.0K Jul 14 05:48 hbase-0.98.3-hadoop1 [root@my-master-host 2]# [root@my-master-host 2]# [root@my-master-host 2]# [root@my-master-host 2]# cd hbase-0.98.3-hadoop1 [root@my-master-host hbase-0.98.3-hadoop1]#…
MySQL DBA Complete reference book
You can download MySQL DBA complete reference from below link http://dbversity.com/wp-content/uploads/2014/10/MySQL_DBA_Complete_Reference.doc
Database E-Books Online
You can find most of Database related E-Books Online at http://it-ebooks.info/book/2333/
PostgreSQL Installation
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later. PostgreSQL…
Depth of an attribute in Document
Say my document is very huge & have multiple sub-documents & attributes (i.e, dotted notation with long depth) in it. And assume I don’t the schema design of my document, but I want to query on the db to count…