Database

now browsing by category

 

Upgrade mongoDB 3.0 Shard Servers to 3.2

Fellas, This article is for those, who wants to upgrade their mongoDB servers 3.0 to 3.2. Note:- Before upgrading make sure you have taken backup of your database as well as config db. First test in Dev server then move to QA and Production. You can follow the below steps-Read More

Deploy a Sharded Cluster in MongoDB 3.0

Hello Guys, Welcome back again.. I am writing this article to deploy a shard in MongoDB 3.0, I’m assuming you have basic knowledge of mongodb stand alone & replica set server. Install mongoDB 3.0 in your Linux machine. ( I’m skipping the Installation process, you can also visit mongodb websiteRead More

Copy an Existing Collection to a New Collection

Hello Fellas, After a long time, I am writing an article again, this time I will let you know how to copy an existing collection data to a new collection, you can do this in two way. 1. Copy a collection to new collection in mongo shell First login toRead More

Limitation of MongoDB in 32 bit OS

Fellas, There are many limitations of 32 bit OS, if you want to install MongoDB on that machine. This situation has been faced by many people and later on they realise they need to upgrade their system or use MongoDB in Development/Test Environment only for that machine. Limitation of 32Read More

CRUD Operations in MongoDB

Hello All, After a long time writing this article, many people asked about CRUD operations of MongoDB. CRUD Operations- CRUD Operations stands for Creation, Reading, Update and Deletion of Database. I am giving information regarding how can we create Database, Collection (aka table in RDBMS World), insert data in collection,Read More

Profiling in MongoDB

In this tutorial, I will let you know profiling in MongoDB, why is it so important, and when should we enable profiling. Profiling in MongoDB Profiling in MongoDB plays a big role in query optimization, find the queries which is not using indexing, it help us to identify the slowRead More

Inner Join in MySQL

In this Article, I will let you know about Inner Join in MySQL. Inner Join :- Inner Join also known as Equi Join, Normal Join, it shows the only the result of two or more tables as condition satisfied. Let’s say we have two tables EMPLOYEE and DEPARTMENT Below isRead More

MySql Master Slave Replication Setup

In this article, I will let you know how to set up Master-Slave Replication in MySql. For this you should have two IPs, one for Master server and another one for Slave server. Consider we have the below two IPs for Master & Slave server. 10.10.19.20 – Master Server 10.10.19.22Read More

How To change data type in MongoDB

In this article, I will let you know how to change data type from String to Integer and vice versa. String to Integer data type conversion 1. First check is there any data in string for which you want to convert the data to Integer 64, It’s NumberLong() data typeRead More

Migration of MySql Tables to Cassandra table

In this section, we will let you know how to migrate MySql table to Cassandra table. 1. Create database in MySql. create database mysql_to_cassandra ; 2. Create table in MySql. CREATE TABLE `history` (  `id` varchar(30) DEFAULT NULL,  `city` varchar(30) DEFAULT NULL,  `province` varchar(30) DEFAULT NULL,  `country` varchar(30) DEFAULT NULL, Read More

To Install Specific Version of MongoDB in Ubuntu

To Install specific version of MongoDB, We have to pin particular version of MongoDB. In the section we will update you how to install MongoDB v2.6. 1. Import the public key used by package management system. sudo apt-key adv –keyserver hkp://keyserver.ubuntu.com:80 –recv 7F0CEB10 2. Create a list file for forRead More

Cassandra

Cassandra is a distributed database from Apache that is highly scalable and designed to manage very large amounts of structured data. It provides high availability with no single point of failure. The tutorial starts off with a basic introduction of Cassandra followed by its architecture, installation, and important classes andRead More

Introduction to SQL Server

MicroSoft SQL Server Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on anotherRead More

What is MongoDB

MongoDB is an open-source document database, and leading NoSQL database. MongoDB is written in c++ This tutorial will give you great understanding on MongoDB concepts needed to create and deploy a highly scalable and performance oriented database. Audience This tutorial is designed for Software Professionals who are willing to learnRead More

MySQL Connection

MySQL Connection using mysql binary: You can establish MySQL database using mysql binary at command prompt. Example: Here is a simple example to connect to MySQL server from command prompt: [root@host]# mysql -u root -p Enter password:****** This will give you mysql> command prompt where you will be able toRead More

What is MySQL?

MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications. This tutorial will give you quick start with MySQL and make you comfortable with MySQL programming. MySQL is a freely available open source RelationalRead More