Five reasons for not using MYSQL database analysis _mysql

In our actual work, we tend to hear a lot about the reasons not to use MySQL database, of course, there are some of the MySQL (and the best combination of PHP) misunderstanding, I will talk about the 5 do not use MySQL (and PHP with the best combination) of loud reasons.

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 DatabaseAlthough 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.