当前位置：网站首页>Understand the differences between mongodb and MySQL

Understand the differences between mongodb and MySQL

2022-07-21 19:33:00 【Hai Yong*】

Give you Amway a free and practical front-end brush question （ Daquan of facial scriptures ） Website , Click to jump to the website .

Let's talk about MongoDB and MySQL Differences in various parameters ：

What is? MongoDB and MySQL？

MongoDBMySQL
MongoDB By MongoDB, Inc. Open source database developed .MongoDB Store data in something like JSON In the document , The structure of these documents may vary . It's a popular NoSQL database .MySQL Is a popular open source relational database management system (RDBMS), from Oracle Corporation Development 、 Distribution and support .

How to store data ？

MongoDBMySQL
stay MongoDB in , Each individual record is stored as ’documents’. stay MySQL in , Each individual record is stored as “ That's ok ”.

The upper limit of the recorded level

MongoDBMySQL
Documents belonging to a specific class or group , Stored in “ aggregate ” in . Example ： User set .“ surface ” Used to store rows of similar types （ Record ）.

SQL or NoSQL

MongoDBMySQL
MongoDB It's called NoSQL database . This means that predefined structures of incoming data can be defined and adhered to , and , if necessary , Different documents in the collection can have different structures . It has a dynamic mode . seeing the name of a thing one thinks of its function ,MySQL Using structured query language (SQL) Database access . The schema cannot be changed . Only input after a given mode .

Example ： In a table , If there is a name 、 Address column , And you need to enter “ Age ”, It will not be used , Because the column is not defined in the schema .

This can be done in MongoDB To realize , Any new field can be inserted regardless of the schema , Therefore, it is known to have dynamic patterns .

Significant features

MongoDBMySQL
MongoDB High availability and scalability are considered in the design , And includes out of the box copying and slicing .MySQL The concept does not allow effective replication and fragmentation , But in MySQL in , You can use connections to access relevant data , So as to minimize repetition .

Terminology differences

MongoDB and MySQL There are differences based on terminology .

Insert picture description here

The data shows

There are great differences between the representation and storage of data in the two databases .
MongoDB By category JSON Data is stored in the form of a document , and MySQL Store data in the form of table rows , As mentioned earlier .

Example ： Show how to be in MongoDB and MySQL Store and represent data in .

Insert picture description here

️ Good books recommend

Insert picture description here
【 Content abstract 】

  • The first 1 Chapter MySQL Database foundation
  • The first 2 Chapter Detailed explanation InnoDB Storage engine
  • The first 3 Chapter MySQL User management and access control
  • The first 4 Chapter management MySQL Database objects for
  • The first 5 Chapter MySQL Application development
  • The first 6 Chapter MySQL Transaction and lock of
  • The first 7 Chapter MySQL Backup and recovery
  • The first 8 Chapter MySQL Master slave replication and master master master replication
  • The first 9 Chapter MySQL High availability architecture
  • The first 10 Chapter MySQL Performance optimization and operation and maintenance management
  • The first 11 Chapter MySQL Database monitoring
  • The first 12 Chapter Use MySQL Database middleware

JD self purchase link ： 《MySQL Database advanced actual combat 》- Jingdong books

原网站

版权声明
本文为[Hai Yong*]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/202/202207210127561036.html

边栏推荐

猜你喜欢

随机推荐