Determine whether to select MySQL for positive and negative reasons (1)

MySQL, an open-source database, has developed into a very broad user base today. Some people say that it has posed a powerful challenge to traditional commercial databases. Some people say that, it has yet to prove itself in the enterprise environment. This article lists the five reasons for MySQL to be worth choosing from.

I. five reasons why MySQL is worth choosing

The most difficult part of listing the reasons for choosing MySQL is how to sort these reasons. This is like a story we often argue about: first chicken or first egg?

Does the cost of MySQL come from its simplicity? Is its popularity low-cost? In fact, there is no obvious line between MySQL's "good" and "bad" functions, but they are combined to form a pair of works that we can enjoy.

However, market results have proved that MySQL is cost-effective, flexible, widely used, and well-supported. Next, let's list the five top reasons MySQL deserves your choice.

1. Popularity

It is often said that "Success is successful", which is obviously very suitable for MySQL. This open-source database is claimed to have been fully installed in more than 1.1 million copies worldwide. According to a recent survey conducted by the authoritative research firm Evans Data, MySQL has gained 25% market share in the past two years. The company also predicted that more and more developers will continue to choose MySQL compared with other open-source databases and closed-source databases. John Andrews, president of Evans, said that users' comments on MySQL and other open-source databases are catching up with or even surpassing many proprietary commercial database software.

As MySQL Databases have become so popular, it is undoubtedly a better choice for enterprises.

It is widely recognized that MySQL is a reliable database system, whether in the deployment of embedded or large cluster systems or in the Web-based application field, users often find that they are not the first pioneers to choose MySQL databases."

Another benefit of MySQL's popularity in the industry is that people can easily discover solutions in the industry. Vendors want their development tools and application frameworks to be compatible with MySQL Databases because everyone is using them. MySQL is a standard component of the open-source LAMP combination: Linux, Apache, MySQL, and Perl/PHP. According to Evans's survey, the rapid promotion of LAMP combination largely represents the widespread acceptance of MySQL. According to the Evans survey, "MySQL usage will continue to grow in the future ."

2. Simplicity

Compared with other databases, MySQL is easier to learn and use.

You don't have to spend a lot of time and money to train existing employees or hire developers with various certificates at a high price. Because the maintenance and management of MySQL is largely "silly", this directly leads to labor cost savings. Mitch Pirtle, CEO of the Spacemonkey lab of MySQL users, said: "Maintaining MySQL removes the need for a DBA with an annual salary of $0.15 million, and it is very easy to use it to develop programs."

"For MySQL databases, both in terms of development and support, there are now a lot of powerful tools to choose from. Every novice developer can easily use the MySQL database for development. Even an experienced Windows Manager can easily deploy and start learning it, without having to invest a penny to understand the database.

For IT managers, the simplicity of MySQL they like is another aspect. MySQL can run faster. Some may say that MySQL lacks some functions that people want, but MySQL supporters believe that all functions reserved by MySQL are the essence, it is also essential for you to deploy, configure, and maintain this database.

"Through a simple plan of competent DBAs, MySQL can achieve unimaginable operation speeds," said one senior DBA. MySQL does not have any redundant functions to drag down the CPU or occupy memory. If you need additional features, the popularity of MySQL actually allows you to find that there is always a factory to provide accurate solutions, and this solution will meet your needs and needs.

3. Low Cost

MySQL database belongs to MySQL AB, but this software is open-source, and a Community version can be downloaded for free. New users with a little knowledge can easily install and configure MySQL on a common hardware. MySQL has a low requirement on hardware, which is one of its biggest advantages. However, the more memory, the better, because all important data is stored in the memory. A free database means that more valuable funds can be used to start other businesses, such as marketing, advertising, research, and development.

Even for the Commercial Enterprise Edition of MySQL, there is no high license cost. When you compare it with large proprietary commercial databases such as Oracle and Microsoft, you will find that MySQL can actually use less money. The former's CPU license fee generally ranges from $4000 to $25000, while the MySQL Enterprise Edition's support and maintenance costs are lower, it only costs 2000 to 5000 USD per year. Whether you create an emerging company from your own pockets or get sponsorship from venture capitalists, using MySQL can reduce your labor costs. As mentioned above, mySQL is easy to learn, easy to deploy, easy to manage, and easy to maintain.

You can easily port existing services to MySQL. When you need to replace old hardware, and you need to cut down old systems left behind by history, choosing MySQL is more attractive for the finance department. MySQL is deployed quickly, so the migration process will not cause production interruption. In addition, a short learning curve allows your system administrator to quickly master its operation and maintenance. Moreover, the ease of MySQL maintenance and management means that the current staff can handle the current work.

4. Good support

MySQL's dual-license model means that those who wish to have additional control over the database can get help directly from the database vendor. MySQL AB provides support and maintenance services, such as code update and patch repair services. The annual renewal fee is about $3000. By paying a certain amount of fee, the customer can get a top 24/7 support, access the rich online knowledge base and contact a dedicated technical manager.

It also provides adequate support services for users in the free version. On dev.mysql.com, a large and powerful community user and developer can discuss all things about MySQL. This site has blogs, guides, videos, technical exchanges, white papers and forums. Your questions may have been asked by someone else in the Community. Even if you don't have any questions, you can ask questions or search for answers through Google. "The MySQL Community is active, friendly, and informative ."