ScaleArc for SQL Server and MySQL


Improve Application Uptime and Performance

Applications today are hamstrung by database architecture, limited by being tied to a database server on a 1:1 basis and not able to utilize the power of distributed databases / clusters without considerable changes. Ignite’s ScaleArc’s database load balancing breaks that 1:1 mapping, enabling an agile data tier that improves application uptime and performance by allowing applications to harness the power of a whole database cluster without any application changes.

Ignite’s ScaleArc software inserts transparently between application servers and database servers, providing an abstraction layer that shields applications from database infrastructure. You can enable automated failover and zero-downtime maintenance, scale out the database structure, and support cloud migration with no changes to the application. Ignite’s ScaleArc software is available for MySQL, SQL Server, and Oracle databases.

Transparent Deployment with Redundancy

Ignite’s ScaleArc deploys as a highly redundant pair of software appliances, sitting in line between the application and the database. Simply point the app’s connection strings at ScaleArc, and the software intelligently routes SQL queries to your database on behalf of the app. Ignite’s ScaleArc replication-aware load balancing and failover framework ensures your load gets distributed across the servers while ensuring the most current data is served to applications, and failover is simplified. In single server deployments, ScaleArc’s connection management and caching improve performance, offload the database,and increase app availability.

Leveraging Ignite’s ScaleArc software allows your application to gain these sophisticated capabilities without any changes, so you’re up and running with compelling new functionality in as little as 15 minutes.

Automated Failover with Reduced App Errors

Ignite’s ScaleArc software understands your database topology, monitoring your servers and automatically migrating client connections and traffic from a failed database node to a healthy node in the cluster.

During failover of a primary/master node, the ScaleArc software uses a query queue to hold incoming write queries in memory until another server is promoted and can accept that traffic. This architecture dramatically reduces app errors and prevents apps from hanging or having to be restarted. The only errors the application gets are from queries that were mid-flight to the failed server, ensuring transactional integrity and no double writes.

Zero-downtime Maintenance

Ignite’s ScaleArc software lets you adopt a zero-downtime maintenance architecture for your database stack, allowing you to gracefully stop sending traffic to a specific server in a cluster before you perform maintenance on it. You can patch, update schema, and perform other maintenance on that specific server, and when done bring it back into the cluster to receive traffic. With no need to take apps offline, it’s the end of maintenance windows.

ScaleArc analytics enable you to rapidly identify problem queries, such as slow, frequent queries. You can also take rapid action on these insights, adding queries to cache or blocking them.

Replication-aware Load Balancing

Once you’ve scaled out, Ignite’s ScaleArc software will automatically optimize application performance by taking server response time into account when directing traffic. The software allocates more load to the server that will respond fastest, and since ScaleArc is monitoring replication lag, it’ll never send a query to a server that is lagging behind on replication farther than the threshold you configured.

Ignite’s ScaleArc for
SQOL Server 3.x Features

  • Zero-downtime maintainence
  • Replication monitoring via advanced tables
  • Surge protection
  • Query firewall
  • Autofailover for AlwaysOn and SQL Mirroring

  • Authentication offload – old and new password formats
  • Read/write split including prepare statements
  • Dynamic load balancing
  • Query response caching (in memory, up to 1 TB) including stored procedures and prepare statements
  • Auto cache invalidation

  • SQL analytics
  • Historical stats
  • Live monitors
  • SNMP
  • SCOM
  • RESTful API

Database Versions Supported
  • MySQL 5.1, 5.5, 5.62
  • Galera 3.25
  • Percona XtraDB Cluster 5.6.20
  • MariaDB 10.0.3, 10.0.24, 10.1.14

System Requirements
  • Minimumof 2 CPUs, 2 GB RAM and 200 GB storagefor dev or test instances
  • 4 CPUs, 4GBRA, 240GBfor OS and 1 TB storage for SQLlogs is recommended for production instances
  • Intel x86 server platforms with hyper threading turned off yeild the best performance

Scalability with No Application Changes

Typically, to get an application to scale across multiple database servers requires a lot of reprogramming and complex techniques such as sharding. With ScaleArc, when you add a new server to a database cluster, it immediately becomes available to your applications as added capacity. ScaleArc can also cache the most frequently requested queries, such as metadata or static queries and serve them at lighting fast speeds. You gain the advantage of increased scalability without taking your app developers off the task of building new functionality. Additionally, ScaleArc has advanced auto cache invalidation methods that enable a true ACID compliant cache layer.

On-prem, Cloud, and Hybrid Deployments

Cloud deployments often pose a challenge for database performance and scalability. Database instances are typically smaller, and hybrid deployments, such as database on prem and app in the cloud, can introduce performance problems. Ignite’s ScaleArc solves the challenges of cloud and hybrid deployments and makes it easy to migrate workloads into the cloud. You can easily aggregate the capacity of smaller database instances to serve the needs of apps designed to work with a single large database server.

More from ScaleArc


ScaleArc Feature Tour

Understand the key features in ScaleArc such as auto-failover, query response caching, connection multiplexing, read-write split, query routing, surge protection, and load balancing.  Improve application uptime and performance by allowing applications to harness the power of a whole database cluster without any application changes.

ScaleArc Product Overview

ScaleArc’s database load balancing software enables an agile data tier consistently across your environments, and it inserts transparently between your apps and your databases, with no changes needed to either. ScaleArc keeps applications working properly and functioning despite interruptions and switchovers at the data tier.

ScaleArc for Database Migration

Organizations are moving to the cloud at a rapid pace, and cloud databases are a great way to test the waters before a large-scale transition and optimize their cloud infrastructure into the future. Learn how to streamline migrations with a database load balancer.