MySQL Strategy - ITree PDF Free Download

1y ago

42 Views

1 Downloads

1.28 MB

35 Pages

Report/dmca

Download PDF

Transcription

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 2014 Oracle and/or its affiliates. All rights reserved. 2

Driving MySQL Innovation: 2010 - 2014MySQL Enterprise Monitor 2.2Oracle Products CertificationsMySQL Windows ToolsMySQL Cluster 7.1MySQL Windows InstallerMySQL Database 5.6MySQL Cluster Manager 1.0MySQL Enterprise SecurityMySQL Cluster 7.3MySQL Workbench 5.2MySQL Enterprise ScalabilityMySQL Enterprise Monitor 3.0MySQL Database 5.5MySQL Enterprise AuditMySQL Workbench 6.1MySQL Enterprise Backup 3.5MySQL Cluster 7.2MySQL Enterprise Backup 3.11MySQL Cluster Manager 1.3MySQL FabricMySQL UtilitiesMySQL Workbench 6.2MySQL Enterprise Monitor 2.3MySQL Cluster Manager 1.1MySQL Enterprise Backup 3.7MySQL Workbench 6.0All GA!All GA!All GA!MySQL Database 5.7 DMRs*MySQL Cluster 7.4 DMRAvailable Now!Partial List of Releases Delivered*Development Milestone ReleaseCopyright 2014 Oracle and/or its affiliates. All rights reserved. 4

Best Choice for Next Generation Web & Cloud ApplicationsStrong MySQL MomentumWorld’s Most Popular OpenSource DatabaseLeading Open SourceDatabase for WebApplications#1 Open Source Databasein the CloudIntegrated with Hadoop inBig Data PlatformsCopyright 2014 Oracle and/or its affiliates. All rights reserved. 5

Why MySQL Enterprise Edition?In Addition to all the MySQL Features you LoveInsure Your DeploymentsGet the Best ResultsDelight CustomersGetImmediateHelp if/whenNeededIncreaseCustomerSatisfactionMitigate RisksCopyright 2014 Oracle and/or its affiliates. All rights reserved. ImprovePerformance& ScalabilityReduce TCOEnhance Agility &Productivity8

MySQL Enterprise EditionAdvanced Features Scalability High Availability Security Audit EncryptionManagement Tools Monitoring Backup Development Administration MigrationSupport Technical Support Consultative Support Oracle CertificationsCopyright 2014 Oracle and/or its affiliates. All rights reserved. 9

MySQL Enterprise Monitor Start monitoring MySQL in 10 minutes Real-time MySQL performance andavailability monitoring Visually find & fix problem queries Disk monitoring for capacity planning Cloud friendly architecture– No agents required Optional agent option providesadvanced Host/OS monitoringCopyright 2014 Oracle and/or its affiliates. All rights reserved. 11

Enterprise Monitor Dashboard SLA monitoring Real-time performance monitoring Alerts & notifications MySQL best practice advisors"The MySQL Enterprise Monitor is an absolutemust for any DBA who takes his work seriously.”- Adrian Baumann, System SpecialistFederal Office of Information Technology &TelecommunicationsCopyright 2014 Oracle and/or its affiliates. All rights reserved. 12

Enterprise Query Analyzer Real-time query performance Visual correlation graphs Find & fix expensive queries Detailed query statistics Query Response Time index (QRTi)– “Quality of Service” (QoS) measurementfor each query– QoS measurement for a server, group, orevery instance– Single metric for query performance“With the MySQL Query Analyzer, we were able to identifyand analyze problematic SQL code, and triple our databaseperformance. More importantly, we were able toaccomplish this in three days, rather than taking weeks.”Keith SouhradaSoftware Development EngineerBig Fish GamesCopyright 2014 Oracle and/or its affiliates. All rights reserved. 13

Enterprise Replication Monitor Auto-discovers replication topology Master/Slave performancemonitoring Replication advisor"I use the MySQL Enterprise Monitorevery day to monitor and keep tabs onour MySQL databases. Quick one stopshopping for keeping tabs on them.”-Wes Homer,Sr System and Network Administrator Best practice replication adviceCopyright 2014 Oracle and/or its affiliates. All rights reserved. 14

Best Practice Advisors Enforce MySQL best practices 14 Advisor categories 250 Advisors Threshold-based alerts– Exponential moving averages– Rate change detection Expert problem resolution advice"I definitely recommend the MySQL EnterpriseMonitor to DBAs who don't have a ton of MySQLexperience. It makes monitoring MySQL security,performance and availability very easy tounderstand and to act on.”Sandi BarrSr. Software EngineerSchneider ElectricCopyright 2014 Oracle and/or its affiliates. All rights reserved. 15

MySQL Enterprise Backup Online, non-locking backup and recovery– Complete MySQL instance backup (data and config)– Partial backup and restore Direct Cloud storage backups (S3, etc.)Incremental backupsPoint-in-time recoveryAdvanced compressed and encryptionBackup to tape (SBT)Backup validationOptimistic backupsCross-Platform (Windows, Linux, Unix)Copyright 2014 Oracle and/or its affiliates. All rights reserved. 16

MySQL Workbench EE Database migrationsNew! Database Migration Wizardfor SQL Server, Sybase, SQLite, SQL Anywhere & PostgreSQL– From Microsoft SQL Server,PostgreSQL, Sybase ASE, Sybase SQLAnywhere, SQLite, Microsoft Access,and more Manage migration projects Source and target selection Object migration Data migration MySQL version upgradesCopyright 2014 Oracle and/or its affiliates. All rights reserved. 18

MySQL Workbench EE Backup Create and manage backup jobs– Create new backup jobs– Schedule backup jobs to runautomatically– View current backup jobs– View recent backup activity Restore backups– Full, partial, incremental Copyright 2014 Oracle and/or its affiliates. All rights reserved. 20

Oracle Enterprise Manager for MySQL Availability monitoring Performance monitoring Configuration monitoring All available metrics collected– Allowing for custom thresholdbased incident reports MySQL ight 2014 Oracle and/or its affiliates. All rights reserved. 21

MySQL Enterprise Scalability : Thread Pool Provides 20x better scalability Plugin improves sustainedperformance as user connectionsgrowCopyright 2014 Oracle and/or its affiliates. All rights reserved. 23

MySQL Enterprise Security SSL enabled communication Access control– Enterprise authentication (PAM, Windows, LDAP, etc.)– Proxy users Auditing and monitoring– MySQL security advisors– Oracle Audit Vault Oracle Database FirewallCopyright 2014 Oracle and/or its affiliates. All rights reserved. 24

MySQL Enterprise Encryption MySQL encryption libraries– Symmetric encryption AES256– Public-key / asymmetric cryptography Key management– Generate public and private keys– Key exchange methods: RSA, DSA, DH Sign and verify data– Cryptographic hashing for digital signing, verification, & validationCopyright 2014 Oracle and/or its affiliates. All rights reserved. 25

MySQL Enterprise Audit Out-of-the-box logging of connections, logins, and query User defined policies for filtering, and log rotation Dynamically enabled, disabled: no server restart XML-based audit stream per Oracle Audit Vault specAdds regulatory compliance toMySQL applications (HIPAA,Sarbanes-Oxley, PCI, etc.)Copyright 2014 Oracle and/or its affiliates. All rights reserved. 26

MySQL Enterprise Authentication PAM (Pluggable Authentication Modules)– Access external authentication methods– Standard interface (Unix, LDAP, Kerberos, others)– Proxied and non-proxied users Windows– Access native Windows services– Authenticate users already logged into Windows(Windows Active Directory) Pluggable Authentication APIIntegrates MySQL with existingsecurity infrastructures and SOPsCopyright 2014 Oracle and/or its affiliates. All rights reserved. 27

MySQL Enterprise High Availability HA with MySQL Fabric (recommended) Oracle VM Templates for MySQL HA with DRBD and Linux Clustering HA with Solaris Clustering HA with Windows Failover Clustering HA with Oracle Clusterware PluginRange of options to make yourMySQL application deploymentsHighly AvailableCopyright 2014 Oracle and/or its affiliates. All rights reserved. 28

MySQL Enterprise Support Largest MySQL engineering and support organization Backed by the MySQL developers World-class support, in 29 languages Hot fixes & maintenance releases 24x7x365 Unlimited incidents Consultative support Global scale and reachGet immediate help for any MySQLissue, plus expert adviceCopyright 2014 Oracle and/or its affiliates. All rights reserved. 30

MySQL Consultative SupportMake the Most of your Deployments Remote troubleshooting Replication review Partitioning review Schema review Query review Performance tuning .and moreCopyright 2014 Oracle and/or its affiliates. All rights reserved. 31

Work Directly with MySQL Engineering A direct relationship with the MySQL team The ability to participate in:– Product roadmaps– Product betas– Customer advisory boards Work closely with Support Engineers– Resolve issues faster– Request bug and feature request escalationsCopyright 2014 Oracle and/or its affiliates. All rights reserved. 32

MySQL Enterprise Oracle Certifications Oracle Enterprise Manager forMySQL Oracle Linux (w/DRBD stack) Oracle VM Oracle Solaris Oracle Solaris Clustering Oracle Clusterware My Oracle Support Oracle Fusion Middleware Oracle GoldenGate Oracle Audit Vault Oracle Database Firewall Oracle Secure BackupMySQL integrates into your Oracle environmentCopyright 2014 Oracle and/or its affiliates. All rights reserved. 33

Get Started Today!MySQL Enterprise Edition Trialhttp://www.mysql.com/trials/Contact a MySQL Sales Rephttp://www.mysql.com/about/contact/Copyright 2014 Oracle and/or its affiliates. All rights reserved. 34

MySQL Enterprise Oracle Certifications Oracle Enterprise Manager for MySQL Oracle Linux (w/DRBD stack) Oracle VM Oracle Solaris Oracle Solaris Clustering Oracle Clusterware My Oracle Support Oracle Fusion Middleware Oracle GoldenGate Oracle Audit Vault Oracle Database Firewall Oracle Secure Backup