1 / 46

The State of the Dolphin

The State of the Dolphin. Philip Antoniades Senior Director Worldwide MySQL Sales Consulting. The State of the Dolphin. Philip Antoniades Senior Director Worldwide MySQL Sales Consulting. Safe Harbor Statement.

nan
Download Presentation

The State of the Dolphin

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The State of the Dolphin Philip Antoniades Senior Director Worldwide MySQL Sales Consulting

  2. The State of the Dolphin Philip Antoniades Senior Director Worldwide MySQL Sales Consulting

  3. Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  4. Agenda • Oracle’s Investment in MySQL • MySQL 5.6 • Recent Product Announcements • Trends & Product Directions

  5. MySQL Makes Sense for Oracle • Complete Solutions • Best of Breed at Every Level • On Premise and in the Cloud • MySQL: Web, Mobile & Embedded

  6. Oracle Database and MySQLComplementary • Together servicing broader user needs • MySQLwell suited for Web-based & mobile apps, custom departmental apps and embedded apps • Customers benefit by running MySQL and Oracle together Enterprise Applications (ERP, CRM, SCM…etc) Custom & Departmental Enterprise Applications Apache Glassfish Datamarts & Analytics MySQL Large OLTP Applications Small to Medium OLTP Applications

  7. ORACLE DRIVES MySQL INNOVATION MAKING MySQL BETTER EVERY DAY DELIVERING MORE BETTER PRODUCTS FASTER

  8. Oracle Significantly Invests in MySQL In a Unique Position to Deliver EXPERTISE & RESOURCES INNOVATION & ROADMAP PROFESSIONAL ENGINEERING

  9. Hundreds of MySQL development engineers, support experts and consultants, including original architects of the server, InnoDB and MySQL Cluster Investing and growing the team BY FAR, THE LARGEST DEVELOPMENT TEAM IN MySQL’S HISTORY

  10. MySQL Cluster 7.2 MySQL Cluster Manager 1.4 MySQL Utilities 1.2 MySQL Migration Wizard MySQL Enterprise Backup 3.8 MySQL Enterprise Audit MySQL Database 5.6 MySQL Cluster 7.3 MySQL Database 5.7 DMR MySQL Applier for Hadoop (Labs) More and Better Products MySQL Enterprise Backup 3.7 Oracle VM Template for MySQL Enterprise Edition MySQL Enterprise Oracle Certifications MySQL Windows Installer MySQL Enterprise Security MySQL Enterprise Scalability MySQL Enterprise Monitor 2.2 MySQL Cluster 7.1 MySQL Cluster Manager 1.0 MySQL Workbench 5.2 MySQL Database 5.5 MySQL Enterprise Backup 3.5 MySQL Enterprise Monitor 2.3 MySQL Cluster Manager 1.1 All GA! All GA! MySQL Database 5.6 DMR* MySQL Cluster 7.2 DMR MySQL Labs! (“early and often”) All GA! Available Now! 2010 2012-13 *Development Milestone Release 2011

  11. Driving Innovation AND Quality • 191 Worklogs for MySQL 5.6 • 1667 Bugs Fixed in 5.6 • 2909 Bugs Fixed in Total Since MySQL 5.5 GA • 911 New MTR Tests in MySQL 5.6 • TripledQA Team - 400 Man/Year Database QA Experience

  12. MySQL 5.6: Best Release Ever!

  13. MySQL5.6: Scalability • Users can fully utilize latest generations of hardware and OS • Scales as data volumes and users grow

  14. MySQL 5.6 SysBench Benchmarks MySQL5.6 MySQL5.5 Up to 234% Performance Gain

  15. MySQL 5.6: InnoDB

  16. MySQL 5.6: InnoDB NoSQL Key Value Access to InnoDB • Same app can leverage: • Key-value access to InnoDB via familiar Memcached API • SQL for rich queries, JOINs, FKs, etc. • Fully transactional • Up to 9x performance boost for updates • Great for fast data ingestion in Big Data pipeline

  17. MySQL 5.6: Optimizer

  18. MySQL 5.6: Best Replication Features Ever

  19. New Instrumentation Statements/Stages Table and Index I/O Table locks Users/Hosts/Accounts Network I/O MySQL 5.6: Performance Schema • NewFeatures • Show contents of Host cache • New Summary tables • Easier configuration • Start up defaults in my.cnf • Auto tune • Reduced overhead • On by default [mysqld] performance_schema=on • Provides user/session level stats on resource usage for Cloud-based consumption/reporting/charge back

  20. RECENT PRODUCT ANNOUNCEMENTS

  21. Auto-Installer • NoSQL JavaScript for node.js • Foreign Key Support • Connection Thread Scalability • MySQL 5.6

  22. MySQL Cluster: Overview HIGH SCALE, READS + WRITES 99.999% AVAILABILITY LOW TCO SQL + NoSQL REAL-TIME • Auto-Sharding, Multi-Master • ACID Compliant, OLTP + Real-Time Analytics • Shared nothing, no Single Point of Failure • Self Healing + On-Line Operations • Open Source + Commercial Editions • Commodity hardware + Management, Monitoring Tools • Key/Value + Complex, Relational Queries • SQL + Memcached + JavaScript + Java + JPA + HTTP/REST & C++ • In-Memory Optimization + Disk-Data • Predictable Low-Latency, Bounded Access Time

  23. Who’s Using MySQL Cluster?

  24. Brings MySQL Cluster to a broader range of workloads Packaged apps, custom projects Adds powerful functionality while reducing complexity App logic & data model Enabled by default Enforced for SQL & NoSQL APIs On-line add and drop MySQL Cluster 7.3: Foreign Keys

  25. Fast configuration Auto-discovery Workload-optimized MySQL Cluster: Auto-Installer

  26. Native JavaScript access to MySQL Cluster End-to-End JavaScript: browser to the app and database Storing and retrieving JavaScript objects directly in MySQL Cluster Eliminate SQL transformation Implemented as a module for node.js Integrates full Cluster API library within the web app Couple high performance, distributed apps, with high performance distributed database MySQL Cluster 7.3: JavaScript Connector for node

  27. MySQL Cluster 7.3: MySQL 5.6 Support • Select storage engine for each table in the app (InnoDB is the default) • InnoDB: Large Rows, DSS Queries, FTS • MySQL Cluster: Auto-sharding, real-time, HA • Uses latest MySQL 5.6 Server • Enhanced Optimizer • Crash-safe Geo-Replication • Replication Checksums InnoDB Local InnoDB Tables MySQL Cluster NDB Storage Engine

  28. MySQL Cluster 7.3: Connection Thread Scalability • Increases throughput of each connection to the data layer • More client threads can use each connection by splitting mutexes • Reduces configuration complexity • Increases cluster scalability • Each connection consumes one of 256 node ids • Up to 7.5x higher performance per connection • SQL & NoSQL interfaces With Connection Thread Scalability MySQL Cluster Data Nodes MySQL Cluster Data Nodes

  29. Scalability demands Sharding for write performance? Latency demands Cost of each millisecond? Uptime requirements Cost per minute of downtime? Failure versus maintenance? Application agility Developer languages and frameworks? SQL or NoSQL? When to Consider MySQL Cluster

  30. 1st DMR MySQL 5.7.1 Available Now! dev.mysql.com • Support for stacked diagnostic areas according to the SQL standard • Replication improvements: • Non-blocking ‘SHOW SLAVE STATUS’ – useful for monitoring tools • Idempotent mode of operation for MySQL Server, where the server will ignore errors while applying row-based events in a binlog file • Added –rewrite-db option to mysqlbinlog so an RBR log can be replayed to a different database name

  31. 1st DMR 1st DMR MySQL 5.7.1 Available Now! dev.mysql.com • Online RENAME INDEX • Online enlarge VARCHAR size • Improved InnoDBtemporary table DDL performance to get it on par with or even better than MyISAM • Introduced InnoDB table space for temporary (non-compressed) tables • Fixed long-standing bug#6295 – “Triggers are not processed for not null columns”

  32. MySQL in the Big Data Lifecycle

  33. MySQLHadoop Applier Labs • Real-time replication of events from MySQL to Hadoop • Supports move towards “Speed of Thought” analytics • Connects to the binary log, writes events to HDFS via libhdfs library • Each database table mapped to a Hive data warehouse directory • Enables eco-system of Hadoop tools to integrate with MySQL data • See dev.mysql.com for articles • Available for download now • labs.mysql.com

  34. TRENDS & PRODUCT DIRECTIONS

  35. Mobile Internet Booming Strong demand for web & mobile apps/services accessible 24/7 from mobile devices Organizations creating, deploying and utilizing Web apps faster and in greater numbers than ever before

  36. UBIQUITOUS IN THE CLOUD

  37. Big Data Adoption 90% Fortune 500 companies with Pilot Projects at end of 2012 • Web Recommendations • Sentiment Analysis • Marketing Campaign Analysis • Customer Churn Modeling • Fraud Detection • Research and Development • Risk Modeling • Machine Learning Poor Data Costs 35% in Annual Revenues 10% Improvement in Data Usability Drives $2bn in Revenue • Source: http://wikibon.org/blog/big-data-statistics/

  38. ORACLE MAKES MySQL BETTER FOR THE WEB, THE CLOUD & BIG DATA • Performance & Scale-Out • High Availability, Self-Healing & Data Integrity • Provisioning, Monitoring & Resource Management • Developer Agility • Security

  39. MySQL Enterprise Edition • Highest Levels of MySQL Scalability, Security and Uptime Oracle Premier Lifetime Support Oracle Product Certifications/Integrations MySQL Enterprise Security MySQL Enterprise Monitor/Query Analyzer MySQL Enterprise Audit MySQL Enterprise Backup MySQL Enterprise Scalability MySQL Enterprise High Availability MySQL Workbench

  40. Reaching Out to the Community In the Past Year: • Grown Community team • Sponsored @Velocity China, ADC and DTCC • Delivered over 20 talks at events • Dozens of Seminars, Workshops and User Groups • Blogs & social media • MySQL Chinese Webcast

  41. Concluding Thoughts • Oracle Invests in MySQL like Never Before • Oracle Drives MySQL Innovation • Oracle Makes MySQL Better for Next Generation Web, Cloud and Big Data Applications

  42. Oracle Sessions @ OOW • MySQL Enterprise Edition and Oracle Product Integrations Thursday, Jul 25, 12:00 - 13:00 - Expo Centre - Room 509 • Optimizing Security, Performance, and Availability with MySQL Enterprise Edition Thursday, Jul 25, 09:00 - 10:00 - Expo Centre - Room 503/505 • Database DevOps with MySQL 5.6 GA, Flyway, and Hudson Thursday, Jul 25, 10:15 - 11:15 - Expo Centre - Gold Hall • MySQL Demo Pod at Exhibition Hall

  43. San Francisco, September 21-23 Additional Day of Tutorials Oracle.com/mysqlconnect • Keynotes • Conferences Sessions • Birds-of-a-feather sessions • Tutorials • Hands-on Labs • Exhibition Hall • Demo Pods • Receptions Graphic Section Divider Register Now

More Related