[MySQL]: How do we set-up Replication
How to Set Up Replication: This section describes how to set up complete replication of a MySQL server. There are a number of different methods for setting up replication, and the exact method to use depends on how you…
[MySQL]: HA and Scalability
Replication: Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive updates from the master. Depending…
Node.JS Installation
Installing from binary (pre-built): Download the latest nodejs binary package (it will include npm as well) – http://nodejs.org/download/ curl -O http://nodejs.org/dist/v0.10.24/node-v0.10.24-linux-x64.tar.gz Decompress the package and rename the directory: tar xzf node-v0.10.24-linux-x64.tar.gz mv node-v0.10.24-linux-x64 node Update your PATH to reference the…
[MongoDB] : Basic Troubleshooting
db.runCommand( { replSetGetStatus: 1 } ) – returns all members in replica set + their status.(All members should be either PRIMARY or SECONDARY) db.printSlaveReplicationInfo() – returns sync differences between members of replica set, good values should be under a minute….
[MongoDB] : Importance of Aggregation Framework
I’m representing file system information (folders and files) inside mongoDB as below. > use dbversity switched to db dbversity > > db.dbversity_col.insert({ … … “_id” : “\\\\DBVERSITW06DV\\D$\\DTS\\096-dbversity.db.Database\\dbversity.db.Database.Incident”, … “Size” : 6312131, … “DirectoryName” : “dbversity.db.Database.Incident”, … “Files” : … […
Intro to Spring Data
The spring-data project offer abstraction and unified data access for variety of data sources. Category Sub-project Relational Databases JPA Spring Data JPA – Simplifies the development of creating a JPA-based data access layer JDBC Extensions Support for Oracle RAC, Advanced Queuing,…
[MongoDb]: Developer tools
While mongo shell provides an excellent non-GUI way to interoperate with the data, there are many GUI tools available to view/modify MongoDB data and also to provide support for administrative tasks in a more graphical manner. Best place to…
![[NuoDB]: Overview & Installation](https://dbversity.com/wp-content/uploads/2014/11/clientConnections-150x150.jpg)
[NuoDB]: Overview & Installation
NuoDB is a distributed cloud database management system with a rich SQL implementation and full support for transactions. NuoDB is designed to offer: * Scale-out Performance * Continuous Availability * Geo-Distribution * Multi-Tenancy * No Knobs Administration As a distributed…
[VoltDB] : Overview and Installation
VoltDB is an in-memory operational database Fast flows of real-time data from people, social, mobile, devices and sensors are transforming the business landscape. VoltDB is built to power the next generation of data-intensive applications that rely on fast, smart data….
Uninstallation process of CDH (Cloudera Hadoop packages)
Here’are the uninstallation steps 1. Stop ALL services: a. service cloudera-scm-server stop b. service cloudera-scm-server-db stop c. service cloudera-scm-agent hard_stop 2. Uninstall the CDH and Cloudera Manager packages: [srinivas@dbversity.com ~]# hadoop version Hadoop 2.0.0-cdh4.5.0 Subversion file:///var/lib/jenkins/workspace/CDH4.5.0-Packaging-Hadoop/build/cdh4/hadoop/2.0.0-cdh4.5.0/source/hadoop-common-project/hadoop-common -r 30821ec616ee7a21ee8447949b7c6208a8f1e7d8 Compiled by…