Loading in 2 Seconds...
Loading in 2 Seconds...
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. Agenda. MySQL Overview SaaS – Hosting Provider Challenges Solutions for MySQL Next Steps.
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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
Agenda • MySQL Overview • SaaS – Hosting Provider Challenges • Solutions for MySQL • Next Steps
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
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
Established & Emerging Companies Web 2.0 Enterprise 2.0 craigslist SaaS Telecom OEM & ISV
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
Solutions Overview "MySQL and Parallels are exploring ways to help service providers enable SaaS"
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
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
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
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
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
Web/App Servers MySQL Replication – Scale-Out MySQL Replication writes MySQL Replication reads reads
Web/App Servers Scalability: MySQL Partitioning MySQL Partitioning Cust_id 1-999 Cust_id 1000-1999 Cust_id 2000-2999
Web/App Servers Sharding - Application Partitioning Sharding Architecture Cust_id 1-999 Cust_id 1000-1999 Cust_id 2000-2999
Web/App Servers Scalability: Virtualization Virtualization Architecture VM 1 VM 2 VM 3
Web/App Servers MySQL Replication – High Availability MySQL Replication writes Active Servers reads MySQL Replication Standby Server
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
Web/App Servers DRBD Architecture MySQL and DRBD Active Master Synchronous Block Replication Virtual IP Management Passive Master
Web/App Servers MySQL High Availability Scale-Out DRBD + MySQL Replication reads reads Active Master writes Synchronous Block Replication Virtual IP Management Passive Master
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!
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
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
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
Questions? Jimmy Guerrero Sr Product Marketing Manager Sun Microsystems – Database Group firstname.lastname@example.org