MySQL Cloud Service Overview

Transcription

MySQL Cloud Service OverviewMandy PangPrincipal Product ManagerCopyright 2016, Oracle and/or its affiliates. All rights reserved.

Safe Harbor StatementThe following is intended to outline our general product direction. It is intended forinformation purposes only, and may not be incorporated into any contract. It is not acommitment to deliver any material, code, or functionality, and should not be relied uponin making purchasing decisions. The development, release, and timing of any features orfunctionality described for Oracle’s products remains at the sole discretion of Oracle.Copyright 2017, Oracle and/or its affiliates. All rights reserved.

Program Agenda1MySQL Cloud Service Overview2Use Cases3SummaryCopyright 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted3

Oracle Cloud tegratedOpenHybridData ManagementAnalytics and Big DataApplication DevelopmentContent & ExperienceEnterprise IntegrationIdentity & SecurityData IntegrationSystems ManagementBuilt on High Performant Oracle Cloud InfrastructureCopyright 2018,2017, Oracle and/or its affiliates. All rights reserved. Oracle Cloudat CustomerYourDataCenter4

Oracle MySQL Cloud Service The #1 Open Source Database available in Oracle CloudSimple, automated, integrated & enterprise-readyOnly public cloud integrating MySQL Enterprise EditionRapidly, securely and cost-effectively develop & deploymodern MySQL-based applicationsCopyrightCopyright .affiliates.AllAllrightsrightsreserved.reserved. 5

Business TransformationTransform on-premise CRM and ERPproducts to a SaaS-based solutionSolutionOracle Cloud Platform―MySQL Cloud Service,Compute, StorageSecure & CompliantEnterprise-grade security, monitoring and auditingfor protecting customer corporate dataExpand SalesReduced time to marketQuick global reach to geographicdiverse customers6

Oracle MySQL Cloud ServiceA database service designed for both DBAs and DevelopersFull Control withShell AccessSupport ALL MySQLEnterprise EditionFeaturesSelf-service Provisioning,Cloning & SnapshotANDAutomatedScaling100%AutomatedDBA, PatchingAutomatedHigh Availability*Automated BackupIntegrated withOracle Cloud* Will be available in future releasesCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Flexible Deployment OptionsSame Standards, Same Software, Unified ManagementOracle Cloud MachineCUSTOMERDATA CENTERCloudmachineHybridOracle CloudORACLE CLOUDFIREWALLHybrid CloudOn Premises Oracle Cloud operated anddelivered as a service behindyour firewall Same MySQL Cloud Servicetechnology, same updates asOracle Cloud Conforms to regulatory,privacy, legal and businessrequirementsOracle Cloud Move workloads between onpremises and Oracle Cloud Migrate existing MySQLapplications Keep control over businesscritical systems Build cloud native MySQLapplications Oracle Enterprise Manager &MySQL Enterprise Tools forunified management Same programming languagessupport as on-premise Infrastructure choices acrossvarious Oracle CloudInfrastructure servicesCopyright 2017, Oracle and/or its affiliates. All rights reserved. 8

Program Agenda1MySQL Cloud Service2Use Cases3SummaryCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Journey to the CloudMoveWorkloadsto the CloudCloud oud PlatformDisasterRecoveryin the CloudOn-PremOperationsCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Disaster Recovery in the CloudCommon Use CasesCloud BackupWarm DR SiteHot DR SiteCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Disaster Recovery - Options Cloud Backup– Store MySQL backup toOracle Storage Cloud MySQL Cloud Service as DRSite– Active – Standby (Warm DR)– Active – Active (Hot DR)Copyright 2018, Oracle and/or its affiliates. All rights reserved.

Disaster Recovery - Backup to Storage Cloud ServiceStore Backups to Cloud using MySQL Enterprise BackupMySQL EnterpriseBackupOn-Premises MySQLNo CAPEX withlow OPEXEliminate tapecostsBackup dataalways availableIncrease datadurabilityData lossdepends on lastbackupRecovery ormigration tocloudRecoveryBackup in the cloud Bursting during failoversCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted13

Disaster Recovery - Backup to Storage Cloud ServiceStore Backups to Cloud using MySQL Enterprise BackupCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted14

Disaster Recovery – Recover to MySQL Cloud ServiceRecover MySQL Database in Minutes from Backup stored in Storage Cloud Create new instance inminutes– Pre-loaded with existing datafrom backup– Provisioned with MySQLEnterprise Monitor– Optimized configurationCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted15

Disaster Recovery – Warm DR to MySQL Cloud ServiceSetup a MySQL Slave in the Cloud using MySQL ReplicationTest/DevNo CAPEX withlow OPEXInstant DR to thecloudIncrease dataavailability anddurabilityReducedowntime withplannedupgradesOffload backup,test/dev tasksBursting duringfailoversMySQL ReplicationBackupOn-Premises MySQL(Master)MySQL Cloud Service(Slave) Bursting during failoversCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted16

Disaster Recovery - Warm DR to MySQL Cloud ServiceSimple way to setup disaster recovery site through Oracle Migration Service (OMSP)On-PremiseMySQLMaster DBOracle MigrationService PlatformOracle MySQLCloud ServiceSlave DBMySQLReplicationOnce the setup is done, OMSP is not required for the continuousoperation of replication for the MySQL DR and backupCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted17

Disaster Recovery – Hot DR to MySQL Cloud ServiceSetup Active Database in the Cloud using GoldenGate Cloud ServiceTest/DevGoldenGateBackupGGCSNo CAPEX withlow OPEXInstant DR to thecloudZero Data LossZero applicationoutageIncrease dataavailability anddurabilityZero downtimewith plannedupgradesOffload backup,test/dev tasksOffload realtime queries,live reportingReal-time queries Live reportingOn-Premises MySQLMySQL Cloud Service Bursting during failoversCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted18

Disaster Recovery - GoldenGate Cloud ServiceRobust Real-time Data Replication platform for CloudKey FeaturesGGCSBig Data Cloud ServiceGoldenGateMySQL Cloud ServiceDeliverRoutePumpTrailGGCSCapture Consistent user experience with the coreOracle GoldenGate technology Replication in Hybrid Cloud - From OnPremise to Cloud, Cloud to Cloud and Cloudto on-Premise No Data Loss Real-time Data Delivery Built-in monitoring and alertingMySQL Cloud ServiceGGCSDatabaseCloud ServiceExadata Cloud ServiceCopyright 2018, Oracle and/or its affiliates. All rights reserved.19

Create Dev/Test Environment in the CloudCommon Use CasesRecreate Production Workloads in CloudCloud Native Dev/TestCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Dev/Test – Using MySQL Cloud ServiceApplication DevelopmentCreate Dev/Test EnvironmentPolyglotRecreate on-premiseMySQL databasein cloud in minutes12 Factor AppsDataManagementPre-integratedService BindingCreate snapshotsCreate Dev/TestEnvironment fromsnapshotsCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted21

Dev/Test - Oracle Solution for Cloud Native ApplicationsDeveloperPolyglotMobileServerlessCICD for Apps12 Factor AppsBots & Analyticsf(x)Management &SecurityAPMLogsPolyglot FunctionAny FrameworkDiagnosticsData ManagementAPI PlatformExadataRACDataguardPluggable yHigh Performance/Secure IaaS (Bare Metal, Virtualized, Dedicated, Cloud@Customer)Copyright 2018, Oracle and/or its affiliates. All rights reserved. UserProvisioning

Move Workloads to the CloudCommon Use CasesLift and ShiftHybrid DeploymentDatabase Consolidation/StandardizationCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Move Workloads to the Cloud - Lift & ShiftMigrate workloads to Oracle CloudORACLEPUBLIC CLOUDIaaS ationsSaaS aSMySQLCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Oracle Migration Service Platform (OMSP)Easily and Quickly Migrate your On-Premise MySQL to Oracle MySQL Cloud ServiceCurrent SupportTarget CustomersMigration ScenariosKVMEnd customers whointend to useKVMMySQL Cloud but have NO orLimited DBA experience.AWS MySQLOMSPOracle CloudOn-PremiseMySQLIn addition, the service alsoempower MySQL Cloud as DisasterRecovery and BackupDB for OnJAVAJAVAPremiseMySQL DBMySQL version 5.0 Data size up to 50 GBSingle Node ConfigurationInnoDB, MyISAM SupportCompression Transmission SupportDBA Expertise Now Automated !!Enter the SourceDB and MySQLCS parametersPreMigrationChecksReady sourceto migrateMove sourcedata toMySQLCSPostMigrationChecksEnd to End Fully Automated ProcessCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted12

Oracle Migration Service PlatformFor Migration, Disaster Recovery and BackupMigrationDisaster Recovery and BackupAWSMySQLOracle MigrationService PlatformOracle MySQLCloud ServiceOn-PremiseMySQLMaster DBOracle MigrationService PlatformOracle MySQLCloud ServiceSlave DBMySQLReplicationOnPMySQLOnce the setup is done, OMSP is not required for thecontinuous operation of replication for the MySQL DRand backupCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Move Workloads to the Cloud – Hybrid DeploymentsSame Standards, Same Software, Unified ManagementHybrid Deployment usingOracle Cloud MachineCUSTOMERDATA CENTERCloudmachineORACLE CLOUDHeterogeneous Deployment usingOracle GoldenGate Cloud ServiceGoldenGate Cloud Service3rd Party CloudOracleand -timeData DeliveryHybrid CloudOn PremisesOracle CloudCopyright 2018, Oracle and/or its affiliates. All rights reserved. Global LiveReportingDatabase Migration to CloudQueryOffloadingQuery & Live ReportOffloading to CloudOperationalEfficiencyLive Developmentand Testing in Cloud

Move Workloads to the Cloud –MySQL Standardization Operational ChallengesIT/DevOps“We don’t know the numberof MySQL databasesdeployed in theorganization”“Lack of the ability to chargeback to our customers for thedatabase administrationservices”“Large variety of versionsand patch level of MySQLdatabases being used”“Lack of enforcement ofenterprise level security andcompliance standards todeployed MySQL databases”Copyright 2018, Oracle and/or its affiliates. All rights reserved.28

Move Workloads to the Cloud –Operational Benefits of MySQL Cloud ServiceFast Access andUnified UserExperience to NewCapabilitiesSimplifiedEnvironment forMinimalMaintenance Automatedpatching, upgrades,updates Infrastructurelayers completelymaintained for youFeaturesVersionsOptionsWeb UI, REST API,CLIAbility toEvaluate andTest Without impact tothe existingenvironmentsEnterprise LevelSecurity andComplianceCentralized DBManagement andMonitoring MySQL EnterpriseSecurity and Auditcapabilities MySQL EnterpriseMonitor for alldeployments Faster certificationof new releaseupgradesCopyright 2018, Oracle and/or its affiliates. All rights reserved. Usage report onindividual instancesfor chargeback29

Create Cloud Native ApplicationsCommon Use CasesCloud Native MySQL ApplicationsCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Cloud Native Applications –Oracle Cloud Platform for Application DevelopmentEnables all development use ctsMONITOR & MANAGECopyright 2018, Oracle and/or its affiliates. All rights reserved. 31

Cloud Native Applications –Create Cloud Native MySQL ApplicationsDrive Business Transformation with Database and Platform ModernizationORACLEPUBLIC CLOUDPaaS ationsSaaS ApplicationsMiddlewareApplication PlatformJavaApplication ContainerDatabaseDatabasePaaSMySQLCopyright 2018, Oracle and/or its affiliates. All rights reserved. Container

Program Agenda1MySQL Cloud Service2Use Cases3SummaryCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted33

MySQL Cloud Service: Only From OracleMySQL Enterprise Editionon Oracle CloudIntegration into OracleCloud EnvironmentEnterprise GradeManagement ToolsHybrid Deployments acrossCloud & On-premisesExpert MySQLTechnical SupportCopyright 2018, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted34

Innovate with Oracle MySQL Cloud Service Rapid experimentation, with a low cost of failure More successful products, through rapid iterations with customers Accelerated time to market Improved operational efficiency & reduced costs, driven by automation Increased collaboration, resulting from a DevOps philosophyCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Learn More @ cloud.oracle.com/mysqlSign up today with 300 free credit@https://cloud.oracle.com/mysqlCopyright 2018, Oracle and/or its affiliates. All rights reserved.

Disaster Recovery -Recover to MySQL Cloud Service Create new instance in minutes -Pre-loaded with existing data from backup -Provisioned with MySQL Enterprise Monitor -Optimized configuration Confidential -Oracle Internal/Restricted/Highly Restricted 15 Recover MySQL Database in Minutes from Backup stored in Storage Cloud