Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

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

Olivier DASINI

May 05, 2022
Tweet

More Decks by Olivier DASINI

Other Decks in Technology

Transcript

  1. 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

  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

    View Slide

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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  9. Kubernetes
    Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
    Automating deployment, scaling, & management
    of containerized applications
    9
    9

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  16. MySQL Database Service
    Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
    100% Developed, Managed & Supported
    by the MySQL Team
    16
    16

    View Slide

  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

    View Slide

  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

    View Slide

  19. MySQL HeatWave
    MySQL in-Memory Query Accelerator
    Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
    19
    19

    View Slide

  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/

    View Slide

  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/

    View Slide

  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/

    View Slide

  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/

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  27. Follow us on Social Media
    Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
    27
    27

    View Slide

  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

    View Slide

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

    View Slide

  30. View Slide