MySQL State of the Dolphin

下载 0

无羡

发布于

1679

人观看

#信息技术

我们在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.

展开查看详情

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

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.

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.

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.

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.

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.

0点赞

0收藏

0下载