MySQL開発最新動向
Oracle MySQL Cloud Serviceの最新情報もご紹介
2019/11/09

オープンソースカンファレンス 2019 Fukuoka

Yoshiaki Yamasaki / 山﨑 由章
MySQL Principal Solution Engineer, Asia Pacific and Japan1

Safe harbor statement28.0.112018-04-19(General Availability)

3

MySQL 8.0: Fast Adoption
April 2018 (8.0 GA)
MySQL 5.54%

August 2019MySQL 5.53%

MySQL 8.05%

MySQL 8.026%

MySQL 5.624%

MySQL 5.625%

MySQL 5.766%
MySQL 5.747%

4MySQL
リレーショナルテーブル
外部キーMySQL

ドキュメントストア
NoSQL
JSON ドキュメント
スキーマレス JSON コレクション
5X Dev API
SQL
CRUD

MySQL Document Store: SQL + NoSQL = MySQL

X DevAPISQL + CRUD API

MySQL
8.0
Relational
Tables6{ } JSONDocuments

MySQL : アプリケーション開発者に柔軟性をデータ型

7{}

SQL 関数();

ハイブリッドAPIMySQL : モバイルアプリとの親和性•••� �� �8••••

MySQL : データ分析処理の効率向上
共通テーブル式 (CTEs)

Window 関数

••
•

•
•

WITH tickets_filtered AS (SELECT tickets.*, seats.doc
FROM tickets
INNER JOIN seats ON
tickets.seat_id = seats.id
WHERE tickets.event_id = 3)
SELECT * FROM tickets_filtered
WHERE doc->"$.section" = 201¥G9SELECT name, dept_id, salary,
RANK() OVER w AS `rank`
FROM employee
WINDOW w AS
(PARTITION BY dept_id
ORDER BY salary DESC);

InnoDB Cluster
App Servers withMySQL Router

MySQL Shell
Setup, Manage,
Orchestrate

MySQL Group Replication

10

MySQL InnoDB Cluster



11

MySQL InnoDB Cluster Update group_replication_consistency 8.0.14
App Servers withMySQL Router
MySQL Shell
Setup, Manage,
Orchestrate

MySQL Group Replication

12

 group_replication_communication_max_message_size 8.0.16

 Clone Plugin 8.0.17

MySQL Shellを知っていますか？

13

MySQL Shellの歩み

MySQLServer

2015/4/8

2016/4/11

2017/4/11

2017/4/18

2019/7/22

5.7GA(5.7.9)5.7.12

5.7.188.0GA(8.0.11)8.0.17

2016/4/11

2017/4/12

2017/4/18

2019/7/2
2

1.0.3
初版

1.0.9

8.0.11

8.0.17MySQLShell

14

MySQL Shellの特徴① 多言語をサポート② 実行形式を選択可能

・JavaScript・バッチ・Python

・インタラクティブ・SQL③ MySQLユーティリティ④ 統合されたAPI

・アップグレードチェッカー・ドキュメントストア操作

・JSONインポート

・InnoDBクラスタ管理

・高速データロード

15

MySQL 8.0: Upgrade Checker
•
––•
–––•
––16

Oracle OpenWorld 2019 &Oracle Code One 2019での主要なMySQL関連トピックス

17

State of the Dolphin

Rich Mason, SVP & GM, MySQL GBU

18

MySQL 8.0

Tomas Ulin, VP, MySQL Engineering

MySQL 8.0 Highlights

20

MySQL Document StoreMySQL InnoDB Cluster

MySQL Security

MySQL ShellMySQL 8.0: One Giant Leap for SQL“This is a landmark release as MySQL
eventually evolved beyond SQL-92 and thepurely relational dogma. Among a few
other standard SQL features, MySQL now
supports window functions (over) andcommon table expressions (with). Withouta doubt, these are the two most importantpost-SQL-92 features.”https://modern-sql.com/blog/2018-04/mysql-8.021

MySQL 8.0: Hash Join
• Typically faster than nested loop for large result sets
• In-memory if possible• Spill to disk if necessary• Used for inner equi-joins– Extendable to outer, semi and anti joins• Replaces BNL in query plans• Hints to force use of hash join or nested loop

228.0.18

MySQL 8.0: EXPLAIN ANALYZE• Instruments and executes the query– Estimated cost
– Actual execution statistics• Time to return first row• Time to return all rows
• Number of rows returned• Number of loops• Uses the new tree output format also available in EXPLAIN

238.0.18

MySQL InnoDB Cluster
New! Automatic Node Provisioning with CLONE plugin

MySQL
Group Replication

Joining
Member

CLONE: Automatic Full Data
Snapshot Provisioning

24

MySQL NDB Cluster
MySQL’s highest throughput real-time datastore• Built on MySQL 8.0• Increased capacity to hundreds of terabyte, more data nodes• Support for 3 and 4 replicas• Auto-config with real-time resource pools• Faster and robust disk data• Improved SQL performance, parallel backups, larger rows

25

8.0.18RC

Oracle CloudMySQL as a Service

Oracle Cloud World Map

27

MySQL as a Service• Developed & Operated by the MySQLEngineering Team• MySQL 8.0 Enterprise Edition• Oracle Cloud Infrastructure Gen 2• 24x7 Oracle Premier Support• Exclusive! MySQL Analytics Service

28

RAPID: Rapid Analytics Processing In DRAM

DBMS

DBMS

DBMS

DBMS

RAPID
Pushdown

RAPID
Pushdown

RAPID
Pushdown

RAPID
Pushdown

Interconnect

RAPID
nodes
• Push down as much of the query as possible• Extreme performance for analytic operators on a single node• Extreme (near linear) scalability across nodes
29

商用版MySQLについて

30

MySQL License

31

MySQL Enterprise Edition

32

MySQL SupportStandard Edition / Enterprise Edition / MySQL Cluster Carrier Grade Edition••••••
••
•

33

MySQL Enterprise Security

Enterprise Edition / MySQL Cluster Carrier Grade Edition
•••

•
•••
••

34

MySQL Enterprise Security

Enterprise Edition / MySQL Cluster Carrier Grade Edition••
•

•••

•••

35

MySQL Subscription

36

37

38

安心してMySQLをご利用ください39

【MySQL お問い合わせ窓口】
0120-065556【受付時間】
平日 9:00-12:00/13:00-17:00(祝日及び年末年始休業日を除きます)
MySQL-Sales_jp_grp@oracle.com

40

MySQL Innovation Dayについて41

11/7(木)：東京、11/8(金)：大阪でMySQL Innovation Dayを開催しました42

来日ゲストのご紹介

43

Kenny GrypMySQL Principal Product Manager“I love Junmai Daiginjo!!”44

Frederic Descamps
MySQL Community Manager“<3 totoro”

45

Mike FrankMySQL Product Management Director“10 plus years withMySQL Secuity, NoSQL,
Backup, Tools focused
4 successful startups”

46

Nipun Agarwal
Vice President, Research & AdvancedDevelopment, Oracle Labs

“Very Impressive Uptakeof Oracle Cloud”

47以下URLにて、後日資料公開予定！！
https://www.mysql.com/jp/news-and-events/seminar/downloads.html

48