Two-handed mutual bo, whether the choice of MySQL five pros and cons

Open source database MySQL has developed to today has a very broad user base, some say it has a strong challenge to the traditional business database, and some say it has yet to prove itself in the corporate environment, and this article lists the five reasons why MySQL is worth our choice in both ways.

One, MySQL is worth our choice of the five major reasons

The most difficult part of enumerating the reasons for choosing MySQL is how to sort these reasons. It's like the story we often argue: chicken first or egg?

Does MySQL's low cost come from its simplicity? Is its popularity due to its low cost? In fact, there is no obvious dividing line between the most "good" and "bad" features in MySQL, but they are grouped together to form a piece of work that we enjoy.

In any case, the market results have proven to be a cost-effective, flexible, widely used and well supported feature of MySQL. Here's a list of five top reasons MySQL deserves your choice.

1, the popularity of

People often say, "Success breeds success", this statement is obviously very suitable for MySQL situation. This Open-source database boasts more than 1.1 million complete installations worldwide. MySQL has gained 25% per cent of its market share in the past two years, according to a recent survey by the authoritative investigative agency, Evans Data Corp. The survey company also predicts that more and more developers will continue to choose MySQL compared to other open-source databases and closed-source databases. Evans's president, John Andrews, says users ' evaluations of MySQL and other Open-source databases are catching up with even more proprietary business database software.

Because the MySQL database has been so popular, it is undoubtedly a better choice for the enterprise.

The industry's popular voice says: "MySQL is a reliable database system, whether in the deployment of embedded or large cluster systems, or in web-based applications, users often find themselves not the first to choose a MySQL database pioneer." ”

Another benefit of MySQL's popularity in the industry is that people can easily find solutions to the industry. Vendors want their development tools and application frameworks to be compatible with MySQL databases because everyone is using it. MySQL is a standard component of the Open source lamp portfolio: Linux, Apache, MySQL, and perl/php. According to Evans, the rapid spread of the lamp portfolio largely represents the widespread acceptance of MySQL. "The use of MySQL will continue to grow in the future," according to Evans's survey. ”

2. Simple Nature

MySQL is easy to learn and easy to use compared to other databases.

You don't have to spend a lot of time and money training existing workers, or you can pay a large price to hire developers with a variety of certificates. Because MySQL's maintenance and management is largely "dummy", this leads directly to savings in human costs, says Mitch Pirtle, the CEO of MySQL's SpaceMonkey lab, who said: " Maintaining MySQL allows you to not need a 150,000-dollar DBA, and using it to develop programs is also very simple. ”

"There are plenty of powerful tools to choose from for MySQL databases, both in terms of development and support." Each novice developer can easily use the MySQL database for development. Even an experienced Windows administrator can easily deploy and start learning it, and you don't have to invest a penny to understand the database.

For IT managers, the simplicity of MySQL that they prefer is another. MySQL can run faster. Some people may say that MySQL lacks some of the features that people want, but the MySQL supporters believe that MySQL retains the essence of functionality and is essential for you to deploy, configure, and maintain the database.

"With a simple plan of a capable DBA, MySQL can run at an unimaginable speed," says one senior DBA. There is no extra functionality in MySQL to slow down the CPU or occupy memory. If you need additional functionality, the popularity of MySQL can actually make you realize that there is always a factory chamber that delivers accurate solutions that meet your needs and needs.