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

Editor to share with you why not use the MySQL database, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

1. The authorization method of MySQL (the best combination with PHP)

MySQL (the best combination with PHP) uses dual license (Dual Licensed), which is the commercial license agreement established by GPL and MySQL (the best combination with PHP) AB.

If you use MySQL (the best combination with PHP) in a free (open source) project that follows GPL, then you can use MySQL (the best combination with PHP) under the GPL protocol. However, if your project is not under the GPL agreement, you have to pay the license fee for using MySQL (the best combination with PHP), or you may change your project to comply with GPL because of this factor, then you need to deal with the resulting more support work, which may lead to higher costs. In this case, some software publishers may prefer to choose other open source data libraries, such as PostgreSQL, which is licensed by BSD.

2. Product maturity

By 2009, Oracle's database Oracle (the large web database platform) had been born for 30 years, while MySQL (the best combination with PHP) did not even have half the time. Microsoft's sql server (the powerful database platform on the WINDOWS platform) is only two years older than MySQL (the best combination with PHP), but the release of sql server (the powerful database platform on the WINDOWS platform) is based on Sybase, when Sybase was six years old. As for other open source databases that deserve attention, PostgreSQL will reach its 20th birthday in 2009. Although MySQL (the best combination with PHP) is not the youngest database on the market, there are more mature databases to choose from.

Of course, this may not be a convincing reason to reject MySQL (the best combination with PHP), but for some old-fashioned IT managers, the maturity of the platform is a factor that must be considered when choosing a platform for some key business, and MySQL (the best combination with PHP) has no advantage at this point.

3. Function setting maturity

It is not easy to make a comprehensive comparison of functional settings between MySQL (the best combination with PHP) and other databases. With the release of a new software version or the introduction of some patches, the list of features that were once available may quickly become obsolete. Also, some features are important for some applications, but not necessarily for others.

Sometimes, some missing functions can be achieved in other ways, for example, before MySQL (the best combination with PHP) 4.1, you can use the join method to replace the subquery function. In MySQL (the best combination with PHP) 5.0, most relational databases already have the required features, but we have reason to doubt the maturity of these features in MySQL (the best combination with PHP) 5.0. At best, they have been supported in MySQL (the best combination with PHP) for about a year, while they have been in other relational databases for nearly 10 years.

4. The role of certification

Although MySQL (the best combination with PHP) also has a certification training program, its training is a far cry from that of Oracle (a large website database platform) or MS-SQL. Although some users of MySQL (the best combination with PHP) say that MySQL (the best combination with PHP) is easy to use, there is no doubt that users with enterprise database needs want their employees to get systematic and in-depth training. Obviously, MySQL (the best combination with PHP) has not done enough on this point.

A related issue is the qualification of third-party support, although support and services directly from vendors can alleviate this problem to some extent, but for some enterprises, through strong localization support is obviously more attractive.

5. Views on extensibility

I put it last for this reason. There is a fairly consistent view among many industry experts: MySQL (the best combination with PHP) does not scale well. There may be great differences on this point, and the focus of the debate is mainly on horizontal scalability and vertical scalability. MySQL (the best combination with PHP) is more likely to scale vertically.

According to my observation, there is a trend that formally trained database administrators DBA prefer to choose a proprietary relational database, such as Oracle (large website database platform). For some larger environments with specialized database administrators, MySQL (the best combination with PHP) is hard to be spoiled, and the debate about whether MySQL (the best combination with PHP) is really good scalability is meaningless.

There is no denying that MySQL (the best combination with PHP) is also a good relational database, perhaps not much different from other leading relational databases in technology or at a disadvantage. However, for some enterprise environments, MySQL (the best combination with PHP) clearly does not have an advantage. So do not blindly follow the crowd, but also according to its functional performance to choose, the selection of MySQL database is not necessarily bad, but in the above five points are not very good, other aspects are worth affirming.

The above is all the contents of the article "Why not use MySQL Database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to 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.