Continuous Availability and Scale-out for MySQL with ScaleBase Lite & Enterprise (Webinar Dec 17 2014)
Download as pptx, pdf1 like449 views
Continuous Availability and Scalability with ScaleBase Lite and ScaleBase Abstract: Business are driven by data and processes. Ensuring databases availability during unexpected outages, continuous operations during maintenance and webscale scalability – are keys for major positive impact on businesses. ScaleBase and ScaleBase Lite distributed database management systems ensure business continuity during unexpected and expected outages with automated failover and failback capabilities, enabling five-nines of availability (99.999%). Additional functionalities, such as load balancing and data distribution further increase performance and throughput capacity for more users and more data management. This webinar will review and discuss: 1. The lifecycle and the challenges of webscale databases 2. Availability challenges in public, private and hybrid clouds 3. Introduction to ScaleBase Lite – instant and transparent MySQL Scale-out by intelligent load balancing (read/write splitting) and continuous availability 4. Scale further with ScaleBase – Massive scale out to distributed database containing 10s and 100s of servers (Webinar Dec 17 2014)
More Related Content
What's hot (20)
Viewers also liked (20)
Similar to Continuous Availability and Scale-out for MySQL with ScaleBase Lite & Enterprise (Webinar Dec 17 2014) (20)
More from Vladi Vexler (14)
Recently uploaded (20)
Continuous Availability and Scale-out for MySQL with ScaleBase Lite & Enterprise (Webinar Dec 17 2014)
- 1. Continuous MySQL Availability and Scalability ScaleBase Lite and Enterprise December 17, 2014
- 2. 2 Agenda • App and Database Lifecycle • Continuous High Availability • Quick & Simple Scale Out – R/WR splitting – Load balancing – Data distribution – Data usage analytics • Demo • Q & A – Please enter your questions on the GTW side panel
- 3. 3 Vladi Vexler Vice President, Technology and Product Marketing Over 15 years experience in software development and product management within cloud, web and enterprises. Author of patents in field of databases innovation, dynamic data caching and machine learning analytics.
- 4. 4 Application and Database Lifecycle Tasks Develop Reliable, Fast and Scalable Apps Deploy and Operate in High Availability mode Scale Out/Up Load and Data Maintain and Optimize
- 5. 5 Challenges Time = key resource: Dev, Admin, Time-to-market, Down/Up time Complexity: Growing mix of apps and their relations: OLTP, BI, Ops Innovation with Reliability: Retain tools, skills & functionality Flexible and Resource Efficient: Costs, Time, Tools, DevOps Application and Database Lifecycle Challenges
- 6. 6 Web-scale (Application) Challenges Availability Scalability Performance Operational More Users More Data More Transactions More Connections More Everything…
- 7. 7 Scale Out (Database) Challenges • Cloud infrastructure (Amazon EC2 & RDS) – Provides tools for easy launch of new EC2/RDS instances – Does not manage load balance, distribute or aggregate data • Do-it-yourself approach – Requires a major development effort – Complexity escalates over time – Maintenance (patches, updates, etc.) • NoSQL – Not Relational – Reliability: ACID vs BASE – Requires major redesign – Interoperability issues to meet various apps and business needs
- 8. 8 ScaleBase enables scalability and availability, while increasing effectiveness and efficiency at all lifecycle stages Application and Database Lifecycle
- 9. 9 Who Are We? Distributed Database Management System Architected for the Cloud Simple. Distributed. Powerful.
- 11. 11 Continuous Availability • High Availability – Ability to avoid unplanned outages by eliminating single points of failure • Continuous Operation – Ability to avoid planned outages, including maintenance, SW and HW upgrades • Continuous Availability: High Availability + Continuous Operation Availability Downtime per year 99.9% 8:45 hours 99.99% 1 hour (52 min) 99.999% 5 minutes The average Fortune 500 company loses 80+ hours a year to downtime, costing companies up to $5 billion a year!
- 12. 12 MySQL Continuous Availability with ScaleBase • Your part: N+1 replicated MySQL nodes (MySQL Replication, Galera, Tungsten, Percona) • ScaleBase Lite: – Smart Automatic Failover – Short Failover Time: 5-10 seconds – Continuous Operations: – Smart connection management: no connection errors during failover – Reads re-routed to replicas; Writes held temporarily until complete failover – Manual Failover and Failback for zero downtime at maintenance – Transparent to application. Simple to deploy and manage
- 13. Scaling out
- 14. 14 Quick Scale Out Medium scale needs Multiple database replicas performing load balancing with read/write splitting Techniques for MySQL scalability Massive Scale Out High scale needs Complete distributed database environment, with policy-based data sharding/distribution
- 15. 15 ScaleBase Lite: Quick Scale Out and HA • Empowers reliable MySQL (InnoDB, MariaDB, Percona, RDS) • Intelligent load balancing via read/write splitting • Continuous high availability • Deploys in minutes • Connect/disconnect nodes on the fly • Retains existing MySQL ecosystem (tools, skill sets, etc.), while preserving full MySQL functionality (ACID/SQL)
- 16. 16 Extends Throughput Capacity AWS recommends: “Scale out your data across multiple DB instances!”
- 17. 17 Extends Throughput Capacity AWS recommends: “Scale out your data across multiple DB instances!”
- 19. 19 Architecture
- 20. 20 Effective Data Distribution Is Not Easy Data relationships are extremely complex
- 21. 21 ScaleBase Analysis Genie Brings Order to the Chaos Understanding and mapping complex relationships
- 22. 22 ScaleBase Analysis Genie • Advanced analytics – Your schemas, data & queries • Auto identification of best data distribution policy – Customized for even the most complex apps • Complete policy control • Quality assurance – Review before production • Simulation of results – “What-if” analysis
- 23. Demo
- 24. 24 ScaleBase Lite Demo Environment • Continuous availability with automatic failover • Scale out load with read/write splitting ScaleBase Management Console Application (Linux)
- 25. Summary
- 26. 26 In The Cloud: Amazon & Rackspace “We welcome ScaleBase to AWS Marketplace with their Distributed Database Platform. Customers with growing application and MySQL database requirements can benefit from migrating to a scalable, virtualized deployment on the cloud.” Terry Hanold VP, Cloud Commerce, AWS “The Marketplace is designed to help solve many of the problems with moving businesses to cloud, such as migrating a growing database. Rackspace customers migrating apps to the cloud can leverage a solution that distributes a single MySQL database into smaller, more manageable ones.” John Engates CTO, Rackspace
- 28. 28 Customer: Million+ User Online Gaming Company Who: • Mobile gaming company expanding globally • Hosted on SoftLayer cloud in Hong Kong Problem: • Over a million downloads - peak period overload • Needed scaling in place for expansion Alternatives considered: • Manually sharding/open source tools • Other commercial solutions were too costly Solution: • Up and running within a few weeks of initial download • Now supporting hundreds of thousands of daily users • Fully operational using data distribution and anticipating additional scale out within next quarter
- 29. 29 Scale out to unlimited users Continuous availability Dynamic workload optimization Fast and simple deployment Easily scale out a single MySQL instance Optimized for the Cloud Reduces time-to-market No changes needed to app or database Database usage analytics Intelligent load balancing Centralized data management ScaleBase Distributed Database Management System
- 30. Questions? Contact Info: Paul Campaniello paul.campaniello@scalebase.com Vladi Vexler vladi.vexler@scalebase.com Resources: www.scalebase.com www.scalebase.com/resources www.scalebase.com/blog info@scalebase.com (617) 630.2800
Editor's Notes
- #4: As a Czech, and as a point of national pride, it expected for me to be pictured with a beer. Wearing cool sunglasses extra points….
- #6: Costs should be: Linear, Predictable
- #7: Because of these! Today modern area, web-scale. Social. Online. Right here, right now. Virtualization, and cloud… commodity hardware You customers will have some combination of those
- #9: Costs should be: Linear, Predictable
- #17: Let’s start with the facts. My app has 1000 transactions. Per second! 1 DB not enough. 4 DBs are good as long as – transactions are distributed. Every tx or query is complete within 1 DB! No more 1 big fat busy database, welcome 4 smaller, less data, less sessions, more agile databases. Scale out!
- #20: Data, Reads, Writes
- #22: Determine optimal distribution policy for your specific application and database Analyze your existing schema and queries What is the current structure of your data How is your data accessed by the applications What is the size and rate of writes to individual tables
- #27: ScaleBase is available 3 clicks away in Amazon Marketplace, a complete functional system in minutes leveraging RDSs or MySQLs installed on EC2 machines. If you run on Rackspace, you can find ScaleBase on their marketplace too, I would like to have your attention to some things Rackspace CTO had to say… “Rackspace customers migrating apps to the cloud can leverage a solution that distributes a single MySQL database into smaller, more manageable ones” I think it summarize things pretty nicely.
- #29: Risk Cost savings (ROI) Time to market Building solution takes years Open source is limited Not comprehensive Lack of technical support and services Custom built Inefficient and hard to maintain