Shulou(Shulou.com)05/31 Report--

Most people do not understand the knowledge points of this article "what are the differences between mysql and db2", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "what is the difference between mysql and db2" article.

The difference between mysql and db2: 1. Mysql can authorize the batch of objects in the smallest unit, while db2 cannot authorize the batch of objects in the smallest unit; 2. Mysql supports opening the database during recovery, while db2 does not support opening the database during recovery.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

What is the difference between mysql and db2

IBM DB2 is a set of relational database management system developed by IBM Company in the United States. Its main operating environment is UNIX (including IBM's own AIX), Linux, IBM I (formerly known as OS/400), z/OS, and Windows server version. DB2 is mainly used in large-scale application systems, has good scalability, can support from mainframe to single-user environment, and can be applied to all common server operating system platforms.

MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

1. Account management

MySQL account management is similar to Oracle, which is managed by MySQL itself. The account is stored in the user table of MySQL database. Its account is composed of ip address and user name, while DB2 does not have its own user system, and its authentication depends entirely on the account number of the operating system.

2. Privilege management

Mysql can authorize the objects of the smallest unit in batches, while DB2 can not, which is relatively cumbersome.

3. Log management

MySQL database uses log double writing to ensure the integrity and recoverability of data. MySQL transaction log and archive log are two independent objects without any causal relationship. The archived logs of the DB2 database are generated by transaction logs.

4. Lock management

MySQL uses the MVCC model to realize the concurrency control of locks, and DB2 uses the memory model to realize the concurrency control of locks. MySQL is superior to DB2 in concurrency processing, resource conflicts and lock conflicts.

5. The management mode of schema

Strictly speaking, MySQL database does not have the concept of schema, and each schema is equivalent to an independent database. Db2 databases can create multiple schema in one database.

6. The management mode of table space

The support of MySQL database in table space is relatively weak, there are many limitations, and there are weaknesses in striping and space management. DB2 is very perfect in these aspects, easy to manage, powerful, and easy to maintain.

7. Transaction behavior

MySQL rolls back to the last SavePoint, not the entire transaction; DB2 rolls back the entire transaction.

8. Data recovery

MySQL supports opening the database on recovery, which is flexible; DB2 does not support opening the database on restore or roll forward.

9. SQL support

MySQL has weak support for complex SQL, and there may be performance problems at run time; DB2 supports a variety of complex SQL and multiple jion methods.

10. Grammatical differences

MySQL complies with the SQL92 standard, but differs in detail and is case-sensitive by default; DB2 complies with the SQL92 standard and is case-insensitive.

11. High availability and disaster recovery design

MySQL has many solutions in terms of high availability and disaster recovery. MySQL natively supports a variety of architectures and replication schemes to complete the high availability and disaster recovery requirements of the database, such as MHA, PXC and MMM, and is very flexible and can be customized according to business needs and secondary development at almost zero cost. DB2 has only HADR solutions in this area and it is expensive.

12. Scalability

MySQL also has a lot of solutions in clustering, such as Cobar, Atlas, Fabric, Amoeba, TDDL, Mycat, and can be customized or redeveloped, which can be flexibly expanded according to business needs. At present, DB2 has only one solution for PureScale in this respect, and its flexibility is poor.

The above is about the content of this article on "what is the difference between mysql and db2". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.