Five reasons not to use MySQL database

Source: Internet
Author: User
Tags sql server sql mysql postgresql sybase mysql database

First of all we need to know that there may be a number of reasons why we can choose to use it, but let us not use it often as long as there is a reason is enough. The same is true for choosing a software PRODUCT. MySQL Database Although the application is very broad, by everyone's favor, but the MySQL database also has a negative effect, the following introduction to the five is not applicable to the MySQL database of the reasons.

1, MySQL (and the best combination of PHP) licensing method

MySQL (the best combination of PHP) uses dual licensing (Dual licensed), which is a commercial license agreement between the GPL and MySQL (the best combination of PHP) ab.

If you use MySQL (the best combination of PHP) with a GPL free (open source) project, you can use MySQL (the best combination of PHP) with the GPL protocol. However, if your project is not under the GPL, you must pay the license fee for the use of MySQL (the best combination of PHP), or you may change your project to the GPL for this reason, then you need to deal with the additional support work that it brings. This has the potential to lead to cost improvements. In this case, some software publishers may prefer to choose other Open-source databases, such as following BSD-mandated PostgreSQL.

2. Maturity of product

By 2009, Oracle's database Oracle (a large Web site database platform) had been born 30 years ago, and MySQL (the best combination of PHP) did not even have half of its time. Microsoft's SQL Server (a powerful database platform on the Windows platform) is only two years older than MySQL (the best combination of PHP), but the release of SQL Server, a powerful database platform on the Windows platform, is based on Sybase, At that time Sybase had been born for 6 years. As for other Open-source databases that are noteworthy, PostgreSQL will reach the 20 birthday in 2009. While MySQL (the best combination of PHP) is not the youngest database on the market, there are more mature databases available for us to choose from.

Of course, that's probably not a compelling reason to reject MySQL (the best combination of PHP) but for some of the more conservative IT managers, the maturity of the platform is a factor to consider when choosing a platform for some key business, at which point MySQL ( The best combination with PHP is undoubtedly of no advantage.

3, the function set up the mature sex

It's not easy to compare the MySQL (and PHP best combination) with the other databases for an exhaustive set of features. With the release of a new version of the software or the introduction of some patches, the once functional list may quickly become obsolete. Also, some features are important for some applications, but not necessarily for other applications.

Sometimes, some missing features can be implemented in other ways, for example, before the MySQL (and the best combination of PHP) 4.1, you can use the Join method to replace the function of the subquery. In MySQL (the best combination of PHP) 5.0, most relational databases require functionality, but we have reason to doubt the maturity of these features in MySQL (and the best combination of PHP) 5.0. At best, they are supported in MySQL (the best combination of PHP) for a year or so, while in other relational databases they have been around for almost 10 years.

4, the role of certification

Although MySQL (the best combination of PHP) also has a certified training program, it is far less likely to be trained than Oracle (a large Web site database platform) or Ms-sql. Although some users who use MySQL (and the best combination of PHP) say that MySQL (the best combination of PHP) is easy to get started with, but for users with enterprise-class database requirements, there is no doubt that the staff will receive systematic, in-depth training, obviously MySQL ( The best combination with PHP) is not enough at this point.

A related issue is qualifying for third-party support, although it can be mitigated to some extent by direct vendor support and services, but it is clearly more attractive for some companies through strong localized support.

5. Views on scalability

I put it in the last one for this reason. There is a fairly consistent view among many industry experts that MySQL (the best combination of PHP) does not extend well. There may be considerable disagreement about this, and the focus of the debate is on horizontal scalability and vertical extensibility. MySQL (the best combination of PHP) is more inclined to vertical scalability.

As far as I can see, there is a tendency for the officially trained database administrator DBA to choose a proprietary relational database, such as Oracle (a large Web site database platform). For some of the larger environments with specialized database administrators, MySQL (the best combination of PHP) is difficult to dote on, and there is no point in arguing whether MySQL (and the best combination of PHP) really has a good scalability.

Admittedly, MySQL (and the best combination of PHP) is also a good relational database, perhaps technically it is not the same as other leading relational databases, or not a disadvantage. However, for some enterprise environments, MySQL (the best combination of PHP) obviously does not have an advantage. So do not blindly follow the flow, but also according to its functional performance to choose the choice of MySQL database is not to say that must not be bad, but in the above five points to do is not very good, other aspects are still worth affirming.

"Edit Recommendation"



Related Article

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.