MySQL the Cloud Native database - Running MySQL at scale has never been so easy

MySQL the Cloud Native database
Running MySQL at scale has never been so easy
Olivier Dasini
MySQL Principal Solutions Architect EMEA
[email protected]
Twitter : @freshdaz
Blogs : www.dasini.net/blog/en
: www.dasini.net/blog/fr

View Slide

Me, Myself & I

MySQL Geek
 Addicted to MySQL for 15+ years
 Playing with databases for 20+ years

MySQL Writer, Blogger and Speaker
 Also former : DBA, Consultant, Architect, Trainer, ...

MySQL Principal Solutions Architect EMEA at Oracle

Stay up to date!
 Twitter: @freshdaz
 Blog: www.dasini.net/blog/en
Olivier DASINI

View Slide

MySQL
Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
The world’s most popular open source database
3
3

View Slide

Innovative enterprises across many industries run MySQL
Social E-Commerce Tech Finance Manufacturing
4
4

View Slide

MySQL High Availability
Avoid loss of service by reducing the risk of failures
5
5
Fault
Tolerance

View Slide

A complete built-in High Availability solution for MySQL
MySQL InnoDB Cluster
●
MySQL Servers synchronously replicate
– Secondary servers are read-only
– Failover is automated
●
No human intervention needed
– New members clone from others (cloning)
– Restored members catch up (synchronization)
●
MySQL Router sends the write sessions to the
primary server only
– Read-only sessions are distributed by MySQL
Router to the secondary servers
– Automatically sends writes to the new primary
after failover
●
MySQL Shell provides a full administration
interface to the cluster
6
6

View Slide

Consistency: No Data Loss (RPO=0)
• In event of failure of primary member
• Split brain prevention (quorum)
Read Scaling
• Add/remove members as needed
• Replication Lag handling with Flow Control
• Configurable consistency levels
• Eventual
• Full consistency (no stale reads)
Highly Available: Automatic Failover
• Primary members are automatically elected
• Automatic network partitioning handling
Goals
7
7

View Slide

Options for where you run MySQL
Clustering For High-Availability
Compute nodes / VMs
Easy to setup
Easy to manage
Automated failover
Not a managed service
Kubernetes
MySQL Operator
Easier to setup
Easier to manage
Automated failover
Mostly managed service
Public Cloud
MySQL Database Service
Easiest to setup
Easiest to manage
Automated failover
Fully managed service
8
8

View Slide

Kubernetes
Automating deployment, scaling, & management
of containerized applications
9
9

View Slide

Official MySQL container distribution published and supported by Oracle
• MySQL Server
• MySQL Router
Community Edition available on
●
https://hub.docker.com/u/mysql
●
https://container-registry.oracle.com
Commercial Edition available on
●
https://container-registry.oracle.com
●
https://edelivery.oracle.com
●
https://support.oracle.com
Like Community version, but adds:
• Security/privacy plugins
• MySQL Enterprise Backup
MySQL 8.0 Docker Images
10
10

View Slide

Kubernetes
A portable, extensible, open-source platform for managing containerized workloads and
services, that facilitates both both declarative configuration and automation
Kubernetes Operator
Method of automatically deploying and managing a service
Goals of an operator
• Deployment
• Configuration
• Self-healing
• Backup & Restore
• Observability
• Using Kubernetes custom resources
Both MySQL Operator for Kubernetes and
MySQL InnoDB Cluster share a common goal
to make it easier to deploy, automate and
manage a service
11
11

View Slide

MySQL Operator for k8s
Manage MySQL InnoDB Cluster inside
a Kubernetes Cluster
12
12
Kubernetes

View Slide

• Automated deployment and management of
• MySQL Server
• MySQL Router
• Self-healing
• Backup & Restore
• Scaleup/Scaledown of Router & Server
• Community Edition, Open Source License (UPL)
• Enterprise Edition
• Fully supported by Oracle
• Rolling upgrades with minimal downtime
• Configuration Management
• Deploy from InnoDB CLONE
• Private container registries
MySQL Operator for Kubernetes
Public preview state : https://github.com/mysql/mysql-operator
The MySQL Operator for Kubernetes is designed to help operate MySQL InnoDB Cluster in Kubernetes
environment:
• Greatly simplify operations
• Improve high-availability
• Offer a more "native" Kubernetes experience to the user
13
13

View Slide

MySQL In Kubernetes Or As-A-Service
Oracle Cloud Infrastructure
Block
Storage
File
Storage
Object
Storage
HeatWave
Oracle Container Engine for Kubernetes (OKE)
Service Broker for
Kubernetes and
Endpoints
 Fully managed, self tuned database
 Hybrid SQL and NoSQL database
 High-availability option
 High-performance HeatWave option
 Security: automated patching/updating
 Interoperability: MySQL is ubiquitous in
Public Clouds and on premises
Service Brokers
Create services in Kubernetes that refer to
external OCI services
• MySQL Database Service
• Oracle Autonomous Database
• Object Storage
• ...
Persistent
Volumes
14
14

View Slide

OCI Service Operator for Kubernetes (OSOK)
15
A Kubernetes Operator to enable provisioning and managing OCI resources using Kubernetes API
●
OSOK is an open source Kubernetes add-on that allows
users to manage OCI resources, such as the Autonomous
Database service and the MySQL Database service
(MDS), through the Kubernetes API
●
You can provision and manage MDS the same way you
manage your microservices application on OKE
– You can unify the lifecycle management experience
●
It removes the needs to use OCI console, OCI CLI, or other
tools for MDS
– You can unify the experience between microservices
application and MDS
●
OKE provides a nice way for your microservices
application to connect to MDS from OKE environment
https://mysqlsg.blogspot.com/2021/09/create-manage-and-connect-to-mysql.html
●
https://blogs.oracle.com/cloud-infrastructure/post/oci-service-operator-for-kubernetes
●
https://docs.oracle.com/en-us/iaas/Content/ContEng/Tasks/contengaddingosok.htm

View Slide

100% Developed, Managed & Supported
by the MySQL Team
16
16

View Slide

MySQL Database Service Overview
17
100% Developed, Managed and Supported by the MySQL Team

View Slide

MySQL Database Service: High Availability, multi AD Region
18 Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
Deployed across fault and
availability domains
Native MySQL Group Replication
No data loss in case of failure
(RPO=0)
Online and fast fail-over
(RTO=minutes)
Inbound
Replication
MySQL
Database
Service
Applications
(Secondary) (Secondary)
(Primary)
AD1
MySQL
Group Replication
AD2 AD3
Fault-tolerant system with automatic failover & zero data loss through Group Replication

View Slide

MySQL HeatWave
MySQL in-Memory Query Accelerator
19
19

View Slide

Single MySQL database for OLTP & analytics applications
All existing applications work without any changes
Machine-Learning–based automation with MySQL Autopilot
Extreme performance: Accelerates MySQL by orders of magnitude, scales to thousands
of cores
Enables running analytics on data stored on-premises
Dramatically faster and lower cost compared to other cloud services
MySQL HeatWave Overview
The only MySQL service with a massively-scalable, native query accelerator
20
20
https://www.oracle.com/fr/mysql/heatwave/

View Slide

MySQL HeatWave - MySQL in-Memory Query Accelerator
Easily run high performance analytics against your MySQL database, no ETL required
Single MySQL database for
OLTP & analytics applications
All existing applications work
without any changes
Extreme performance: 400x
faster than MySQL, scales to
thousands of cores
OLAP Applications
OLTP Applications
OLTP
Engine
Analytics
Engine
MySQL
Database
Service

View Slide

*Benchmark queries are derived from the TPC-H benchmark, but results are not comparable to published TPC-H benchmark results since they do not comply with the TPC-H specification
400G, 64 cores
MySQL HeatWave dramatically speeds up analytic queries

View Slide

See documented performance comparisons that show how HeatWave is 6.5X faster than Amazon Redshift at half the cost, 1400X faster than Amazon Aurora at half the cost, and 5400X faster than Amazon RDS for MySQL at two-thirds the cost
30TB TPCH, MySQL HeatWave is faster, cheaper & easier to use than all the competitive database services
MySQL HeatWave performance and price comparison
23 https://www.oracle.com/mysql/heatwave/performance/

View Slide

Test Drive MySQL
Database Service For
Free Today
Get $300 in credits
and try MySQL Database Service
free for 30 days.
https://www.oracle.com/cloud/free/
24
24

View Slide

Discovering MySQL Database Service
●
Discovering MySQL Database Service – Episode 1 – Introduction
– http://dasini.net/blog/2021/08/03/discovering-mysql-database-service-episode-1-introduction/
●
Discovering MySQL Database Service – Episode 2 – Create a compartment
– http://dasini.net/blog/2021/08/10/discovering-mysql-database-service-episode-2-create-a-compartment/
●
Discovering MySQL Database Service – Episode 3 – Create a Virtual Cloud Network
– http://dasini.net/blog/2021/08/17/discovering-mysql-database-service-episode-3-create-a-virtual-cloud-network/
●
Discovering MySQL Database Service – Episode 4 – Dump your MySQL data into an Object Storage bucket
– http://dasini.net/blog/2021/08/24/discovering-mysql-database-service-episode-4-dump-your-mysql-data-into-an-object-storage-bucket/
●
Discovering MySQL Database Service – Episode 5 – Create a MySQL DB system from a MySQL Shell dump
– http://dasini.net/blog/2021/08/31/discovering-mysql-database-service-episode-5-create-a-mysql-db-system-from-a-mysql-shell-dump/
●
Discovering MySQL Database Service – Episode 6 – Update the Private Subnet Security List
– http://dasini.net/blog/2021/09/07/discovering-mysql-database-service-episode-6-update-the-private-subnet-security-list/
●
Discovering MySQL Database Service – Episode 7 – Use a Bastion SSH port forwarding session
– http://dasini.net/blog/2021/09/14/discovering-mysql-database-service-episode-7-use-a-bastion-ssh-port-forwarding-session/
●
Discovering MySQL Database Service – Episode 8 – Connect to MySQL Database Service Using MySQL Shell
– http://dasini.net/blog/2021/09/21/discovering-mysql-database-service-episode-8-connect-to-mysql-database-service-using-mysql-shell/
●
...
Tutorials where I show you, step by step, how to use MDS and some other OCI services
http://dasini.net/blog/en
25
25

View Slide

Resources
• Introducing the MySQL Database Service
– https://blogs.oracle.com/mysql/introducing-the-mysql-database-service
• Migrate from on premise MySQL to MySQL Database Service
– https://blogs.oracle.com/mysql/migrate-from-on-premise-mysql-to-mysql-database-service
• Documentations
– https://docs.cloud.oracle.com/en-us/iaas/mysql-database/index.html
– https://www.oracle.com/mysql/
• HeatWave – A MySQL cloud feature to speed up your queries
– http://dasini.net/blog/2021/04/13/heatwave-a-mysql-cloud-feature-to-speed-up-your-queries/
• MySQL Operator for Kubernetes
– https://github.com/mysql/mysql-operator
• OCI Service Operator for Kubernetes
– https://blogs.oracle.com/cloud-infrastructure/post/oci-service-operator-for-kubernetes
• Create, Manage and Connect to MySQL Database Service using OCI Service Operator for Kubernetes
– https://mysqlsg.blogspot.com/2021/09/create-manage-and-connect-to-mysql.html
• MySQL InnoDB Cluster
– https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-innodb-cluster.html
MySQL Database Service / MySQL HeatWave / MySQL Operator for k8s
26
26

View Slide

Follow us on Social Media
27
27

View Slide

LiveLabs
• This lab will introduce you to a powerful union
between MySQL Enterprise Edition and Oracle
Cloud Infrastructure (OCI)
• You will learn how to create your first MySQL
Database Service System in a secure OCI
environment
• You will also learn how to connect and use your
MySQL Database Service System with the
MySQL Shell tool
• https://bit.ly/3tL6q9B
Launch Your First MySQL Database Service System Workshop
28
28

View Slide

Merci!
Q&R
Olivier Dasini
MySQL Principal Solutions Architect EMEA
[email protected]
Twitter : @freshdaz
Blog : www.dasini.net/blog/en

View Slide

View Slide

MySQL the Cloud Native database - Running MySQL at scale has never been so easy

MySQL the Cloud Native database - Running MySQL at scale has never been so easy

Olivier DASINI

More Decks by Olivier DASINI

Other Decks in Technology

Featured

Transcript