MySQL"鱩"⪜ꪎ
世界で最も普及している、オープンソースデータベース
梶山 隆輔 / KAJIYAMA, Ryusuke
MySQL Solution Engineering Director, Asia Pacific & JapanMySQL Global Business Unit

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, timing, and pricing of any features or functionality described for Oracle’sproducts may change and remains at the sole discretion of Oracle Corporation.

2Copyright © 2020, Oracle and/or its affiliates

The world's most popular open source database
世界で最も普及しているオープンソース データベース

MySQL‫כה‬չ⚅歲‫ד‬剑‫׮‬兛⿹‫׷ְג׃‬ծؔ٦‫ف‬ٝ‫ا‬٦‫رأ‬٦‫كة‬٦‫أ‬պ• ライセンス： GPLv2 with additional permissions & 商用ライセンス• 開発体制： Oracle Corporation, MySQL Global Business Unit
• コミュニティ- 世界各地にユーザーグループが存在- 公式Facebook (https://www.facebook.com/mysql) フォロワー 50万人超- 公式Twitter (https://twitter.com/mysql) フォロワー 17万人超- 日本MySQLユーザ会 (http://www.mysql.gr.jp) メーリングリスト会員3,000人(?)- 公式日本語Twitter (https://twitter.com/mysql_jp) フォロワー 2,000人超- Slack MySQL Casual Talks Channel (mysql-casual.slack.com)
4Copyright © 2020, Oracle and/or its affiliates

MySQL‫ך‬娖〷
1995

2000

2005

MySQL
1.0-3.22⟃⵸2010

Sun3.23‫ٖزأ‬٦‫ؒآ‬ٝ‫آ‬ٝ (ISAM, HEAP) MyISAM‫سحٖأثٕو‬InnoDB
Windows㼎䘔/64bit㼎䘔ٖ‫؛ٔف‬٦‫ّء‬ٝ傈劤铂俑㶵‫؝‬٦‫( س‬SJIS/UJIS)

4.1Unicode㼎䘔‫ؙٔؒـ؟‬CSV, ARCHIVE
ndbcluster

4.0Ⰻ俑嗚稊/GIS (MyISAM)醱侧‫ذ‬٦‫ٕـ‬UPDATE/DELETE穈‫׫‬鴥‫ٔٓـ؎ٓ׫‬㘗‫؟‬٦‫غ‬

5.05.1‫ٕـؚؖٓف‬٥‫ٖزأ‬٦‫ؒآ‬ٝ‫آ‬ٝ٥،٦‫ٍثؙذؗ‬‫ػ‬٦‫صّء؍ذ‬ٝ‫ؚ‬‫ُآ؛أؙأة‬٦ٓCopyright © 2020, Oracle and/or its affiliates

Oracle5.6

memcached API
UNDO邌걄㚖
Global Transaction ID‫ٖأسحٖأثٕو‬٦‫(ـ‬DB)ؔٝٓ؎ٝALTER TABLE‫ٓز‬ٝ‫هأ‬٦‫ٕـة‬邌걄㚖

5.5

InnoDBָ‫חزٕؓؿر‬彊ず劍㘗ٖ‫؛ٔف‬٦‫ّء‬ٝ
PERFORMANCE_SCHEMA‫زأ‬،‫ءٗفس‬٦‫ٍآ‬‫زأ‬،‫ؿس‬؋ٝ‫ّءؙ‬ٝؕ٦‫ٕا‬/‫ؖٔز‬/‫ُؽ‬٦
XA‫ٓز‬ٝ‫ّءؙؠ‬ٝ
INFORMATION_SCHEMA5

2015

5.7

8.0‫ر‬٦‫ٔشّءؙ؍رة‬‫زٕؓؿر‬俑㶵‫؝‬٦‫ س‬utf8mb4‫ًُؗس‬ٝ‫زأز‬،♶〳鋔؎ٝ‫أؙحر‬‫؍ذُٔؗإ‬ROLEⰟ鸐‫ذ‬٦‫ٕـ‬䒭Windowꟼ侧
CHECKⵖ秈Clone‫؎ؚٓف‬ٝ倜‫ؠ؎و؍ذفٕؔرٌزأ؝‬ٗ‫؛ٔفٖأٖأ‬٦‫ّء‬ٝ‫اثٕو‬٦‫؛ٔفٖأ‬٦‫ّء‬ٝ‫ؚٕ‬٦‫؛ٔفٖف‬٦‫ّء‬ٝ‫ٖأسحٖأثٕو‬٦‫ـ‬Ⰻ俑嗚稊CJK㼎䘔/GIS (InnoDB)‫؍ذُٔؗإ‬䓼⻉(㼎䘔)NoSQLؔ‫ّءف‬ٝ(JSON)MySQL‫ז⚺ך‬堣腉/暴䗙•••••••‫ٖزأ‬٦‫ؒآ‬ٝ‫آ‬ٖٝ‫؛ٔف‬٦‫ّء‬ٝ‫سحٖأثٕو‬Unicode/UCA㼎䘔XA‫ٓز‬ٝ‫ّءؙؠ‬ٝ؎ًٌٝٔ‫ر‬٦‫كة‬٦‫أ‬ِ٦‫ؠ‬٦㹀纏ꟼ侧•••••••Ⰻ俑嗚稊鷲麓涸‫ر‬٦‫ة‬农〾⻉ؔٝٓ؎ٝALTER TABLE〳䵤邌걄㚖
JSON‫ر‬٦‫ة‬㘗
CRUD NoSQL API
memcached APIhttps://www.mysql.com/jp/products/enterprise/techspec.html
6Copyright © 2020, Oracle and/or its affiliates••••••‫زأ‬،‫ٕس‬٦‫ث‬ٝ‫زأ‬،‫ؿس‬؋ٝ‫ّءؙ‬ٝ‫ُؽ‬٦‫ؖٔز‬٦‫ُآ؛أؙأة‬٦ٓ‫ػ‬٦‫صّء؍ذ‬ٝ‫ؚ‬MySQL 8.0倜堣腉•••••••‫ر‬٦‫ٔشّءؙ؍رة‬Ⱏ鸐‫ذ‬٦‫ٕـ‬䒭(CTEs)
Window ꟼ侧ٗ٦ٕ鷲麓涸‫ر‬٦‫ة‬农〾⻉‫يؚٓزأؼ‬꣬갫؎ٝ‫أؙحر‬7

Copyright © 2020, Oracle and/or its affiliates• ‫ًُؗس‬ٝ‫زأز‬،• ‫ةأوثٕو‬٦ٖ‫؛ٔف‬٦‫ّء‬ٝ• ♶〳鋔؎ٝ‫أؙحر‬• ٔ‫ا‬٦‫ؚٕأ‬٦‫ف‬• ٗ‫ّءفؙؔح‬ٝ• ‫أػ‬ٙ٦‫ⵃⱄس‬欽
‫ءٔه‬٦•••••••••؎ٝ‫ةأ‬ٝ‫ز‬ADD COLUMNLATERAL〣‫ؚٗٔش؎غ‬农〾⻉CHECKⵖ秈CLONE‫؎ؚٓف‬ٝJSON‫ؗأ‬٦‫و‬嗚鏾Hash JOINVALUES俑ReplicaSetMySQL 8.0新機能 – GAリリース後に追加された新機能•••••••‫ر‬٦‫ٔشّءؙ؍رة‬Ⱏ鸐‫ذ‬٦‫ٕـ‬䒭(CTEs)
Window ꟼ侧ٗ٦ٕ鷲麓涸‫ر‬٦‫ة‬农〾⻉‫يؚٓزأؼ‬꣬갫؎ٝ‫أؙحر‬8Copyright © 2020, Oracle and/or its affiliates• ‫ًُؗس‬ٝ‫زأز‬،• ‫ةأوثٕو‬٦ٖ‫؛ٔف‬٦‫ّء‬ٝ• ♶〳鋔؎ٝ‫أؙحر‬• ٔ‫ا‬٦‫ؚٕأ‬٦‫ف‬• ٗ‫ّءفؙؔح‬ٝ• ‫أػ‬ٙ٦‫ⵃⱄس‬欽‫ءٔه‬٦•••••••••

؎ٝ‫ةأ‬ٝ‫ز‬ADD COLUMNLATERAL〣‫ؚٗٔش؎غ‬农〾⻉
CHECKⵖ秈
CLONE‫؎ؚٓف‬ٝJSON‫ؗأ‬٦‫و‬嗚鏾Hash JOINVALUES俑
ReplicaSetMySQLのフォークやブランチからのフィードバック

9Copyright © 2020, Oracle and/or its affiliates

MySQL Powers the Web&Game – WebやゲームにおけるMySQL導入事例㕂ⰻ✲⢽• ‫ؙؑؐأ‬،٥ؒ‫أؙحص‬https://www.mysql.com/jp/customers/view/?id=1275

嵲㢩✲⢽• Facebook

https://www.mysql.com/jp/customers/view/?id=757• LINE• Booking.com• ًٕؕٔ

• Uber• ‫ُءحٍؗزحؽ‬• Spotify• َ‫؝ٖو‬• Airbnb• 麓⿠‫ك؎ך‬ٝ‫✲ךדز‬⢽闌怴项俱‫וז‬• MySQL㼪Ⰵ✲⢽https://www.mysql.com/jp/customers/view/?id=1327
https://www.mysql.com/jp/customers/view/?id=1428
https://www.mysql.com/jp/customers/view/?id=1419
https://www.mysql.com/jp/customers/view/?id=1430

https://www.mysql.com/jp/news-and-events/seminar/
downloads.html

10

Copyright © 2020, Oracle and/or its affiliates

https://www.mysql.com/jp/customers/view/?id=901
https://www.mysql.com/jp/customers/view/?id=1269
https://www.mysql.com/jp/customers/view/?id=1285
https://www.mysql.com/jp/customers/view/?id=1271

https://www.mysql.com/jp/customers/

MySQL Powers eCommerce

11

Copyright © 2020, Oracle and/or its affiliates

MySQL Powers SaaS

12

Copyright © 2020, Oracle and/or its affiliates

MySQL Powers Telecom

13

Copyright © 2020, Oracle and/or its affiliates

MySQL Technology Update - 剑倜䪮遭䞔㜠MySQL Server 8.0

MySQL NDB Cluster 8.0

MySQL Cloud Service• GAٔٔ٦‫أ‬䖓‫׮‬竰竲涸‫ח‬堣腉䓼⻉• InnoDB ReplicaSet‫ה‬InnoDBCluster‫׷״ח‬宏䎂䭁䓸䚍‫ה‬罣ꥺ㹱䚍‫ך‬ぢ♳• SQL圓俑‫ך‬鷄⸇‫׷״ח‬堣腉䚍ぢ♳• JSON‫ؗأ‬٦‫ه؟ךو‬٦‫װز‬NoSQL API‫׷״ח‬،‫ٔف‬Ꟛ涪厫鮾䚍• 㣐ꆀ‫ر‬٦‫ךפة‬㼎䘔‫׭׋ך‬ծ‫ر‬٦‫ظة‬٦‫س‬侧剑㣐144〴ծ‫ظ‬٦‫׶׋֮س‬剑㣐16TB• ‫ر‬٦‫ⱔة‬ꞿ⻉‫ך‬㢳ꅾ䏝4‫דת‬㼎䘔ծ罣ꥺ㹱䚍‫ך‬䓼⻉• ‫ٓز‬ٝ‫ّءؙؠ‬ٝꟼ鸬‫⹛ךةًٓػ‬涸鏣㹀‫׷״ח‬麊欽盖椚䚍‫ך‬ぢ♳• MySQL Enterprise Edition‫ك‬٦‫؟سؙؐٓךأ‬٦‫׾أؽ‬Oracle Cloud Infrastructure‫ח‬㾜Ꟛ• ؎ًٌٝٔ‫ر‬٦‫ⴓة‬匿‫ח‬ꟼ‫ׅ‬‫׷‬Oracle Labs‫ךד‬灇瑔䧭卓‫׾‬㹋欽⻉‫׋׃‬MySQL Analytics
Service‫׾‬窟さ14

Copyright © 2020, Oracle and/or its affiliates

Thank you

15

Copyright © 2020, Oracle and/or its affiliates