1 / 34

Running Your Database in the Cloud

Running Your Database in the Cloud. Eran Levin VP R&D - Xeround. Agenda. The paradigm shift Real life use case Challenges running a database in the cloud Available solutions Q&A. The Paradigm Shift. From Dedicated On premise Over provisioned Self managed. To Shared resources

lihua
Download Presentation

Running Your Database in the Cloud

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. Running Your Database in the Cloud Eran Levin VP R&D - Xeround

  2. Agenda • The paradigm shift • Real life use case • Challenges running a database in the cloud • Available solutions • Q&A

  3. The Paradigm Shift From • Dedicated • On premise • Over provisioned • Self managed To • Shared resources • Cloud hosted • Pay-per-use • Managed service • Without compromising functionality, performance, availability, …

  4. The Paradigm Shift • The Cloud • Availability issues • Stateless • Limited control (HW, Virtualization, Networking) • Expectations (reduce capital and operational costs) • Databases • Mission critical, lossless • Statefull • Usage patterns (data and throughput)

  5. Use Case eCommerce Application

  6. Architectural Evolution - Rollout • You are ready to roll your new eCommerce app • Will deploy in the cloud (price, time to market, flexibility, “cool”)

  7. Arch. Evolution - Failover Passive Active

  8. Load Balancer Arch. Evolution – Traffic Increase

  9. Load Balancer Arch. Evolution – Application Scaling

  10. Load Balancer Arch. Evolution – Database Failover Passive Active

  11. Load Balancer Arch. Evolution – DB Read Scaling Master R R R

  12. Load Balancer Architectural Evolution – DB Write Scaling Master R R R

  13. Load Balancer Arch. Evolution – Anticipating the Peak Master R R R R R

  14. Load Balancer Arch. Evolution – Scaling Down Master R R R

  15. Load Balancer Load Balancer Arch. Evolution – Version Upgrade Master Master R R R R R R

  16. Running Your Database in the CloudThe Challenges

  17. The Challenges • Availability • Elasticity • Manageability • Cost • Solved for the Web and application levels • Imagine an equivalent solution for your database…

  18. Meeting the Challenges • Build your own • For example - MySQL on EC2, Postgres on Rackspace, … • Acquire instances • Install the database according to your architecture • Self manage your database • Database-as-a-Service • For example - Amazon RDS, Xeround, Database.com, …

  19. The Challenges Availability

  20. Availability Standby machine Replication Failover mechanism Source:

  21. Cloud Availability Solutions • Amazon RDS Multi Zone • Master – Slave configuration • Up to 3 minutes recovery • Double the cost • Maintenance window • Xeround • “Master-Master” configuration • Multiple replicas of the data • Always-on

  22. The Challenges Scalability

  23. Scalability – Scale Up vs. Scale Out Source: • Scale Up • Select next available configuration (EC2, RDS) • Relatively simple but limited scalability • Scale Out • Add additional resources • Complicated but high scalability • RDS Read replicas

  24. Shared Everything vs. Shared Nothing • Shared Everything • Scale throughput but limited due to shared resources • Storage and networking limitations in the cloud • ScaleDB • Shared Nothing • Horizontal data partition / sharding • Unlimited scalability • Many design and implementationchallenges

  25. Shared Nothing in the Cloud • Xeround • Virtual partitioning – decoupling of data and resources • Linear scalability for both reads and writes • Automatic balancing and repartition following changes in data and / or resources with no downtime • ScaleBase / dbShards • Automatically partition the data and direct queries to right databases • Original databases deployment, management and cost • Partitioning events • MySQL Cluster • NOT supported on virtual environments

  26. Elasticity Scaling out/up AND in/down One of the Cloud justifications (but what about databases)

  27. The Challenges Manageability

  28. Manageability • Self-serve is a fundamental characteristic of cloud computing • DBaaS should provide • User management • DB management • Control and Monitoring • Backup and restore • … • API to enable extendibility and interaction with the cloud ecosystem • Solutions: Amazon RDS, Xeround, FathomDB

  29. Build Your Own Source:

  30. Database as a Service

  31. The Challenges Cost

  32. Cost • Pay-per-use is another fundamental characteristic of cloud computing • Achieving this model requires: • Elasticity – scale resources according to actual usage • No over provisioning • No idle standby machines • Sharing resources to share cost • Measuring exact usage

  33. Q & A

  34. Running Your Database in the Cloud Thank You eran.levin@xeround.com www.xeround.com Visit us in Booth 407

More Related