220 likes | 312 Views
A Ridiculously Easy & Seriously Powerful SQL Cloud Database. Itamar Haber AVP Ops & Solutions. About Us Common pains with the database tier Xeround’s SQL Cloud Database Demonstration Create Your New DB Instance Connect to Your DB Instance Scale Your Database Survive a Server Crash.
E N D
A Ridiculously Easy & Seriously Powerful SQL Cloud Database Itamar Haber AVP Ops & Solutions
About Us Common pains with the database tier Xeround’s SQL Cloud Database Demonstration Create Your New DB Instance Connect to Your DB Instance Scale Your Database Survive a Server Crash Agenda
About Us About Xeround, the company: Founded in 2005 and backed by solid VC investors Initial premise: Telco-Grade, Real-Time DBMS Already deployed in live Telco production – T-Mobile US, Pelephone ISR About Xeround, the technology and service: Designed from day one for a Cloud ecosystem Patented native Virtualized Cloud DB, balancing Innovation with Traditional SQL Simple to use, seriously powerful About myself: 17+ years around database-based applications and DBMSs in various capacities Last 4.5 years with Xeround doing product, project and operations management There is a crack in everything – that’s how the light gets in (Leonard Cohen)
(Some) Common Pains with the Database Tier Database server installation Operating system installation Configuration: storage, networking… Database server maintenance Patches and upgrades Backup (and restore) policies Database operation Monitoring High Availability: fail over (& failback) Scaling
Xeround SQL Cloud Database-as-a-Service Elastic, Available & Simple! Worry Free philosophy – operational aspects all handled by the service Robust functionality, full compatibility with MySQL Self-service management portal
General Architecture DB Instance Manager DBaaS Resource Manager Customer Self Serve Web Portal Service API DBaaS Operator web Portal
Virtualized Database Layers Load Balancer Load Balancer Load Balancer SQL Engine SQL Engine SQL Engine SQL Engine SQL Engine Data Store Data Store Data Store Data Store • The virtualized Database is built from three separate elements: • Load Balancer • SQL Engine • Data Store • Each element is scalable • Physical resources for each element are managed individually
Virtualized Database Layers, cont. • Load Balancer – The gateway to a database instance • Maintains transaction stickiness and balances the load between the SQL engine instances • Handles failover of SQL engines • SQL Engine - MySQL Façade implementation • Processes SQL statements into distributed parallel plan of execution • Gathers the results from the different processes and assembles the final result for the application • Data Store - Distributed data stores, which maintain the data in its different representations • DHT, Distributed B-Tree and Object Store, which are the basic data services required by the database • Pluggable persistency layer
DBaaS Resource Management DBaaS Resource Manager Cloud Resources Load Balancer Load Balancer Load Balancer SQL Engine SQL Engine SQL Engine SQL Engine SQL Engine Data Store Data Store Data Store Data Store Cloud API DBaaS Resource Manager uses the Cloud API to acquire resources for the database service and to provision the service elements on those resources
Connecting to Your Cloud Database 100% compatible with MySQL No code changes required to port an existing application Built-in advanced features (e.g., replication, load balancing…) are transparent to the user
Database Instance Management The DB Instance Manager is responsible for creating databases, by allocating slices from the Load Balancer, the SQL Engine and the Data Store physical resources. DB Instance Manager Database Instance DBaaS Resource Manager Load Balancer Load Balancer Load Balancer SQL Engine SQL Engine SQL Engine SQL Engine SQL Engine Data Store Data Store Data Store Data Store Data Store Data Store
3 Ways to Scale Your Database Instance Manual Scaling - via the self-service portal GUI Auto-Scaling Currently: thresholds-based rules Near-future: advanced rule- and policy-based scaling API - enables programmatic access to the service’s capabilities
Load Balancer = More connections SQL Engine = More queries/ complexity Data Store = More data Database Instance Scaling Each element may be scaled separately: DB Instance Manager Database Instance DBaaS Resource Manager Load Balancer Load Balancer Load Balancer SQL Engine SQL Engine SQL Engine SQL Engine SQL Engine Data Store Data Store Data Store Data Store Data Store Data Store
Data Distribution Each Virtual partition is replicated across multiple servers. If any one of the servers fails, all data is still available and the DB is still operational This enables a recovery process to occur, by acquiring a replacement server, and re-sync the server from existing partitions P1 P2 A database With 4 virtual partitions P3 P4 P2 P1 P1 P2 P3 P3 P4 P4 Host Host Host
P1 P3 Fault Tolerance & Automatic Healing 1) When a server fails, surviving replicas maintain the service P1 P2 P3 2) The system heals itself by automatically “re-growing” the missing replicas P4 P2 P1 P1 P2 P3 P3 3) A pool of failover servers is kept online to expedite process P4 P4 Host Host Host
Summary Xeround offers a SQL Cloud DBaaS that is: Simple to use Elastic so it always fits your requirements Highly available Fully-compatible with MySQL Xeround’s DBaaS frees you from worrying about: Patching and upgrading your database server Operating a backup policy Planned and unplanned downtime
Xeround DBaaS Deployments • Xeround Cloud DB service is currently deployed on Amazon US(East), Amazon Europe and Rackspace US • NORTH AMERICA • EUROPE Additional Cloud Service Providers coming soon…
A Ridiculously Easy & Seriously Powerful Cloud Database - See it in Action! Questions? Thank You! http://xeround.com/ Visit us in Booth 407