Profile
Twitter:cyberblack28
Hatena Blog:https://cyberblack28.hatenablog.com/
Job
Educational Solution Architect
Developer Advocate/Technical Evangelist
Infrastructure Engineer
Frontend Engineer
Community
Music,Live,FES !! Take a picture !!
https://www.flickr.com/photos/cyberblack
ISBN-10: 4798155373
ISBN-13: 978-4798155371
I wrote the Chapter 6 Rancher 2.0 part.
Release on March 15, 2018
!
#rancherjp
#kujiraya
#deepcn
Slide 3
Slide 3 text
Company
Slide 4
Slide 4 text
Agenda
1. Session’s Summary
2. MySQL Operator
3. Reference DEMO
4. Information
Slide 5
Slide 5 text
Session’s Summary
Slide 6
Slide 6 text
Session’s Summary
Documents
http://urx.space/ONjM
Slide
Movie
https://youtu.be/g924HDB81oc
Running MySQL on Kubernetes
Session
https://www.youtube.com/watch?v=scQScx02eWg
Demo
https://www.youtube.com/watch?v=rlG51bZ6wkk
Slide 7
Slide 7 text
Session’s Summary
MySQLWXOEQ %7D-+1.9+Kubernetes
!"LF
IK mj#
68
!'"&
$),*Kubernetes1-
75
2+
qe MySQLa`5.DioMySQLhHPlb;+./+C6MySQL
GaleraHP;B/;+.lb^8B>2"]NStatefulSet
a`
!
ni5.DgpkdJ1=D+2C*?D'"("&$)
MySQL'1-
MySQL%0. "3/75
MySQL Operator94
\dJ Vitess&@+.AD'*+0<MySQLUT+(AD'%:
C. !Y[G_*>3cMfS7B&$A)4.#,
ZVR
Slide 8
Slide 8 text
Session’s Summary
• De-mystifying containers
• MySQL running on containers
• MySQL on Kubernetes
• Stateful applications – StatefulSets
• Operators - MySQL Operator
• Sharding - Vitess
Time permitting…
• Save questions until the end
Time Out
Slide 9
Slide 9 text
Session’s Summary
Oh no!
Database is on containers !?
• %#
,'&
• !($!+)
#"
• +)
• !*
Slide 10
Slide 10 text
Session’s Summary
Databases: Pet vs. Cattle
• The containers are cattle !
• The data is pet !
Databases Containers are…
Session’s Summary
Node Affinity/AntiAffinity
• -- -- I H NEA HcDAE he P
• g /
• - d - /
• -- -- I i
• -- I f SH he P -- I f S
a he P
Pod Affinity/AntiAffinity
Slide 14
Slide 14 text
Session’s Summary
StatefulSet
• U R 1 U1
•
• D
• P O a
2.NodeMySQL Pod
Slide 15
Slide 15 text
Session’s Summary
Headless Service
• Poda IP V P ※StatefulSet Headless Service
StorageClass & VolumeClaimTemplate
• S C T
• e g d
3.
4.MySQL Pod
Slide 16
Slide 16 text
Session’s Summary
Slide 17
Slide 17 text
MySQL Operator
Slide 18
Slide 18 text
MySQL Operator
Operators
• ns c ko a v r
• A , A , MP A LQ D ns c
ko luhd a k
• p b ei mt ns c D DI W
• sf eQa v r OK
• , A B SR A
• ns c ge y
• C QMP e t
• A , A g n MP ns c yE
A A C A A A , SR
Slide 19
Slide 19 text
MySQL Operator
MySQL Operators
• Oracle https://github.com/oracle/mysql-operator
• Presslabs https://github.com/presslabs/mysql-operator
• GRTL https://github.com/grtl/mysql-operator
• Comparisons https://banzaicloud.com/blog/mysql-on-kubernetes/
Slide 20
Slide 20 text
MySQL Operator
• B1*0&4?9, "7
MySQL0 "0 Kubernetes$)/
• API'@AMySQLCluster58Custom Resource DefinitionD -
! 62
• Backup,BackupSchedule,Restore "+-! >9'##)/- %6<
• MySQL 8.0
• Group Replication/ InnoDB Cluster=9
• (% %.
:C3;'##)/- %6<
https://github.com/oracle/mysql-operator
Oracle MySQL Operators
Slide 21
Slide 21 text
MySQL Operator
• S rsC
Ln c
• o K rg
f f f Sb M
L c gi Q a e K
M S L p
Q
/ L
/ MK
Slide 22
Slide 22 text
MySQL Operator
mysqlclusters.mysql.oracle.com
MySQL
(kind: Cluster)
mysqlbackups.mysql.oracle.com
(kind:Backup )
mysqlrestores.mysql.oracle.com
(kind: Restore)
mysqlbackupschedules.mysql.oracle.com
(kind: BackupSchedule)
Slide 23
Slide 23 text
MySQL Operator
•
•
•
Connecting
Slide 24
Slide 24 text
MySQL Operator
https://github.com/oracle/mysql-operator/blob/master/docs/tutorial.md
Oracle MySQL Operator Tutorial
https://qiita.com/ysakashita/items/a2f7060e1bc118e34811
Slide 25
Slide 25 text
Reference DEMO
Slide 26
Slide 26 text
Reference DEMO
Oracle MySQL Operator DEMO
• 3 B l O Rc W
• 3 S oS o3 -
S q o3 m
• S Rc W r 3 L 3
3
• Sa e nMs g Q pk 3
d
https://www.youtube.com/watch?v=scQScx02eWg
Slide 27
Slide 27 text
Reference DEMO
Slide 28
Slide 28 text
Reference DEMO
Presslabs MySQL Operator DEMO
• M 3 LM
• LQ M S
S 1 Q a
• dL LM
• LM e OQ
https://www.youtube.com/watch?v=rlG51bZ6wkk
Slide 29
Slide 29 text
Reference DEMO
Slide 30
Slide 30 text
Information
Slide 31
Slide 31 text
Information
2019.1.9 Cloud Native Meetup Tokyo #6 KubeCon + CNCon Recap