running your database in the cloud
Download
Skip this Video
Download Presentation
Running Your Database in the Cloud

Loading in 2 Seconds...

play fullscreen
1 / 34

Running Your Database in the Cloud - PowerPoint PPT Presentation


  • 71 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Running Your Database in the Cloud' - lihua


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
running your database in the cloud

Running Your Database in the Cloud

Eran Levin

VP R&D - Xeround

agenda
Agenda
  • The paradigm shift
  • Real life use case
  • Challenges running a database in the cloud
  • Available solutions
  • Q&A
the paradigm shift
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, …
the paradigm shift1
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)
architectural evolution rollout
Architectural Evolution - Rollout
  • You are ready to roll your new eCommerce app
  • Will deploy in the cloud (price, time to market, flexibility, “cool”)
the challenges
The Challenges
  • Availability
  • Elasticity
  • Manageability
  • Cost
  • Solved for the Web and application levels
  • Imagine an equivalent solution for your database…
meeting the challenges
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, …
availability
Availability

Standby machine

Replication

Failover mechanism

Source:

cloud availability solutions
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
scalability scale up vs scale out
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
shared everything vs shared nothing
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
shared nothing in the cloud
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
elasticity
Elasticity

Scaling out/up AND in/down

One of the Cloud justifications (but what about databases)

manageability
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
slide32
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
running your database in the cloud1
Running Your Database in the Cloud

Thank You

[email protected]

www.xeround.com

Visit us in Booth 407

ad