Prerequisites : ============= Latest version of Oracle Java SE Runtime Environment (JRE) 7. Java Native Access (JNA) is required for production installations (latest version recommended). Python 2.6+ (needed if installing OpsCenter). If you are using an older RHEL-based Linux distribution,…
METHOD 1 : using System; using MongoDB.Bson; using MongoDB.Driver; using MongoDB.Driver.Builders; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { var connectionString = “mongodb://admin:pwd@dbversitydotcom/admin”; MongoClient client = new MongoClient(connectionString); MongoServer server…
Please refer my previous post for the background of the issues with nested documents at Issues-with-Nested-documents However, versions prior to 2.8-rc1 doesn’t handle nested documents properly – neither mongoimport nor mongoexport. But the good news is that both work with nested…
Lifecycle of a Node in Couchbase Server Demystified: Adding & Removing Nodes, Rebalancing & Failover
This blog was originally posted by Cihan Biyikoglu here on November 17th 2014 One of the top attributes of Couchbase Server is its simplicity when it comes to deploying and managing a cluster. Changing the topology of a cluster can be…
There are three ways to do purging in MongoDB. Single collection, delete old entries Collection per day, drop old collections Database per day, drop old databases Option #1: single collection pros ==== Easy to implement Easy to run Map/Reduces cons…
[root@dbversity tmp]# ll -lhtr CSV_* -rw-r–r– 1 oracle dba 298K Nov 26 02:39 CSV_DBV_HLDNGS.csv -rw-r–r– 1 oracle dba 489K Nov 26 02:40 CSV_DBV_DATA.csv -rw-r–r– 1 oracle dba 86K Nov 26 02:40 CSV_PS_RELN_BSNL.csv [root@dbversity tmp]# [root@dbversity tmp]# dos2unix CSV_* dos2unix: converting…
What is Hadoop? Hadoop is a software technology designed for storing and processing large volumes of data using a cluster of commodity servers and commodity storage. Hadoop is an open-source Apache project started in 2005 by engineers at Yahoo. It…
Database and SQL Migration Tools : ========================= This site really worked for me and it can convert a bunch of different DDL commands from Oracle, MySql, MS-SQL Server, Sybase and others. http://www.sqlines.com/online SQLines provides database migration tools: Database Schema (DDL) Conversion…
What is NewSQL : NewSQL is a category of SQL database products that address the performance and scalability issues posed by traditional online transaction processing (OLTP) relational database management systems (RDBMS). Such systems aim to achieve the scalability of NoSQL…