The characteristics and merits of MySQL and MongoDB

Introduced:

MongoDB is a database based on distributed file storage. High-performance, open-source, modeless, document-based databases that provide scalable, high-performance data storage for Web applications are among the hottest in the current NoSQL database, written in the C + + language.

MongoDB is a product between a relational database and a non-relational database, and is the most versatile and most like relational database in a non-relational database. The data structure he supports is very loose and is a JSON-like Bson format, so you can store more complex data types. MONGO's biggest feature is that the query language he supports is very powerful, and its syntax is a bit like an object-oriented query language that almost implements most of the functionality of a relational database single-table query, and also supports indexing of data.

Default port: 27017

Characteristics:

High performance, easy to deploy, easy to use, easy to store data. The main features are:

• For collection storage, easy to store data for object types.

• Mode of freedom.

• Supports dynamic queries.

• Supports full indexes, including internal objects.

• Support Queries.

• Supports replication and recovery.

• Use efficient binary data storage, including large objects such as video.

• Automatically process fragmentation to support scalability at the cloud level

• Drivers for Python,php,ruby,java,c,c#,javascript,perl and C + + languages are supported, and drivers for Erlang and. NET platforms are also available in the community.

• The file storage format is Bson (an extension of JSON).

• can be accessed over the network.

Function:

• Collection-oriented storage: suitable for storing objects and data in JSON form.

• Dynamic Query: The MONGO supports rich query expressions. Query directives use a JSON-style tag to easily query objects and arrays embedded in the document.

• Full Index support : Includes embedded objects and arrays in the document. The query optimizer of MONGO parses the query expression and generates an efficient query plan.

• Query monitoring: MONGO contains a monitoring tool for analyzing the performance of database operations.

• replication and automatic failover: The MONGO database supports data replication between servers and supports replication between master-slave mode and server. The primary goal of replication is to provide redundancy and automatic failover.

• Efficient Traditional storage: supports binary data and large objects (such as photos or pictures)

• Auto-sharding to support cloud-scale scalability: Automatic sharding supports a level of database clustering, adding additional machines dynamically.

First, we analyze the characteristics and merits of MySQL and MongoDB.
Here is the part of the PPT I used to do.

The characteristics and merits of MySQL and MongoDB