4 ms·

As a long term MySQL user I think getting acquired by Oracle pretty good for the product. The old, hard issues that MySQL never had the engineering to tackle th

by perbu 3y ago

As a long term MySQL user I think getting acquired by Oracle pretty good for the product. The old, hard issues that MySQL never had the engineering to tackle themselves finally got resolved.

rubiquity 3y ago
Facebook and Alibaba deserve a lot of the credit for MySQL’s recent renaissance.
- b112 3y ago
  And a lot of mysql 5.6 was percona.
asddubs 3y ago
what are those?
- 5e92cb50239222b 3y ago
  Atomic DDL (possible because of a complete rewrite of the underlying storage format), proper Unicode by default (did you know that utf8 in MySQL is not really utf8? hit up your favorite search engine for utf8mb3 vs utf8mb4), strict typing by default, plus a horde of new features many MySQL users have been waiting like CTEs and window functions. I too am a fan of what Oracle did for MySQL. There haven't been any major releases since 2018, though. Since their development process is closed, I am wondering when/if are we going to see MySQL 9 (if it's anything like 8, it's going to be huge). https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html MariaDB initially went through a process of adding absolutely everything they could into the database (e.g: many additional storage engines like Cassandra and TokuDB), most of which since have been removed. It felt less like it was driven by a strong engineering process, and more like let's throw everything and see what sticks (not much did).
  - johannes1234321 3y ago
    > There haven't been any major releases since 2018, though. Since their development process is closed, I am wondering when/if are we going to see MySQL 9 (if it's anything like 8, it's going to be huge). MySQL since 8.0 is on a "rolling release" model, where features were shipped as part of 8.0 once they were finished instead of waiting for a 9.0 release. Thus 8.0 got quite a few improvements since 8.0.0. Recently they announced a new model where they split LTS style versions and increase version number, again, but features still appear as they are done and not for a big release: https://blogs.oracle.com/mysql/post/introducing-mysql-innovation-and-longterm-support-lts-versions https://blogs.oracle.com/mysql/post/introducing-mysql-innova...
  - evanelias 3y ago
    Just to add to the explanation in the sibling comment, MySQL 8.1 was released in July.
  - asddubs 3y ago
    didn't later versions of mysql 5 also have utf8mb4? Or did they do something else? I also wonder why mysql wouldn't have had the resources for strict typing by default, I'm fairly ignorant of the complexities involved, but since this involves just checking data types on insert, it would seem to my non-expert understanding like not that big of a task to add. I don't say that to disagree with you or disparage oracles work, I'm just trying to understand your point of view better.

by perbu 3y ago

As a long term MySQL user I think getting acquired by Oracle pretty good for the product. The old, hard issues that MySQL never had the engineering to tackle themselves finally got resolved.

rubiquity 3y ago

Facebook and Alibaba deserve a lot of the credit for MySQL’s recent renaissance.

b112 3y ago
And a lot of mysql 5.6 was percona.

asddubs 3y ago

what are those?

5e92cb50239222b 3y ago
Atomic DDL (possible because of a complete rewrite of the underlying storage format), proper Unicode by default (did you know that utf8 in MySQL is not really utf8? hit up your favorite search engine for utf8mb3 vs utf8mb4), strict typing by default, plus a horde of new features many MySQL users have been waiting like CTEs and window functions. I too am a fan of what Oracle did for MySQL. There haven't been any major releases since 2018, though. Since their development process is closed, I am wondering when/if are we going to see MySQL 9 (if it's anything like 8, it's going to be huge). https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html MariaDB initially went through a process of adding absolutely everything they could into the database (e.g: many additional storage engines like Cassandra and TokuDB), most of which since have been removed. It felt less like it was driven by a strong engineering process, and more like let's throw everything and see what sticks (not much did).
- johannes1234321 3y ago
  > There haven't been any major releases since 2018, though. Since their development process is closed, I am wondering when/if are we going to see MySQL 9 (if it's anything like 8, it's going to be huge). MySQL since 8.0 is on a "rolling release" model, where features were shipped as part of 8.0 once they were finished instead of waiting for a 9.0 release. Thus 8.0 got quite a few improvements since 8.0.0. Recently they announced a new model where they split LTS style versions and increase version number, again, but features still appear as they are done and not for a big release: https://blogs.oracle.com/mysql/post/introducing-mysql-innovation-and-longterm-support-lts-versions https://blogs.oracle.com/mysql/post/introducing-mysql-innova...
- evanelias 3y ago
  Just to add to the explanation in the sibling comment, MySQL 8.1 was released in July.
- asddubs 3y ago
  didn't later versions of mysql 5 also have utf8mb4? Or did they do something else? I also wonder why mysql wouldn't have had the resources for strict typing by default, I'm fairly ignorant of the complexities involved, but since this involves just checking data types on insert, it would seem to my non-expert understanding like not that big of a task to add. I don't say that to disagree with you or disparage oracles work, I'm just trying to understand your point of view better.