Skip to main content
Background Image
  1. Database Guru/

Oracle Finally Killed MySQL

·807 words·4 mins· ·
Table of Contents
MySQL's End - This article is part of a series.
Part 3: This Article

Peter Zaitsev | Translated by: Feng Ruohang (@Vonng) | WeChat Original | Percona’s Blog

About 15 years ago, Oracle acquired Sun Microsystems, thereby also acquiring MySQL. Discussions about when Oracle would “kill MySQL” have been ongoing on the internet ever since. Various theories circulated at the time: from completely killing MySQL to reduce competition with Oracle’s proprietary database, to eliminating the MySQL open source project and leaving only “MySQL Enterprise Edition” as the sole option. These rumors spread widely, which was good business for MariaDB, PostgreSQL, and other niche competitors.

Author: Percona Blog, Marco Tusa, an important contributor to the MySQL ecosystem who developed the well-known PT series tools, MySQL backup tools, monitoring tools, and distributions.

Translator: Feng Ruohang, known as Vonng, author of Pigsty, PostgreSQL expert and evangelist. Cloud-exit advocate and database cloud-exit practitioner.

However, Oracle actually managed MySQL quite well. The MySQL team was largely retained, led by MySQL veteran Tomas Ulin. MySQL became more stable and secure. Much technical debt was resolved, and many features modern developers wanted were added, such as JSON support and advanced SQL standard features.

While there is indeed something called “MySQL Enterprise Edition”, it actually focuses on enterprise needs that developers don’t care much about: pluggable authentication, auditing, firewalls, etc. Although there are proprietary GUI interfaces, monitoring, and backup tools (such as MySQL Enterprise Monitor), there are many open source and commercial competitors in the industry, so vendor lock-in isn’t particularly severe.

During this period, I often defended Oracle because many people felt MySQL would be mistreated, given Oracle’s rather poor reputation.

However, during that time, I believed Oracle indeed followed the well-known golden rule of open source success: “Conversion should never compromise Adoption

conversion.png

Note: “Conversion should never compromise Adoption” means that in developing or improving open source software, any changes during conversion or upgrade processes should not interfere with existing users’ habits or new users’ adoption.

However, things began to change in recent years as Oracle launched “MySQL HeatWave” (a MySQL cloud database service).

MySQL HeatWave introduced many features not available in MySQL Community or Enterprise editions, such as accelerated analytical queries and machine learning.

For analytical queries, MySQL has serious problems - it still doesn’t even support parallel queries. CPUs in the market now have hundreds of cores, but single-core performance hasn’t significantly improved. The lack of parallel support severely constrains MySQL’s analytical performance improvements - affecting not only analytical applications but also simple GROUP BY queries in everyday transactional applications. (Note: MySQL 8 has some parallel support for DDL, but not for queries)

The reason for this approach - is it to give users more reasons to buy MySQL HeatWave? But alternatively, people could directly choose PostgreSQL and ClickHouse, which have stronger analytical capabilities.

Another area where open source MySQL is extremely lacking is vector search. Other mainstream open source databases have already added vector search functionality, and MariaDB is working hard to implement this feature. But currently, only the cloud-exclusive MySQL HeatWave has this functionality in the MySQL ecosystem, which is regrettable.

Then there’s the strangest decision - JavaScript functionality is only provided in the Enterprise edition. I think MySQL should try to win JavaScript developers’ hearts as much as possible, but now many JS developers already prefer the simpler MongoDB.

I believe these decisions violate the aforementioned golden rule of open source - they clearly limit MySQL’s adoption and spread - whether through these “XX-exclusive” specific features or concerns about MySQL’s future policy changes.

But that’s not all. MySQL’s performance has also seriously declined, perhaps due to ignoring the performance engineering department for years. Compared to MySQL 5.6, MySQL 8.x shows significant performance degradation on single-threaded simple workloads. You might say adding features inevitably comes at the cost of performance, but MariaDB’s performance degradation is much less severe, and PostgreSQL can even significantly improve performance while adding new features.

Obviously, I don’t know what Oracle’s management team is thinking, and I can’t say whether this is stupidity or malice. But these product decisions in recent years clearly don’t favor MySQL’s adoption, especially at a time when PostgreSQL is making great strides in leading user mindshare. According to DB-Engines popularity rankings, it has significantly narrowed the gap with MySQL; and according to the StackOverflow Developer Survey, it has even surpassed MySQL to become the most popular database.

db-engine.png

In any case, unless Oracle shifts its focus and considers modern developers’ needs for relational databases, MySQL is doomed sooner or later - whether killed by Oracle’s actions or by Oracle’s inactions.


Related Reading#

MySQL Performance Getting Worse - Where is Sakila Going?

Why is MySQL’s Correctness So Terrible?

Is Oracle Finally Killing MySQL?

Can Oracle Save MySQL?

Sakila, Where Are You Going?

Postgres vs MySQL: the impact of CPU overhead on performance

Perf regressions in MySQL from 5.6.21 to 8.0.36 using sysbench and a small server

MySQL's End - This article is part of a series.
Part 3: This Article

Related

MySQL Performance Getting Worse, Where Is Sakila Going?
·1382 words·3 mins
MySQL performance degrades with higher versions? While PostgreSQL advances triumphantly, eating the database world, MySQL’s performance and features are being left further behind. Why has MySQL stagnated under Oracle? I think it’s mainly the fault of cloud vendors freeloading - PG should take warning.
Can Chinese Domestic Databases Really Compete?
·1963 words·10 mins
Friends often ask me, can Chinese domestic databases really compete? To be honest, it’s a question that offends people. So let’s try speaking with data - I hope the charts provided in this article can help readers understand the database ecosystem landscape and establish more accurate proportional awareness.
The $20 Brother PolarDB: What Should Databases Actually Cost?
·2597 words·13 mins
Today we discuss the fair pricing of commercial databases, open-source databases, cloud databases, and domestic Chinese databases.
Redis Going Non-Open Source is a Disgrace to "Open Source" and Public Cloud
·2091 words·5 mins
Redis “going non-open source” is not a disgrace to Redis, but a disgrace to “open source/OSI” and even more so to public cloud. What truly matters has always been software freedom, while open source is just one means to achieve software freedom.
How Can MySQL's Correctness Be This Garbage?
·3110 words·15 mins
MySQL’s transaction ACID has flaws and doesn’t match documentation promises. This may lead to serious correctness issues - use with caution.
Are Specialized Vector Databases Dead?
·1835 words·9 mins
Vector storage and retrieval is a real need, but specialized vector databases are already dead. Small needs are solved by OpenAI directly, standard needs are captured by existing mature databases with vector extensions. The ecological niche left for specialized vector databases might support one company, but trying to build an industry around AI stories is impossible.