Skip to Content

What Is MySQL? And Why Is It Still the Most Popular Database?

What Is MySQL

What Is MySQL? And Why Is It Still the Most Popular Database?

Whether you’re running an online store, managing a product landing page, or setting up a personal blog, you need a database to store and manage the data that powers your applications on the web. For many businesses and personal users, MySQL is among the first database services you’ll encounter, often as a one-click install in popular web builders like WordPress. But what exactly is MySQL and how does it work? In this article, we’ll answer these and other questions as we investigate the most popular database on the web.

What Is MySQL?

MySQL, often pronounced “my sequel,” is an open source relational database management system (RDBMS) that uses a client-server model. It isn’t a programming language. Instead, it’s the most commonly used database management system. It’s called MySQL because its co-founder Michael Widenius often names projects after his children. MySQL is named after his daughter My. SQL stands for Structured Query Language and is the language of choice for sending queries to relational databases.

How Does MySQL Work?

In the simplest terms, a MySQL database works via the client-server model in which a client (device) connects and submits queries to a server which returns with a response. Today, this is typically done within a graphical user interface (GUI) on the client side, and there are many popular GUIs to choose from such as MySQL Workbench, Sequel Pro, and dbForge Studio. When selecting a GUI to work with MySQL, the lighter and more user-friendly it is, the more efficient your data management processes will be.

How Much Does MySQL Cost?

MySQL is free and open source software. As long as you’re using MySQL together with a web server (even a commercial web server), it’s free to use. The only time it will begin to incur a cost is if you intend to sell a modified version of MySQL. You also have the option to purchase MySQL Enterprise Edition.

Is MySQL Still Open Source?

MySQL is still open source software under the GNU General Public Licence (GPL). This licence states that “Everyone is permitted to copy and distribute verbatim copies of this licence document, but changing it is not allowed.”

MySQL is supported by large online communities of open source developers. Furthermore, the GNU General Public Licence Preamble states that they’re committed to openness.

Does Oracle Own MySQL?

Yes. Oracle owns MySQL. In 2008, Sun Microsystems purchased MySQL for $1 billion. Two years later, Oracle purchased Sun Microsystems for $7.4 billion. Through this acquisition, Oracle acquired MySQL. 

Many people feared that Oracle would shut down MySQL, which was supporting thousands of businesses and websites. Contrary to what many believed, Oracle has proven to be very effective in managing the open source properties that it has acquired over the years. Oracle didn’t turn MySQL into freemium software to push sales of the Enterprise Edition either.

MySQL Market Share: How Popular Is MySQL?

As of 2021, MySQL has a market share of 46.83% in the relational-database space, with more than 140,000 current customers. While MySQL may have fewer features than its main competitors, it doubles down on efficiency of implementation for features that the majority of people need, including:

  • Dual Passwords - providing an easy way to update passwords
  • Data Dictionary -  metadata is stored in a data dictionary, freeing up inodes
  • JSON Document Validation - rejects bad JSON data

There was a concern that MySQL would become far less popular after it was acquired by Oracle. However, even after being acquired, the software still functioned in much the same way it had. It even retained core features, which, at the time, set it apart from larger competitors and has allowed it to maintain its market share to this day.

Three Advantages of MySQL:

MySQL has three main advantages to improve the reliability, versatility, and performance of your organisation’s data infrastructure.

  • 24x7 uptime: Many businesses use MySQL because they have numerous high-availability solutions. One of the main advantages of using MySQL is that your data has the protective benefits of specialized cluster servers and regular backups to separate nodes or data centers.
  • Multi-platform projects: MySQL was designed as a cross-platform database server, so it runs on Linux, macOS, and Windows. If you’ve got multi-platform projects, MySQL is for you.
  • Flawless performance: If your website is getting millions of daily queries, MySQL’s ability to ensure optimum speeds for even the most demanding tasks means that your business or website will perform as needed and without interruption.

In addition to the uptime, performance, and cross-platform compatibility, MySQL is a free tool with very little barrier to entry.

Three Disadvantages of MySQL:

MySQL has three main disadvantages compared to its competitors. These may be a setback for some, but depending on the needs of your organisation may not be an issue.

  • Large databases: While MySQL can handle a large database, it doesn’t do it efficiently.
  • Debugging: MySQL development and debugging tools aren’t as feature-rich as other paid competitors.
  • Stability: There are concerns that the way in which MySQL handles transactions is inefficient and prone to stability issues, which doesn’t make it suitable for that type of application.

At the end of the day, MySQL is a simple, easy-to-use, relational database designed to handle structured data. In a world where big data is increasingly unstructured, that can be considered a disadvantage, especially if you have to store streaming analytics from thousands of IoT devices.

When Should You Use MySQL?

MySQL is great for small to medium-sized businesses and personal users looking for a simple, easy-to-use database for their applications with reliable uptime. With its high-availability options, common issues with human error, network failure, or planned maintenance won’t take you offline and away from your customers. 

Due in part to its open source nature, MySQL can offer substantial savings over other database options. MySQL also offers licencing fees and support at costs that are often lower than its competitors yielding a lower total cost of ownership (TCO).

Conclusion

MySQL is an open source relational database management system with platform independence and myriad uses and functionality. You can use it for a team working from different devices. You can even utilize instances of MySQL offered by cloud providers. If your company needs a low-cost solution for your database that offers the flexibility to grow as you do, has the support of a large community, and gives you peace of mind with state-of-the-art, high-availability, and security features, then you should look at MySQL.

09/2024
Innovating the Educational Experience with Perdoceo Education & Pure Storage
When IT leaders at Perdoceo Education made the decision to adopt a cloud-first strategy, they didn’t hesitate to involve Pure Storage.
Case Study
3 pages

Browse key resources and events

THOUGHT LEADERSHIP
The Innovation Race

The latest insights and perspectives from industry leaders at the forefront of storage innovation.

Learn More
PURE//ACCELERATE ROADSHOWS
Join the Next Era of Data at a Pure//Accelerate Roadshow

Discover the storage solutions and strategies to power the next generation and beyond.

Register Now
ANALYST REPORT
The CISO Blueprint for Success

CISOs get candid about the biggest InfoSec challenges they’re facing and the solutions to overcome them.

Read the Report
RESOURCE
Stop Buying Storage, Embrace Platforms Instead

Explore the needs, components, and selection process for enterprise storage platforms.

Read the Report
CONTACT US
Meet with an Expert

Let’s talk. Book a 1:1 meeting with one of our experts to discuss your specific needs.

Questions, Comments?

Have a question or comment about Pure products or certifications?  We’re here to help.

Schedule a Demo

Schedule a live demo and see for yourself how Pure can help transform your data into powerful outcomes. 

Call Sales: 800-976-6494

Mediapr@purestorage.com

 

Pure Storage, Inc.

2555 Augustine Dr.

Santa Clara, CA 95054

800-379-7873 (general info)

info@purestorage.com

CLOSE
Your Browser Is No Longer Supported!

Older browsers often represent security risks. In order to deliver the best possible experience when using our site, please update to any of these latest browsers.