Database Adminstration

This page is dedicated to most required knowledge for DBA nowadays. 
Refer: http://www.blogfordba.org/ by Mukesh Kumar Modi

Topics:

1. Profiling in MongoDB

2. CRUD Operations in MongoDB

3. Inner Join in MySQL

4. MySql Master Slave Replication Setup

5. How To change data type in MongoDB

6. Migration of MySql Tables to Cassandra table

7. Install Specific Version of MongoDB in Ubuntu

8. MySQL Connection

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 Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use. MySQL is an essential part of almost every open source PHP application. Good examples for PHP/MySQL-based scripts.

One of the most important things about using MySQL is to have a MySQL specialized host.

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 learn MongoDB Database in simple and easy steps. This tutorial will give you great understanding on MongoDB concepts and after completing this tutorial you will be at intermediate level of expertise from where you can take yourself at higher level of expertise.

Prerequisites

Before proceeding with this tutorial you should have a basic understanding of database, text editor and execution of programs etc. Because we are going to develop high performance database, so it will be good if you have understanding on basic concepts of Database (RDBMS).

Oracle Database Architecture

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

PostgreSQL

The PostgreSQL Global Development Group is pleased to announce the availability of PostgreSQL 9.6 Beta 1, the first beta release of the upcoming 9.6 version of PostgreSQL.

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 and interfaces. Thereafter, it proceeds to cover how to perform operations such as create, alter, update, and delete on keyspaces, tables, and indexes using CQLSH as well as Java API. The tutorial also has dedicated chapters to explain the data types and collections available in CQL and how to make use of user-defined data types.

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 MongoDB in 32 bit OS

Limitation of 32 bit OS for MongoDB installation

1. Max Database size can be of ~2 GB.

2. Your data will be in inconsistent state, if your database crash untimely. Since, By Default Journal is disabled in MMAP Storage engine with 32 bit OS, so that you will have enough space to store your database. If you enable Journal, it will take ~1 GB of size and data directory of your database will have ~1 GB of size only, which will be another limit of database size.

Though now all the systems are coming with 64 bit OS, so you won’t have problem like this.

But if you have 32 bit OS, then use MongoDB in that machine for Development/Testing purpose only.