MongoDB and MySQL operation comparison table and the difference introduction

MongoDB and MySQL operation comparison table and the difference introduction

MySQL and MongoDB are common open source databases, but MySQL is a traditional relational database, MongoDB is a non-relational database, also known as a document database, is a NoSQL database. They each have their own merits, the key is to see where to use. So the SQL (full name structured Query Language) statements that we know are not applicable to MongoDB, because SQL statements are the standard language for relational databases.



Take our company project for example, in the early project, all in the use of relational database, used SQLSERVER,ORACLE,DB2, and then all turned to MySQL, the reason is very simple: MySQL in the performance of a good situation, has the advantage of open source. MySQL's transactional and high-performance is our main consideration. Later, because the project to use the user system, there will be a large number of user data to interact-mass storage, MySQL read and write speed will have a little bottleneck, so we think of the recent development of a very strong nosql. In the early memcache of NoSQL, there are many non-relational databases, such as Redis,mongodb. After a period of testing, Redis and MongoDB read and write faster than MySQL has a clear advantage. The write speed of MongoDB is about 2.5w/times per second.

Reference Source:
MongoDB and MySQL operation comparison table and the difference introduction
Http://www.lai18.com/content/422835.html

MongoDB is stored in the Bson structure (binary), which has obvious advantages for mass data storage. Here is a comparison of the operation commands between MongoDB and MySQL.


Especially note: MongoDB Inserts multiple field syntax
> Db.user.insert ({id:1,name: ' Steve ', Sex: ' Male '}) correct

> Db.user.insert ({id:2},{name: ' Bear '},{sex: ' Female '}) error 

Extended Learning

"MongoDB Technical Knowledge" series of technical Articles organized collection

Basics to get started with 1mongoDB

2MongoDB Getting Started Tutorials (includes installation, common commands, related concepts, tips, common actions, etc.)

3MongoDB Getting Started Tutorial Shard Technology detailed

4MongoDB Introductory tutorials Common operations and Maintenance technology introduction

Example of C # driver operation in 5MongoDB Starter Tutorial

6MongoDB Introductory Tutorial Master-slave replication configuration detailed

Introduction to the aggregation and cursor operations of the 7MongoDB Getting Started tutorial

8MongoDB Getting Started teaching the operation of adding and deleting MongoDB database

An analysis of index operation of 9MongoDB Getting Started tutorial

10MongoDB Getting Started tutorial of the MongoDB database installation diagram under Windows

11MongoDB query field does not create an index caused by Connection Timeout exception solution case sharing

12MongoDB log file is too large a workaround

13MongoDB Community Edition and Enterprise Edition difference comparison table

14MongoDB Chinese Community Initiator takes you to learn MongoDB.

Analysis on performance bottleneck of 15 MongoDB database

The method and performance of 16MongoDB paging query

Cluster architecture implementation of 17MongoDB Shard storage

18Mongodb Bulk deletion of Gridfs file instances

19Mongodb adding, removing Shard server instances

20Mongodb adding, removing Arbiter node instances

MongoDB Installation and configuration tutorial under 21CentOS system

22MongoDB Modifying and deleting a document's Domain property instance

MongoDB basic operations in 23Python: connecting, querying instances

24MongoDB Export Query Results to file example

Things to keep in mind when creating indexes in 25MongoDB

Some pits in 26MongoDB (best not to use)

27 adding user rights to MongoDB sharing method

Simple installation and basic operation of MongoDB under 28Linux system

Basic management commands for the 29MongoDB tutorial

Aggregation of 30MongoDB Tutorials (count, distinct, and group)

Introduction to the index of 31MongoDB tutorials

Data manipulation examples of 32MongoDB tutorials

Basics of getting Started with 33MongoDB tutorials

Examples of query operations for 34MongoDB tutorials

35MongoDB Series Tutorial (iv): Set User access rights

36MongoDB Series Tutorial (eight): Gridfs storage

Introduction to features and advantages of 37MongoDB database

38MongoDB about MongoDB Five features

39MongoDB Series Tutorial (vi): Java operation MongoDB Instance

40MongoDB Series Tutorial (vii): A detailed description of the MONGODB data structure

41MongoDB Series Tutorial (v): MONGO Grammar and MySQL syntax comparison learning

42MongoDB Series Tutorial (ii): About MongoDB

43MongoDB Series Tutorial (i): NoSQL origins

Introduction to MapReduce in 44MongoDB

45MongoDB Series Tutorial (iii): Download and install MongoDB in Windows

46 on how to back up MongoDB

47MongoDB Common Command Summary

48MongoDB and MySQL operation comparison table and the difference introduction

49MongoDB Security Configuration Detailed

Bson Introduction and usage examples in 50MongoDB

MongoDB and MySQL operation comparison table and the difference introduction