Running your database in the cloud
This presentation is the property of its rightful owner.
Sponsored Links
1 / 34

Running Your Database in the Cloud PowerPoint PPT Presentation


  • 44 Views
  • Uploaded on
  • Presentation posted in: General

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

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


Use case ecommerce application

Use Case eCommerce Application


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”)


Arch evolution failover

Arch. Evolution - Failover

Passive

Active


Arch evolution traffic increase

Load Balancer

Arch. Evolution – Traffic Increase


Arch evolution application scaling

Load Balancer

Arch. Evolution – Application Scaling


Arch evolution database failover

Load Balancer

Arch. Evolution – Database Failover

Passive

Active


Arch evolution db read scaling

Load Balancer

Arch. Evolution – DB Read Scaling

Master

R

R

R


Architectural evolution db write scaling

Load Balancer

Architectural Evolution – DB Write Scaling

Master

R

R

R


Arch evolution anticipating the peak

Load Balancer

Arch. Evolution – Anticipating the Peak

Master

R

R

R

R

R


Arch evolution scaling down

Load Balancer

Arch. Evolution – Scaling Down

Master

R

R

R


Arch evolution version upgrade

Load Balancer

Load Balancer

Arch. Evolution – Version Upgrade

Master

Master

R

R

R

R

R

R


Running your database in the cloud the challenges

Running Your Database in the CloudThe Challenges


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, …


The challenges availability

The Challenges Availability


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


The challenges scalability

The Challenges Scalability


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)


The challenges manageability

The Challenges Manageability


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


Build your own

Build Your Own

Source:


Database as a service

Database as a Service


The challenges cost

The Challenges Cost


Running your database in the cloud

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 cloud

Q & A


Running your database in the cloud1

Running Your Database in the Cloud

Thank You

[email protected]

www.xeround.com

Visit us in Booth 407


  • Login