A Ridiculously Easy & Seriously Powerful SQL Cloud Database

1. A Ridiculously Easy & Seriously Powerful SQL Cloud Database Itamar Haber AVP Ops & Solutions

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

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

4. (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

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

6. Demonstration:Create Your New DB Instance

7. General Architecture DB Instance Manager DBaaS Resource Manager Customer Self Serve Web Portal Service API DBaaS Operator web Portal

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

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

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

11. Demonstration: Connect to Your DB Instance

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

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

14. Demonstration: Scale Your Database, Automatically!

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

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

17. Demonstration: Server Crashes, Your Database Survives

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

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

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

21. 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…

22. A Ridiculously Easy & Seriously Powerful Cloud Database - See it in Action! Questions? Thank You! http://xeround.com/ Visit us in Booth 407