MySQL State of the Dolphin

我们在MySQL8.0上市一年后会在哪里?旅程如何,社区如何影响路线图?在本期课程中,我们将发现我们的新发布方式,使我们能够更贴近用户,寻求性能、稳定性和创新。
关于作者
Frédéric Descamps
Frédéric Descamps is MySQL Community Manager for EMEA & APAC. He joined the MySQL Community Team in May 2016. “@lefred” has been an OpenSource and MySQL consultant for more than 15 years. His favorite topics are High Availability and Performance.

展开查看详情

1.MySQL State of the Dolphin Frédéric Descamps Copyright © 2019, Oracle and/or its affiliates. All rights reserved. | Copyright © 2019, Oracle. All rights reserved.

2.Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. Copyright © 2019, Oracle. All rights reserved. 2

3.Where are we in 2019 ? Copyright © 2019, Oracle and/or its affiliates. All rights reserved. |

4.MySQL Market Share DB-Engines 2019 MySQL is the 2nd most popular database Copyright © 2019, Oracle. All rights reserved.

5.MySQL Market Share Stack Overflow Developer Survey 2019 MySQL is the most used database Copyright © 2019, Oracle. All rights reserved.

6.JetBrains Survey 2018 The State of Developer Ecosystem MySQL is the most popular database Copyright © 2019, Oracle. All rights reserved.

7.Nearly 10 Years of Oracle Stewardship More Investment, More Innovation 2x Engineering Staff 3x QA Staff 2x Support Staff 2010 2019 Copyright © 2019, Oracle. All rights reserved. 7

8.Any New Trend? Are you seeing the same thing we see? Copyright © 2019, Oracle and/or its affiliates. All rights reserved. |

9.New Trend: Database Consolidation  To Save Costs  To Simplify Database Management  And Because NoSQL + SQL = MySQL  Companies are replacing their NoSQL databases with MySQL 8.0 Copyright © 2019, Oracle. All rights reserved.

10.What is MySQL 8.0 ? A lot of new features & a new release strategy Copyright © 2019, Oracle and/or its affiliates. All rights reserved. |

11.MySQL 8.0 is ...  More innovation  2 year of development  400+ worklogs  Over 250 new features  5000+ bug fixes  500+ new tests  … a Document Store too ! Copyright © 2019, Oracle. All rights reserved.

12.One year of MySQL Releases  2018-04-19 8.0.11 (GA)  2018-07-27 8.0.12 (3 contributions)  2018-10-22 8.0.13 (10 contributions)  2019-01-21 8.0.14 (9 contributions)  2019-02-01 8.0.15  2019-04-25 8.0.16 (8 contributions) Copyright © 2019, Oracle. All rights reserved.

13.Happy Birthday ! MySQL 8.0. : 1 year since GA Copyright © 2019, Oracle and/or its affiliates. All rights reserved. |

14.MySQL Downloads by Version April 2018 April 2019 MySQL 5.5 MySQL 8.0 MySQL 5.5 4% 7% 4% MySQL 8.0 MySQL 5.6 21% MySQL 5.6 19% 24% MySQL 5.7 65% MySQL 5.7 57% Copyright © 2019, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 14

15.MySQL 8.0: One Giant Leap for SQL “This is a landmark release as MySQL eventually evolved beyond SQL-92 and the purely relational dogma. Among a few other standard SQL features, MySQL now supports window functions (over) and common table expressions (with). Without a doubt, these are the two most important post- SQL-92 features.” https://modern-sql.com/blog/2018-04/mysql-8.0 Copyright © 2019, Oracle. All rights reserved.

16.MySQL 8.0 – Most Innovative Product of the Year Award Database Technology Conference of China (DTCC) Copyright © 2019, Oracle. All rights reserved. 16

17.3 New Leading Solutions  MySQL Document Store (NoSQL)  MySQL InnoDB Cluster  MySQL Shell Copyright © 2019, Oracle. All rights reserved.

18.Many New Features  SQL DML  SQL DDL  Instant ADD COLUMN  CTEs  RESTART  Window Functions  SET PERSIST  LATERAL  CHECK constraints  ...  ...  Indexes  Functions  Invisible  REGEXP_…  Descending  BIN_TO_UUID  Functional  GROUPING  ...  …. Copyright © 2019, Oracle. All rights reserved.

19.More New Features  JSON  GIS  New functions JSON_…  Spacial Reference Systems  In-place updates  Geographic R-trees  Faster sorting  Length Units in ST_Distance  ...  ...  Character sets  Information_Schema  UTF-8 (utf8mb4) as default  Views over Data Dictionary  General Unicode 9.0 collations  ….  ... Copyright © 2019, Oracle. All rights reserved.

20.Even More New Features  Performance_Schema  Optimizer  Histograms  PFS Indexes  Adaptive scan buffer size  Instrument server errors  IO costs ram <> disk  Statement latency histograms  NOWAIT  ...  ...  SHOW  InnoDB  List hidden columns  New redo log implementation  List index information  Lock Scheduler (CATS)  Persistent auto_increments  ... Copyright © 2019, Oracle. All rights reserved.

21.Again More New Features  Data Dictionary  Error Logging  Improved error logging  Transactional DD  Error logging in JSON  Atomic & crash safe DDL  Filters for error log  Automatic upgrade  New --log-slow-extra  ...  ...  Network  Replication  Multi-source per channel filters  Multiple bind addresses  Atomic DDL recovery binlog  New Admin Port  Binary log encryption at rest  ...  Server versions in binlog  ... Copyright © 2019, Oracle. All rights reserved.

22.Finally More New Features  Group Replication  Security  SQL Roles  Online Primary Election  Dual Passwords  Online Mode Switch  Data Masking (Enterprise)  Consistent Reads  SSL Certificates Rollout  ...  ...  Router  Shell  Part of the server source-tree  Upgrade checker  Extra routing strategy  Import JSON  Reduced metadata-cache TTL  User defined reports  ...  ... Copyright © 2019, Oracle. All rights reserved.

23.Not Only New Features But Also Better Performance ! Copyright © 2019, Oracle. All rights reserved.

24.And the Community ? What’s the role of the Community in MySQL ? Copyright © 2019, Oracle and/or its affiliates. All rights reserved. |

25.MySQL & the Community Not only contributions are valuable for us, we also appreciate:  Bug reports  Feedback  Feature requests  Evangelism (blog, presentations, books, forums and slack)  Tools around MySQL Copyright © 2019, Oracle. All rights reserved.

26.MySQL & the Community (2) MySQL Contributor 2019 Reward Program Winners:  Laurynas Biveinis  Tomita Masahiro  Daniel Black  Giuseppe Maxia  René Cannaò  Simon Mudd  Shlomi Noach  Vin Chen  Zsolt Parragi  Daniël Van Eeden  Alex Rubin  Gabriella D’Ávila Ferrara  Sveta Smirnova  Bill Karwin  Yura Sorokin  Alexey Kopytov  Sugu Sougoumarane  Felix Liang  Peter Zaitsev Copyright © 2019, Oracle. All rights reserved.

27.Successful Collaboration Examples of collaboration between MySQL and Community for the best ! Copyright © 2019, Oracle and/or its affiliates. All rights reserved. |

28.MySQL 8.0 ADD INSTANT COLUMN Copyright © 2019, Oracle. All rights reserved.

29.MySQL 8.0 Minimal Tarball Copyright © 2019, Oracle. All rights reserved.