Oracle Vs Opensource DBs
Considering Oracle’s increase in their Li sense cost – the Open source databases like PostgreSQL & MariaDB can be partially replace Oracle in your some of your Applications/Projects. Please check the below comparison in their features. We observed they both are good…
How to do Yahoo! Cloud System Benchmark (YCSB) for Oracle DB
Yahoo! Cloud System Benchmark (YCSB) for Oracle DB :- Sample Reports Description W/T – secs Threads# 10 Threads# 25 Threads# 30 Threads# 50 Update heavy workload (50%R : 50% W) Workload# a 1777…
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/