Developing MySQL applications in the Cloud
1 like582 views
This document discusses Oracle's MySQL Cloud Service. It provides an overview of the service's key features, including database administration tools that automate tasks, enterprise-grade backup and recovery, scalability capabilities, high availability options, security features, data access integrations, and management access methods. The service is designed to enable customers to rapidly develop and deploy applications powered by MySQL in a simple, automated, integrated, and enterprise-ready cloud platform.
More Related Content
What's hot (20)
Viewers also liked (7)
Similar to Developing MySQL applications in the Cloud (20)
More from Mark Swarbrick (15)
Recently uploaded (20)
Developing MySQL applications in the Cloud
- 7. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Deploying MySQL in the Cloud • Security & Regulatory Compliance? • Cloud Service Backed by the MySQL Engineering Team? • Expert MySQL Technical Support? • Moving Workloads between On-premises and the Cloud? • Hybrid Deployments? • Integra@on with Oracle Environment? • Cost of Opera@ons? #1 Open Source DB in the Cloud: Various Op:ons, BUT Many Ques:ons... 7
- 9. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | • Simple – Quickly provision MySQL database instances with only a few clicks • Automated – Database management made easy with tools that automate administra@ve tasks • Integrated – Integrated with Oracle Cloud Services for quick development and deployment • Enterprise Ready – Oracle’s proven MySQL Enterprise Edi@on for performance, security & up@me 9 + MySQL Cloud Service Offering MySQL Enterprise Edition
- 11. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | • Increase Business Agility: Focus your resources on innova@on and rapidly deliver new modern applica@ons. • Ensure Security, Performance & Up:me: relying on the most comprehensive MySQL cloud plagorm – straight from the source . • Reduce Total Cost of Ownership: Saving on infrastructure and database management opera@ons costs while improving up@me. MySQL Cloud Service: Business Benefits 11
- 12. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL Cloud Service Overview 12
- 14. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL Cloud Service – Database Administra@on 14 Simple Management Tools Automate Administra:ve Tasks Database Administra:on Automated Provisioning Push Bulon Patching 1-Click Instance Management Enterprise Monitor • Automated Provisioning creates pre-configured MySQL databases op@mized for the chosen instances in minutes • Push BuXon Patching allows administrators to easily test, apply and rollback patches • 1-Click Instance Management controls MySQL instances using Oracle Cloud Console with simple 1-click bulons • MySQL Enterprise Monitor provides real-@me visibility into the performance and availability of your database instances
- 15. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL Cloud Service – Backup & Recovery 15 Enterprise-grade Backup and Recovery Protects Against Data Loss • Automated Backup delivers hot, online, non-blocking backup with compression and high performance, allowing administrators to adjust reten@on periods and backup windows • Point-in-:me Recovery recovers MySQL database instances at chosen dates and @me • On-demand Snapshot allows user-ini@ated full backup Backup & Recovery Automated Backup Point-in-@me Recovery On-demand Snapshot
- 16. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL Cloud Service - Scalability 16 Scale MySQL Instances to Meet Your Varying Workloads Scalability Elas@c Compute Elas@c Storage Enterprise Thread Pool Elas@c Replica@on* • Elas:c Compute scales up or down the compute resources as needed • Elas:c Storage increases block storage for your MySQL instance when the amount of data grows • MySQL Enterprise Thread Pool scales MySQL thread counts as workload and client connec@ons change • Elas:c Replica:on automates adding or removing replicated MySQL instances, distribu@ng workloads dynamically based on demands * Will be available in future releases
- 17. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL Cloud Service – High Availability 17 A Cost-Effec:ve High Availability Solu:on for Business Cri:cal Applica:ons High Availability Replica@on Replica@on Monitor Mul@-AD Support* • Replica:on provides flexible topologies for high availability • Replica:on Monitor offers visibility into the performance, availability and health of all MySQL Masters and Slaves • Mul:-AD Support replicates MySQL instances across different availability domains * Will be available in future releases
- 18. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL Cloud Service - Security 18 Mul:-layered Security Protects Your Data At Rest and In Transfer Security Network Access Control Enterprise Firewall Enterprise Authen@ca@on Enterprise Encryp@on + TDE* Enterprise Audit • Network Access Control provides the flexibility to restrict connec@ons to the MySQL instances • MySQL Enterprise Firewall guards against cyber security threats by providing real- @me protec@on against database specific alacks • MySQL Enterprise Authen:ca:on authen@cates MySQL users by leveraging your exis@ng directory services and security rules • MySQL Enterprise Encryp:on protects sensi@ve data stored in MySQL, backups, or during transfer. MySQL Enterprise Transparent Data Encryp:on provides data at rest encryp@on and secure key management. • MySQL Enterprise Audit provides detailed audit trail to track MySQL access and usage * Will be available in future releases
- 20. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL Cloud Service – Management Access 20 Mul:ple Op:ons to Improve Produc:vity CLI REST API Oracle Cloud Console MySQL Tools • Oracle Cloud Console - A web-based console for managing all of your Oracle Cloud Services • MySQL Enterprise Edi:on Management Tools - Use familiar tools such as MySQL Enterprise Monitor and MySQL Workbench to manage and monitor performance and availability of all your MySQL instances • Oracle Enterprise Manager – Manage your en@re Oracle environment through a ”single pane of glass” • Host Access via SSH – Administra@ve access to the underlying virtual machine allows full control of the instance • REST API – Simple API for managing MySQL instances programma@cally • CLI – Easy to use command line for script-savvy administrators
- 21. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Oracle Premier Support for MySQL + Oracle Cloud Support • Largest MySQL engineering and support organiza@on • Backed by the MySQL developers • World-class support, in 29 languages • Hot fixes & maintenance releases • 24x7x365 • Unlimited incidents • Consulta@ve support • Global scale and reach • Oracle Cloud Support Get immediate help for any MySQL & Oracle Cloud issues, plus expert advice
- 22. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 22 MySQL Cloud Service: Only From Oracle • Oracle’s Proven MySQL Enterprise Edi:on on Oracle Cloud – MySQL Enterprise Edi@on reduces the risk, cost and @me to develop, deploy and manage MySQL applica@ons – Advanced features to achieve the highest levels of MySQL performance, security & up@me – Seamlessly integrated with Oracle Cloud, providing a highly available, scalable, and secure database service • Tight Integra:on with Oracle’s Plaorm-as-a-Service Offerings – Pre-integrated with Oracle’s PaaS offerings such as Java Cloud Service and Applica@on Container Cloud Service for quick applica@on development and deployment • Enterprise Grade Tools – Easy to use management tools for managing both Cloud and Hybrid environments – Best-in Class MySQL management tools, developed by the MySQL Engineering team – Unified Management with Oracle Enterprise Manager: Save @me & avoid cloud silos • Expert MySQL Technical Support – Provided by the Experts, straight from the source – Backed by the MySQL Engineering Team – Single point of contact for support across your en@re cloud infratructure
- 24. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 24 New “Born in the Cloud” MySQL Applica@ons Build new apps relying on the #1 Open Source DB, on Oracle’s enterprise-class cloud Lit & Shit: Migrate Exis@ng MySQL Applica@ons Migrate from on-premises or other 3rd party clouds to ensure security, flexibility & op@mize management Hybrid Cloud Deployments • Easily move workloads between on prem & cloud, using the same DB plagorm • Portability for Mul@-@er architectures (e.g. deployed across both the cloud & on-premises) Dev/Test • Spin up database instances in minutes • Tear down when not needed MySQL Cloud Service: Recommended Use Cases New Apps SaaS Apps powered by MySQL SaaS Applica@ons powered by Oracle’s MySQL Cloud Service for global scalability
- 27. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Dev/Test of MySQL Applica@ons in the Oracle Cloud • Agility: Get immediate access to a MySQL instance to rapidly respond to internal needs and business opportuni@es – For IT and LOBs • Efficiency: Rely on THE SAME database plagorm for Dev/Test and produc@on deployments • Lower TCO: Increase produc@vity with the most comprehensive set of MySQL advanced features, management tools and technical support during development, tes@ng and deployment 27
- 28. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Dev/Test of MySQL Applica@ons in the Oracle Cloud • RAD: Develop your products quickly and allocate resources dynamically: • Patching • Regression tes@ng • New product features • Tes@ng install environments • Load tes@ng • Q&A • Scaling issues • Duplica@ng support environments • Abstrac@ng user data 28
- 31. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Power Curve of MySQL Deployments Ini@al Deployment ‘Nice to Have’ Era Business Value Discovered Business Cri@cal Typical “Bolom up” Adop@on Model Time Cri@cality § Self support not a viable op@on for business cri@cal apps § Security, availability, data protec@on & regulatory compliance risks § Generates database sprawl § Non scalable opera@ng model preven@ng opera@onal efficiency & TCO reduc@on 31
- 32. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | ”Lit & Shit” Your Applica@ons • Enforce Security & Regulatory Compliance • Improve Performance & Availability • Automate Management • Lower Costs Ø Ensure availability and security of business cri@cal applica@ons Ø Decrease TCO through cloud services and improved management Migrate to Oracle’s MySQL Cloud 32
- 34. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Develop New MySQL Applica@ons on Oracle Cloud 34 Pre-integrated with Oracle Cloud Applica:on Development Offerings • Quickly spin up development environment that is pre-integrated with MySQL Cloud Service • Cloud based integrated lifecycle tools for con:nuous integra:on and deployment • Scale your applica:on and MySQL Cloud dynamically based on demand • Unified management across one cloud avoids cloud silos New Apps
- 36. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Hybrid Deployments • Easily move workloads from on premises to the cloud, and vice versa, relying on the same database infrastructure • Mul:-:er architectures including for example a web applica@on front end in the cloud connected to a transac@onal system on-premises • Backup databases to the Cloud, for a simple and cost-effec@ve offsite database backup 36
- 38. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | MySQL: A Proven Plagorm for ISVs • Embedded database for thousands of ISVs and OEMs including Cisco, Symantec, Sage, Check Point...etc • #1 Open Source Database for Web-based applica@ons and highly popular in SaaS: Box, Dropbox, Zendesk, SupplyDynamics...etc And a Natural Choice for SaaS 38
- 39. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | SaaS & eCommerce Applica@ons • Effec@vely Scale SaaS & eCommerce Applica@ons, leveraging the latest MySQL innova@ons • Interna@onalize your business and customer reach through Oracle’s global Cloud infrastructure • Prevent Security Breaches & Ensure Regulatory Compliance • Increase Performance & Up@me • Reduce Costs • Meet Customer SLAs Oracle MySQL Cloud Service Helps SaaS Providers to: 39