Comparison table of operations between MongoDB and MySQL and comparison table of mongodb

Comparison table of operations between MongoDB and MySQL and comparison table of mongodb

Comparison tables and differences between MongoDB and MySQL

MySQL and MongoDB are both open-source common databases, but MySQL is a traditional relational database, while MongoDB is a non-relational database, also known as document-type database, and a NoSQL database. They have their own advantages. The key is to see where they are used. Therefore, the well-known SQL statements (Structured Query Language) do not apply to MongoDB, because SQL statements are the standard Language of relational databases.



Take our company project as an example. In earlier projects, we were using relational databases, SQL Server, Oracle, and DB2. Later we switched to Mysql for a simple reason: mysql has an open-source advantage when its performance is good. We mainly consider the transaction and high performance of Mysql. Later, because the project will use the user system, that is, there will be a large amount of user data for interaction-massive storage, there will be a bottleneck in the read/write speed of Mysql, as a result, we thought of Nosql, which has developed very strongly recently. With the development of memcache in the early days of Nosql, many non-relational databases, such as redis and mongodb, emerged. After a period of testing, redis and mongodb have obvious advantages over Mysql in reading and writing speed. Mongodb writes about 2.5 million data records per second.

Reference Source:
Comparison tables and differences between MongoDB and MySQL
Http://www.lai18.com/content/422835.html

Mongodb uses the BSON structure (Binary) for storage, which has obvious advantages in massive data storage. The following is a comparison between the operating commands of Mongodb and Mysql.


Note: The syntax for inserting multiple fields in mongodb
> Db. user. insert ({id: 1, name: 'Steve ', sex: 'male'}) is correct

> Db. user. insert ({id: 2}, {name: 'bear '}, {sex: 'female'}) Error

Extended learning

Sort and add a series of articles on MongoDB technical knowledge

 

1 basic knowledge for getting started with MongoDB

2MongoDB getting started tutorial (including installation, Common commands, related concepts, usage skills, and Common Operations)

3 MongoDB getting started

Introduction to common O & M technologies in the 4MongoDB getting started tutorial

C # driver operation instance in 5MongoDB getting started tutorial

Step 6 MongoDB master-slave replication Configuration

Introduction to aggregation and cursor operations in the 7MongoDB getting started tutorial

An Introduction to MongoDB database addition, deletion, query, modification, and so on

9 MongoDB getting started tutorial-index Operation Analysis

10MongoDB getting started tutorial-MongoDB database installation diagram in Windows

11MongoDB connection timeout caused by no index created in the query field case study

12. Solution to excessive MongoDB log files

Differences between Community edition and Enterprise Edition of 13MongoDB

14 mongoDB Chinese community sponsors will show you how to learn mongoDB

15 Analysis on MongoDB database performance bottlenecks

16 MongoDB paging query methods and Performance

Cluster architecture Implementation of 17MongoDB shard Storage

18Mongodb batch Delete gridfs file instances

19Mongodb add and remove Shard Server instances

Add and remove Arbiter node instances in apsaradb for MongoDB

Tutorial on installing and configuring MongoDB in 21CentOS

22MongoDB modifies or deletes a file's domain attribute instance

MongoDB basic operations in 23Python: connecting to and querying instances

Example of exporting query results to files in 24MongoDB

Notes for creating indexes in MongoDB

Some pitfalls in 26MongoDB (not recommended)

27. Add a user permission to MongoDB

Simple installation and basic operations of MongoDB in 28Linux

Basic management commands for the 29MongoDB tutorial

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

Index introduction in 31 MongoDB tutorial

Data operation instance in the 32MongoDB tutorial

33MongoDB Basics

Query operation instances in the 34MongoDB tutorial

35 MongoDB series tutorial (4): Set User Access Permissions

36MongoDB series tutorial (8): GridFS storage details

37MongoDB features and advantages

38MongoDB introduction five features

39MongoDB series tutorial (6): java operations on mongodb instances

40MongoDB series tutorial (7): Detailed description of MongoDb Data Structure

41MongoDB series tutorial (5): Comparison of mongo syntax and mysql syntax

42MongoDB series tutorial (II): MongoDB Introduction

43MongoDB series tutorial (1): NoSQL Origin

Introduction to MapReduce in 44MongoDB

45 MongoDB series tutorial (3): download and install MongoDB in Windows

46. MongoDB backup methods

47 summary of common MongoDB commands

48MongoDB and MySQL operations comparison table and differences

49MongoDB security configuration details

Introduction and use of bson in 50MongoDB

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.