The Future of MySQL What You Need to Know About What’s Coming

1. The Future of MySQL What You Need to Know About What’s Coming Robin Schumacher Sr. Manager Product Management, Database Group robin.schumacher@sun.com Rob Young Sr. Product Manager Database Group rob.young@sun.com

2. Agenda • Server and Products Roadmap • Scale Out - Easing Common Pain Points • MySQL Enterprise Software and Services Roadmap

3. MySQL Product Overview • Community Server • Enterprise Server • Embedded Server • Cluster Carrier-Grade MySQL Server • Query Browser • Administrator • Migration Toolkit • Visual Studio Plug-in • MySQL Workbench (New!) MySQL GUI Tools • JDBC • ODBC • .NET • PHP MySQL Drivers

4. MySQL Enterprise • MySQL Enterprise Server • Monthly Rapid Updates • Quarterly Service Packs • Hot Fix Program • Extended End-of-Life Server • Subscription: • MySQL Enterprise • License (OEM): • Embedded Server • Support • MySQL Cluster Carrier-Grade • Training • Consulting • NRE • Global Monitoring of All Servers • Web-Based Central Console • Built-in Advisors • Expert Advice • Specialized Scale-Out Help Monitor • 24 x 7 x 365 Production Support • Web-Based Knowledge Base • Consultative Help • Bug Escalation Program Support

5. The “What” • Table/Index Partitioning • Row-based/Hybrid Replication • Disk-based Cluster • Built-in Job Scheduler • Problem SQL Identification • Faster full-text Search • Embedded Server (libmysqld) • More… Great for data warehouses Safer and smarter Supports bigger DB’s Simplified task mgmt Easier troubleshooting 500% increases in cases Deeply embedded apps The “When” • RC 5.1.24 available for conference • GA scheduled for end of Q2 2008

6. The “What” • Falcon Engine • New Backup (version 1.0) • Online Add Column • Replication Conflict Detection • Optimizer Enhancements • Better Performance Info Transactional engine Cross engine, non-blocking Cluster only Cluster only Faster subqueries Diagnostics and more The “When” • Alpha available now (with Falcon beta) • GA scheduled for Q4/2008

7. Planned default transactional storage engine. Q4 GA. • Not InnoDB replacement • Most InnoDB app’s OK on Falcon • Leapfrog’s InnoDB on scale out • ACID transactions • Crash recovery • Full MVCC • More features… • Designed to excel on modern hardware platforms. • Planned to beat InnoDB on typical MySQL app.

8. All general engines supported • Backup will be GPL and offer: • SQL-command driven interface • Online, non-blocking DML for Transactional engines • Point-in-time recovery • Blocking backup for other engines • Additional plug-in’s for native online MyISAM backups, compression, encryption, others.

9. New optimizer enhancements • Greatly enhance the speed of certain SQL statements SELECTCOUNT(l_orderkey) FROM lineitem WHERE l_linenumber=1 AND l_orderkey IN (SELECT o_orderkey FROM orders WHERE o_totalprice > 1000 AND o_custkey IN (SELECT c_custkey FROM customer WHERE c_address LIKE 'Le%')); - 99.75% Reduction in Response Time -

10. MySQL 5.1 with disk-based Cluster and Replication for Cluster. • DRBD - more speed plus new verification. • MySQL Cluster 6.2: performance and ease-of-use enhancements. GA: Q1 • MySQL Cluster 6.3: SQL performance enhancements GA: Q2. • MySQL Cluster 6.4: Multi-threaded NDB GA: Q4. • MySQL Cluster 7.0: Windows support, varchar on disk, SQL join improvements. GA: Q1/2009. • LDAP, NDB/J products – GA: Q2

11. MySQL 5.1 with data partitioning • Archive engine improvements in 5.1 • Better optimizations for sub-query performance (6.0) • New Nitro engine available in 5.1 for real-time data warehousing • InfoBright engine for TB-sized data warehousing • New Kickfire MySQL DW appliance • Jaspersoft BI suite

12. High-performance, distributed memory object caching system - speeds up dynamic web applications • Used by vast majority of top web sites • Will now be offered and supported by MySQL under MySQL Enterprise (Q2) • Customers benefit by having: • One vendor • A formal support organization • A formal training and professional service organization Clients Web server with memcached client memcached servers

13. Enterprise Monitor 1.2 with new replication monitoring available now • Enterprise Monitor 1.3 - Japanese localization • MySQL Load Balancer 1.0: MySQL load balancing between MySQL Servers. Q3 Beta; Q4 GA • Enterprise Monitor 2.0 - Query Analyzer: global monitoring of query performance with drill down diagnosis. Q3 Beta; Q4 GA • MySQL Connection Manager 1.0: User connection management for better performance. Q1/2009 GA

14. New Data Modeling/Database Generation tool • Design MySQL databases right the first time • Removes ‘black box’ feel from packaged apps • Two versions – free open source community and paid closed source offering • Advanced features in paid version • Database synchronization, HTML/Text reporting, Rev-engineer from database, and more • Available now

15. Enterprise Customers want global backup management tool • Scale-out presents backup / recovery challenges for many • 44% of Enterprise customers have no skilled DBA staff • Zmanda Recovery Manager for MySQL perfect fit for these shops • Contains capabilities only found in Oracle’s and IBM’s Toolset • Added on to MySQL Enterprise as option

16. 2008 At-a-Glance • MySQL 5.1 GA • Nitro Engine GA • MySQL Workbench GA • MySQL Cluster 6.3 GA • NDB/J, Cluster LDAP GA • Memcached offering • MySQL 6.0/Falcon Beta/RC • Load Balancer Alpha • MySQL 6.0/Falcon GA • MySQL Cluster 6.4 GA • Load Balancer GA • Query Analyzer GA • Connection Manager Alpha • Maria (MyISAM++) • MySQL Cluster 6.2 GA • MySQL5.1 RC • Enterprise Monitor (Japanese) • MySQL Workbench RC • MySQL 6.0/Falcon Beta • Zmanda for MySQL • Load Balancer Beta • Query Analyzer Beta

17. The “What” MySQL 6.x • Foreign Keys • Better Prepared Statements • Better Server-side Cursors • Replication Improvements • Optimizer Enhancements • Online Backup Enhancements • Stored Procedure Changes • Performance Interface All storage engines Prepare any SQL statement Faster/less memory Checksums Faster subqueries Backup catalogs, more Signal/Resignal, more Better perf diagnostics The “When” • Alpha’s, Beta’s begin late-2008 • GA’s expected first part of 2009

18. The “What” • Security Groups/Roles • Transparent Data Encryption • Data Auditing • External Authentication • Online Alter Table • Optimizer Enhancements Easier privilege mgmt Table/Column level For compliance O/S level authorizations Online DDL changes More subquery changes The “When” • Alpha’s, Beta’s begin mid-2009 • GA’s expected end of 2009 “Citadel”

19. Storage Engine Update Third-Party Engines: … All handled through MySQL Alliances Certified Storage Engine Program. DB2

20. InfoBright Data Warehousing Engine • MySQL Provides: • mature connectors, tools, resources • interconnectivity and certification with BI Tools • Management Services and Utilities • Infobright Provides • Load function that compresses data • Column-oriented data storage engine • Knowledge Grid metadata layer that contains information about the compressed data • Otimizer/executor that uses the Knowledge Grid.

21. Kickfire Data Warehousing Appliance • World’s #1 in price/performance • Makes MySQL rock for reporting and queries • Affordable, load-and-go appliance • Scalable from GBs to TBs

22. MySQL Enterprise – What’s Next? Help with scaling your on-line applications!

23. MySQL Enterprise Includes • MySQL Enterprise Server • Most Up to date version of MySQL • Monthly Rapid Updates • Quarterly Service Packs Database • Subscription: • MySQL Enterprise • License (OEM): • Embedded Server • Support • MySQL Cluster Carrier-Grade • Training • Consulting • NRE • MySQL Enterprise Monitor • Global Monitoring of All MySQL Servers • Built-in Advisors, Expert Advice • Specialized Scale-Out Help Monitoring • 24 x 7 x 365 Production Support • Web-Based Knowledge Base • Consultative Help Support

24. Scaling with MySQL Web/App Servers MySQL Replication writes Users/ Customers MySQL Replication reads reads

25. Common Pain Points • Application level load balancing is limited to read/write splitting • Hardware utilization not optimized • Reads directed to latent slaves • Little insight into user/application related activity • “Evil” queries • Slow query log good, but not great • Idle connections on production servers • Consume resources • PHP, Ruby, Perl have no built in connection management • App servers > Db servers = Connection Storm!

26. Adding Value in 2008-09 • MySQL Enterprise will provide… • Upgrade Assistance – Spring 2008 Release! • Load Balancing for Slaves, Reads, Writes, etc. • Identification of poorly performing SQL code • Optimized connection management for online apps (PHP, Perl, Python, Ruby)

27. MySQL Load Balancer • MySQLEnterprise software which can route database queries to the appropriate database in a scale-out environment. • Route/split reads and writes • Use database least behind, least loaded • Remove latent slaves from read rotation • Other distribution algorithms Improves/scales throughput of reads for online applications Helps customers reduce cost of adding slaves

28. MySQL Load Balancer HTTP Load Balancer Web/App Servers MySQL Load Balancer MySQL Servers Clients READ reads MySQL Replication reads reads writes WRITE

29. MySQL Query Analyzer • MySQL Enterprise Monitor feature that allows users to trace, monitor, and analyze MySQL query activity for specific servers, users, and applications. • Adaptive “Evil” query collection/tracing • Historical browsing/analysis • “Needle in a haystack” identification of worst queries • Worst execution times, # of execs, etc. SQL code is the #2 cause of performance issues 97% of those surveyed will use this

30. MySQL Query Analyzer Http Load Balancer Web/App Servers MySQL Query Analyzer Clients MySQL Server Queries in Results • Management • Query Diagnostics • Monitoring Queries in Results MySQL Enterprise Monitor

31. MySQL Query Analyzer

32. MySQL Connection Manager • MySQL Enterprise software that maximizes the efficiency, performance, and scalability of database connections made by online applications. • Comprised of two core features • Connection Pooler • Connection Concentrator • Prevents connection “overload” and “waiting” on database Optimizes throughput of online applications Reduces overhead on production servers

33. MySQL Connection Manager Requests Web/App Tier Connection Manager Database Connection Concentrator Connection Pooler Increased Utilization of Pooled Connections via Multiplexing Transactions onto a Single Connection Reusable Pool of Database Connections 1000’s of Requests

34. Practical Use Cases • MySQL Load Balancer • High traffic, read intensive apps and websites • Application load balancing extension • Enterprise Monitor w/Query Analyzer • Shops with rapid development cycles (test = prod) • Apps with heavy use of dynamic SQL • MySQL Connection Manager • Websites that experience frequent or idle connections • app servers > db servers • developed in language with no built-in connection management

35. MySQL Enterprise Roadmap • Q1-2, 2008 • Monitor 1.3 w/Japanese Localization • New Advisors and Rules (Upgrade Advisor) • Monitoring of 5.1 • Early Adopter Beta Program • Q3-4, 2008 • MySQL Load Balancer • Monitor 2.0 w/Query Analyzer • Monitoring of 6.0 and Falcon • Into 2009 • MySQL Connection Manager

36. MySQL Enterprise at the UC! Monitoring Scale-out with the MySQL Enterprise Monitor Andy Bang (Sun/MySQL) Wednesday, 04/16/2008 5:15pm - 6:00pmBallroom E MySQL Proxy, the Friendly Man in the Middle Jan Kneschke, Jimmy Guerrero (Sun/MySQL) Thursday, 04/17/2008 10:50am - 11:50am Ballroom F • BoF Sessions • MySQL Load Balancer, Query Analyzer, Connection Manager; 7:30 Tuesday, Ballroom E • MySQL Enterprise Monitor w/Query Analyzer; 7:30 Wednesday, Ballroom D • Exhibit Hall • Sun and MySQL booths – information, demos, Gurus, fun stuff!

37. MySQL Enterprise Beta Program beta-enterprise@mysql.com Thanks for attending! robin.schumacher@sun.com rob.young@sun.com