An exciting feature-full new version of MySQL (v8.x) was released on April 2018. Along with those exciting features, there were many changes and enhancements done in MySQL's internal optimizer. Naturally, we at EverSQL keep an eye on major changes in MySQL's optimizer, to make sure we are familiar with them and co-exist with them.
So now that 2019 started, I thought it's a good point in time to look back and see how well this new version is adopted by the community. To do that, we surveyed our users for 3 months, from October to December 2018, asking which MySQL database version are they using for their main product's environment. Please note that these results are in no way scientifically-true, nor statistically-true. It's just the data we received and thought it can be interesting to share with the community.
During these 3 months, we received 2000 survey replies from professionals working in companies with more than 5 people. So what can we assume (not necessarily learn) from these numbers?
- MySQL 5.7 is still the most popular version used in the community, by far (35%). Combined with MySQL 5.6, the market-share for those two versions is around 57%.
- More than 17% are using MySQL 8.x for their main product's environment, which was surprising, as the first GA version was released 8 months ago.
- 25% of the respondents are still using the older versions of MySQL (5.0, 5.1 and 5.5) - if you're reading this and you're one of them, please consider upgrading, you won't regret it 🙂
Also, I wondered if there is a specific trend in adoption rate. It may be hard to conclude that from 3 months of data, but I had to check.
As you can see, the trend is positive - 16.2% were using MySQL 8.x in October 2018, while 17.2% were using it on December 2018. Let's hope the trend will stay in that direction.
Now that we covered the things we assume from the numbers above, let's cover a few limitations of the data we've collected:
- We didn't explore how many of these companies are large companies and how many of them are small companies (maybe, and probably, the adoption rates are different). Same goes for the difference between new companies and long-existing companies.
- We only surveyed 2000 professionals from the community...
- We didn't survey the users for their origin - is the adoption rate different in different countries?
- I bet you can think of more limitations, but I won't continue listing them here.
Hopefully the adoption rate for MySQL 8.x will be much higher when next year, when 2020 starts. Happy new year!