MySQL Enterprise for SaaS and Managed Hosting Providers

1. May 19-20 l Washington, DC l Omni Shoreham MySQL Enterprise for SaaS and Managed Hosting Providers Jimmy Guerrero Sr Product Marketing Manager, Sun Microsystems – Database Group

2. Agenda • MySQL Overview • SaaS – Hosting Provider Challenges • Solutions for MySQL • Next Steps

3. Sun: The World's Largest CommercialOpen Source Contributor Database Platform Application Infrastructure Java Enterprise System Composite Application Platform Virtualization Sun xVM Operating System Partners Architecture

4. About MySQL 12 years old 400+ employees 750 partners 60K downloads/day Customers across every major operating system, hardware vendor, geography, industry, and application type Leadership * Innovation * Market Acceptance

5. Established & Emerging Companies Web 2.0 Enterprise 2.0 craigslist SaaS Telecom OEM & ISV

6. SaaS & MHP Provider Challenges • Delivering on SLA’s • Uptime & availability • Application performance & responsiveness • Rapid, frequent & iterative feature releases • On-demand scalability • Integration & customization limitations • Reduce infrastructure costs • Compliance, identity & access management • Security of online & offline data • Technical competence & knowledge • Proactive monitoring

7. Solutions Overview "MySQL and Parallels are exploring ways to help service providers enable SaaS"

8. Benefits of Open Source and LAMP • LAMP software stack running on COTS hardware lowers initial startup costs • Perfect for on-demand Scale-Out environments • Open Source freedom and no vendor lock-in Scale-Up Scale-Out vs

9. MySQL Enterprise Enterprise database and monitoring software, plus production support delivered in an annual subscription MySQL Enterprise MySQL Enterprise Server MySQL Enterprise Monitor 24x7 Production Support MySQL Enterprise Unlimited Deploy and monitor an unlimited number of servers for the price of a single CPU of Oracle

10. Why MySQL Enterprise? • Deliver on SLAs • Increase availability • Optimize performance • Effectively monitor scale-out environments • Faster time to launch • Develop & deliver on proven open source components • Keep costs predictable

11. MySQL Enterprise Monitor • Consolidated view of entire MySQL environment • Auto discovery of MySQL Servers & replication topologies • Over 100 customizable rules for monitoring and alerting • Identifies problems before they occur • Reduces risk of downtime • Improve delivery of SLAs • Scale-out with less DBAs

12. On-Demand Scalability for MySQL MySQL Replication • Designed for on-demand read scalability • Cost-effective alternative to Scale-Up • Asynchronous replication • Statement or row-level replication support • No special networking components • Fully-supported via MySQL Enterprise subscription • Enterprise Monitor discovers and monitors replication topologies

13. Web/App Servers MySQL Replication – Scale-Out MySQL Replication writes MySQL Replication reads reads

14. Web/App Servers Scalability: MySQL Partitioning MySQL Partitioning Cust_id 1-999 Cust_id 1000-1999 Cust_id 2000-2999

15. Web/App Servers Sharding - Application Partitioning Sharding Architecture Cust_id 1-999 Cust_id 1000-1999 Cust_id 2000-2999

16. Web/App Servers Scalability: Virtualization Virtualization Architecture VM 1 VM 2 VM 3

17. Web/App Servers MySQL Replication – High Availability MySQL Replication writes Active Servers reads MySQL Replication Standby Server

18. High Availability for MySQL Distributed Replicated Block Device (DRBD) • Runs over standard IP networks • Distributed storage • Similar to network RAID • Synchronous replication • No special networking components • Excellent performance (blocks vs. rows of data) • Manages inconsistencies of data during a failure • Hides the complexity of many recovery actions • Linux heartbeat manages fail over and virtual IPs • Fully-supported add-on to MySQL Enterprise subscription

19. Web/App Servers DRBD Architecture MySQL and DRBD Active Master Synchronous Block Replication Virtual IP Management Passive Master

20. Web/App Servers MySQL High Availability Scale-Out DRBD + MySQL Replication reads reads Active Master writes Synchronous Block Replication Virtual IP Management Passive Master

21. 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!

22. MySQL Load Balancer MySQL software which can route database queries to the appropriate database in a scale-out environment. • Intelligently route reads across slaves • 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

23. 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

24. MySQL Query Analyzer

25. NEW! MySQL Workbench • 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. Paid edition $99

26. Questions? Jimmy Guerrero Sr Product Marketing Manager Sun Microsystems – Database Group jimmy@mysql.com