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

Running the world’s most popular open source database at scale has never been so easy.

######################################
# 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/

#################################################################################
# Ressources – MySQL Database Service / MySQL HeatWave / MySQL Operator for k8s #
#################################################################################

• 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

Transcript

1. MySQL the Cloud Native database Running MySQL at scale has never been so easy Olivier Dasini MySQL Principal Solutions Architect EMEA olivier.dasini@oracle.com Twitter : @freshdaz Blogs : www.dasini.net/blog/en : www.dasini.net/blog/fr
2. 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
3. MySQL Copyright © 2021, Oracle and/or its affiliates. All rights reserved. The world’s most popular open source database 3 3
4. Innovative enterprises across many industries run MySQL Social E-Commerce Tech Finance Manufacturing Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 4 4
5. MySQL High Availability Copyright © 2021, Oracle and/or its affiliates. All rights reserved. Avoid loss of service by reducing the risk of failures 5 5 Fault Tolerance
6. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 6 6
7. MySQL InnoDB Cluster 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 7 7
8. Options for where you run MySQL Clustering For High-Availability Compute nodes / VMs MySQL InnoDB Cluster 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 8 8
9. Kubernetes Copyright © 2021, Oracle and/or its affiliates. All rights reserved. Automating deployment, scaling, & management of containerized applications 9 9
10. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 10 10
11. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 11 11
12. MySQL Operator for k8s Copyright © 2021, Oracle and/or its affiliates. All rights reserved. Manage MySQL InnoDB Cluster inside a Kubernetes Cluster 12 12 Kubernetes
13. • 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 13 13
14. MySQL In Kubernetes Or As-A-Service Oracle Cloud Infrastructure Block Storage File Storage Object Storage MySQL Database Service HeatWave Oracle Container Engine for Kubernetes (OKE) Service Broker for Kubernetes and Endpoints MySQL Database Service  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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 14 14
15. OCI Service Operator for Kubernetes (OSOK) Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 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
16. MySQL Database Service Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 100% Developed, Managed & Supported by the MySQL Team 16 16
17. MySQL Database Service Overview Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 17 100% Developed, Managed and Supported by the MySQL Team
18. 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
19. MySQL HeatWave MySQL in-Memory Query Accelerator Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 19 19
20. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 20 20 https://www.oracle.com/fr/mysql/heatwave/
21. MySQL HeatWave - MySQL in-Memory Query Accelerator 21 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 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 https://www.oracle.com/fr/mysql/heatwave/
22. *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 22 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. https://www.oracle.com/fr/mysql/heatwave/
23. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 23 https://www.oracle.com/mysql/heatwave/performance/
24. 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/ Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 24 24
25. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 25 25
26. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 26 26
27. Follow us on Social Media Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 27 27
28. 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 Copyright © 2021, Oracle and/or its affiliates. All rights reserved. 28 28
29. Merci! Q&R Olivier Dasini MySQL Principal Solutions Architect EMEA olivier.dasini@oracle.com Twitter : @freshdaz Blog : www.dasini.net/blog/en