MongoDB vs MySQL

MongoDB

1. Defination

• MongoDB is an opensource database developed by MongoDB. It stores data in JSON like documents that can vary in structure. It is a popular NoSQL database.

2. How data is stored?

• Each individual records are stored as documents.

3. Hierarchial Upper of a Record.

• Documents belonging to a particular class or groups are stored in collection. Eg:- Collection of users.

4. SQL or NoSQL

• MongoDB is called a NoSQL database. This means that pre-defined structure for the incoming data can be defined and adhered to but also, if required different documents in a collection can have different structures. It has a dynamic schema.

5. Salient features

• MongoDB was designed with high availability and reliability in mind and includes out-of-the-box replication and sharding.

MySQL

1. Defination

• MySQL is a popular open-source relational database management (RDBMS) that is developed, distributed and supported by Oracle Corporation.

2. How data is Stored?

• Each individual records are stored as "rows" in a table.

3. Hierarchial upper of a Record

• A table is used to store row (records) of similar type.

4. SQL or NoSQL

• MySQL as the name suggests is the Structured Query Language (SQL) for database access. The schema cannot be changed. The inputs following the given schema are only entered.

5. Salient Features

• My SQL does not allow efficient replication and sharding but in MySQL one can access associated data using joins which minimises duplication.