Creating an Agile Data Environment for Apps in the Cloud

1. Creating an Agile Data Environment for Apps in the Cloud Summer 2014

2. Agenda • ScaleArc overview • How ScaleArc enables the cloud • How ScaleArc works • Live product demo • Reference architectures for the cloud • Discussion –opportunities to collaborate

3. ScaleArc Overview

4. ScaleArc at a Glance • Strong backing by top-tier partners • Third generation of software platform • Three broad patents granted – four more in process • For on-premor cloud – strong partnerships with cloud providers • “Top 10 Hot Big Data Startups” • by CIO.com

5. Apps are Hamstrung by Today’s Database Structure • 1:1 tie between app and database • Database = common source of outage • Planned (maintenance) and unplanned • Failover causes app errors • Scaling is challenging and costly

6. ScaleArc – Enabling An Agile Data Tier, w/ Zero Downtime • Database traffic management software • Inserts between apps and databases • Provides an abstraction layer • Deploys transparently, in minutes • Fastest, most cost-effective path to higher availability and scale • Supports full range of SQL offerings

7. Customers Benefitting from Zero Downtime for Apps

8. How ScaleArc Enables The Cloud

9. Top Use Cases and Projects for Enterprise Customers Auto Failover In or Across Data Centers Customer choose ScaleArc for: Cloud Migration Data Center Modernization Zero Downtime Maintenance Continuous App Availability As part of projects for: Add Capacity with No Downtime SQL Server 2012/2014 Upgrades All enabled without any changes to the app or database

10. Challenges in Cloud Deployments • Smaller instance sizes • Inability to architect failover mechanisms • No support for DNS or IP migration • Lack of geo control • Slow performance across WAN boundaries

11. Key Value Props for ScaleArc in the Cloud • Enables simple application migration • Move enterprise workloads to the cloud with no app changes • Aggregate smaller cloud database instances to behave like one large server • Provides high-availability solutions with auto failover • Within one locale or across regions/availability zones • Delivers high-performance – for cloud and hybrid deployments • No performance compromise for apps in the cloud • Supports app in the cloud, database on prem • Solves future scaling issues • Scale up and scale out without any app modifications

12. We are Targeting the Same Work Loads • eCommerce& SaaS • Financial services • Healthcare • content/media • Corporate and/ or media-rich sites • Dynamic OLTP workloads • CRM / ERP • Email / SharePoint Image of cloud provider’s offering

13. Top Use Cases – Business Perspective (Sales Rep) #1 – Help me use what I am paying for • Use both primary and failover database servers (database load balancing) #2 – Stop my app from locking up during database failover • Leverage auto failover without having to reboot app servers #3 – Help me scale out • Simply add another database server to the pool to get more capacity #4 – Speed up my slow database • Split read vs. write queries and cache various reads

14. Top Three Use Cases – Technical Perspective (SE) #1 – Continuous application availability • Customers have implemented failover, but it leaves the app in shambles – ScaleArc enables the app to survive a database failover #2 – Visibility • ScaleArc exposes the query request/response relationship between the application and the database, especially critical for cloud deployments #3 – Performance • ScaleArc’s connection multiplexing, connection management, authentication offload, caching, and seamless failoverspeed throughput

15. How ScaleArc Works

16. ScaleArc in Action Primary Secondary Secondary

17. Read/Write Split Primary Secondary Secondary

18. Automatic Failover that Maintains Application Uptime ScaleArc performs read/write split 1 Upon database failure, ScaleArc queues queries 2 ScaleArc directs queries to new write server Apps see delay but not errors Applies to zero-downtime patching 3 4 5 Primary Secondary Primary Secondary

19. Replication-Aware Load Balancing 10:00:04 10:00:02 10:00:06 10:00:04 10:00:06 10:00:02 10:00:02 10:00:04 10:00:04 Primary Secondary Secondary

20. Query Response Caching Primary Secondary Secondary

21. ScaleArc Also Improves Availability for Single Servers Database offload capabilities • Connection management • Multiplexing and other features smooth input to server to improve efficiency • Caching • NoSQL cache accelerates response time for related app and offloads database to better serve non-cached content Sysbench Response Time Faster through ScaleArc than directly to database

22. Live Product Demo

23. Customer Case Studies

24. Full Cloud Deployment: App and Database in Cloud App Tier • Challenges • Smaller database instances … • ScaleArc Solution • Deploy ScaleArc in the cloud in < 30 min • Improve performance • Local serving of reads with response-time aware load balancing • Caching for fast throughput • Provide visibility into SQL transactions for additional troubleshooting

25. Cloud Deployment: Cross-Region Failover App Tier … App Tier … • Challenges • Enable failover despite lack of DNS/IP migration • App hanging from long timeout • ScaleArc Solution • Enable active/active deployment • With auto failover to secondary in either location • Queue “in flight” queries during failover to reduce app errors Replication

26. Hybrid Deployments: App in Cloud, Data on Prem App Tier … • Challenge • WAN latency slows app performance In cloud • ScaleArc Solution • Deploy ScaleArc in the cloud in < 30 min • Improve performance • Local serving of reads with response-time aware load balancing • Caching for fast throughput • Provide visibility into SQL transactions for additional troubleshooting On prem

27. Thank You