´Z.ªl FNW8Iï Ú & m D * 1 d « Z] ¬@=lQM á> EÎQMª¨ …...¸Eó¬- Ó ® ö nF1 H ! ] Ú ô...

1 CASE STUDY | MySQL Enterprise Edition | KDDI Corporation Copyright © 2020, Oracle and/or its affiliates

1/5

MySQL InnoDB Cluster �

��

KDDI ��

��

� � � CASE STUDY KDDI DBA Database Administrator

MySQL InnoDB Cluster MySQL Enterprise Edition �

INTRODUCTION KDDI

KDDI�au�

PAYIoT au�HOME au

EC �

IT� �

�CoE�(Center�of�Excellence)� KDDI�DBA

�

DBA 1,000貢

DBA

KDDI 株式会社プラットフォーム開発本部サービスアプリケーション開発部フレームワークグループマネージャー宮澤真也氏

KDDI 株式会社プラットフォーム開発本部サービスアプリケーション開発部フレームワークグループ主任鈴木雄祐氏


��

CHALLENGE 貢 DBA KDDI�DBA

2014 2015KDDI

2 �

1 �

�

2 SI �KDDI SI �

�KDDI �

1 �

KDDI�DBA1,000 �

F1 12

�

KDDI 貢 Oracle�Exadata�Database

F1 �

SoE�(System�of�Engagement)�

KDDI MySQL�

�

縮 �MySQL�InnoDB�Cluster �

MySQL�Enterprise�Edition MySQL�Enterprise�Monitor MySQL�Enterprise�Backup �

RESULTS 2019 6 KDDI MySQL�InnoDB�Cluster 2

�

1 MySQL Master-Slave

MySQLMySQL�InnoDB�Cluster �

MySQL�InnoDB�Cluster �

Master-Slave MySQL �

MySQL�InnoDB�Cluster�


MySQL�Shell DBMySQL�Shell

1/51 MySQL�Shell

10 �

MySQL�InnoDB�Cluster

�

MySQL�Enterprise�Monitor

DBAMySQL�Enterprise�Monitor

�

MySQL�Enterprise�Backup /mysqldump

1/10 ��

�

�

MySQL Group Replication

WHY ORACLE KDDI MySQL�InnoDB�Cluster MySQL�Enterprise�Monitor MySQL�Enterprise�Backup

�

MySQL

貢 DBA ��

SI

�

KDDI � � ��

CONNECT WITH US

[MySQL ]

TEL: 0120-065556 9:00-12:00/13:00-18:00 ( )

MAIL: [email protected]

www.mysql.com/jp facebook.com/mysql twitter.com/mysql_jp

Copyright © 2020, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0120.

MySQL�Query�Analyzer貢

�

KDDI � � ��

�

KDDI 貢 DBA DBREDatabase�Reliability�Engineering

KDDI�

�

ABOUT KDDI CORPORATION 5G ( 5

) IoT AI

KDDI2019-21

KDDI IoT/ICTDX

KDDI

5G/IoT

ORACLE SOLUTIONS USED MySQL Enterprise Edition MySQL InnoDB Cluster, MySQL Enterprise Backup, MySQL Enterprise Monitor

ORACLE CUSTOMER KDDI �

�https://www.kddi.com/�

� � �

� 5 803 5300 �2019 3 �

� �4 1,996 ��2019 3 31 �

´Z.ªl FNW8Iï Ú & m D * 1 d « Z] ¬@=lQM á> EÎQMª¨ …...¸Eó¬- Ó ® ö nF1 H ! ] Ú ô...

Documents

Transcript of ´Z.ªl FNW8Iï Ú & m D * 1 d « Z] ¬@=lQM á> EÎQMª¨ …...¸Eó¬- Ó ® ö nF1 H ! ] Ú ô...