9/27/2017 10:01:13 AM
ScaleArc now supports Microsoft Azure SQL database
DBaaS,Cloud Platform,Cloud Native App
App Developer Magazine

ScaleArc now supports Microsoft Azure SQL database

Christian Hargrave Christian Hargrave in Cloud Services Wednesday, September 27, 2017

Database-as-a-service platform, ScaleArc, has integrated for SQL Server software with Microsoft Azure SQL Database.

ScaleArc has announced that it has integrated its ScaleArc for SQL Server software with Microsoft Azure SQL Database. Customers of Microsoft Azure Database-as-a-Service (DBaaS) software can now benefit from the seamless scale out, faster application performance, and high availability features of the ScaleArc software. With this enhancement, customers can now take advantage of the flexibility and simplicity of Azure SQL Database with no application code changes.

Their database load balancing software deploys between application and Azure SQL Database servers to direct traffic into the database on behalf of the application. The software enables applications to leverage underlying database functionality without programming database logic into the app. ScaleArc also accelerates cloud-native application development, because developers no longer need to program database logic into the application. To fully support enterprise deployments, ScaleArc’s software upgrade also supports Azure Active Directory (AAD) for user authentication.

“Azure SQL Database offers a level of simplicity and ease of administration that dramatically offloads IT resources,” said Justin Barney, president and CEO of ScaleArc. “The challenge has always been whether a company’s applications can take advantage of the flexibility and scalability of these cloud resources. With ScaleArc software, Azure SQL Database customers can now leverage that agility with increased application uptime and performance.”

Key features:

- Automatically scale application performance with no code changes by automatically discovering all SQL Database cluster members, leveraging all available readable secondaries, and directing reads vs. writes to the appropriate servers - this capability eliminates the need to code “read intent” connect strings within apps to take advantage of readable secondaries.

- Ensure application uptime and performance by monitoring health status and replication lag on all servers in the cluster, sending traffic to the fastest server based on Time to First Byte and avoiding any servers with performance or availability problems.

- Eliminate the impact of transient errors by holding persistent client connections and directing queries to the new primary following a database server failover - the ScaleArc software will hold writes in queue until the failover is complete, shielding the application and the customer from seeing application errors.

- Avoid downtime from Azure SQL Database maintenance by having ScaleArc front end Azure SQL Database clusters in multiple zones or regions and leveraging the software to route around downed database resources. ScaleArc can detect the new primary and always route the writes appropriately, avoiding potential split-brain issues with Azure SQL Database. Also, ScaleArc’s surge queue holds writes and waits for the server role change to happen, ensuring writes go to the new primary.

- Accelerate application performace by leveraging ScaleArc’s app-transparent caching capabilities - this feature allows Azure SQL database customers to identify queries that are good candidates for caching, add them to the cache via a single mouse click, and expire the cache based on time to live or auto-invalidation when the data changes.


Your name and email will not be public or shared in any way.

Learn more about Cloud Computing: Concepts, Technology & Architecture

Clouds are distributed technology platforms that leverage sophisticated technology innovations to provide highly scalable and resilient environments that can be remotely utilized by organizations in a multitude of powerful ways. To successfully build upon, integrate with, or even create a cloud environment requires an understanding of its common inner mechanics, architectural layers, and models, as well as an understanding of the business and economic factors that result from the adoption and real-world use of cloud-based services. 

A new way to manage your development projects

Learn the best ways to organize your app development projects, and keep code straight, clients happy, and breathe a easier through launches.

Read the Linux Bible

The ultimate hands-on Linux user guide.

The Latest Nerd Ranch Guide (3rd Edition) to Android Programming

Write and run code every step of the way, using Android Studio to create apps that integrate with other apps, download and display pictures from the web, play sounds, and more. Each chapter and app has been designed and tested to provide the knowledge and experience you need to get started in Android development.

Starting your own app business?

How to create a profitable, sustainable business developing and marketing mobile apps.