Chunk Size in MongoDB
When the first mongos connects to a set of config servers, it initializes the sharded cluster with a default chunk size of 64 megabytes. This default chunk size works well for most deployments; however, if you notice that automatic…
[MongoDB]: Tag aware sharding
MongoDB supports tagging a range of shard key values to associate that range with a shard or group of shards. Those shards receive all inserts within the tagged range. The balancer obeys tagged range associations, which enables the following deployment…
Setting password for MySQL root ID
Once you’re done with MySQL Installation from http://dbversity.com/mysql-rpm-installation/ You can set password for MySQL root ID as below. MySQL installs with no password protection on root access (blanks) We use this method to set it to Winter06 and GPA will…
MySQL stored procedures
What’s a Stored Function If procedural programming is new to you, you may be wondering what the difference is between a Stored Procedure and a Stored Function. Not too much really. A function always returns a result, and can be…
Hadoop.In Excel.
Explore and analyze Big Data, without IT overhead https://datanitro.com/hadoop_in_excel.html
Apache Hadoop 2 & Apache Hadoop YARN videos
FYI Session Title Watch View Unlocking Hadoop’s Potential Video Enterprise Hadoop for Pools, Ponds, Clouds and Beyond Video Apache Hadoop YARN: Present and Future Video Slides YARN: The Key to Overcoming the Challenges of Broad-based Hadoop Adoption Video Slides One…
Hadoop Cluster set-up document
Running Hadoop on RHEL Linux (Multi-Node Cluster) Here’s we’ll see how to set-up multi-node Apache Hadoop cluster backed by the Hadoop Distributed File System (HDFS), running on RHEL Linux. Hadoop is a framework written in Java for running applications on…
HOW DO WE EXCLUDE SQL FROM REPLICATING IN MYSQL
If you’re using MySQL Replication, in few cases you may require to skip a particular SQL statement from replicating – which is to be executed on Master and should not be on the Slave. Though, its not a good practice!…
MongoDB Installation
Please get the required binaries from the below link and copy to your server. http://docs.mongodb.org/manual/administration/install-on-linux/ If MongoDB installed successfully, you’ll usually see the below Mongo binaries in the dbpath usually */opt/mongodb/bin* folder which will be useful to start the Mongo…
YCSB workloads evaluation for MongoDB as complete In-Memory
Please find the procedure followed to enable the complete In-memory MongoDB set-up. Step1 :- To mount a RAM partition with 4GB mount -t tmpfs tmpfs /mnt -o size=4096m [root@my-host-name bin]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/rootvg-lv_root…