|Auto failover||Detects SQL server failures and performs role changes within the ScaleArc cluster Supports multi-data center topologies with auto failover framework||Enables automatic database failover that prevents application errors Provides automatic failover by handling both replication and client connection on database failure|
|Connection multiplexing||Aggregates multiple client connections into fewer server connections||Reduces server connection count and churn
Increases server performance and availability
|Query-response caching||Uses agentless pattern-based in-memory NoSQL cache for query responses||Provides instant scale up without app modifications
Extends life of servers and increases ROI
|Auto cache invalidation||Uses inserts/updates/comments/APIs as invalidation directives to cached responses, and enables ACID compliant caching for application data||Broadens the data sets that can be cached – e.g., shopping cart data,user profile tables
Lessen network load and enables faster data retrieval
|Surge protection||Manages client connection surges, queuing excess traffic when all server connections are busy||Increases uptime during traffic surges Reduces app errors during peak loads Buffers traffic during auto failover|
|Read/write split||Distributes reads to slaves and writes to master servers on behalf of the application
Supports read/write split for stored procedures
|Provides transparent scale out with no application modifications|
|Load balancing||Directs queries based on optimum server response time and replication status||Increases uptime and availability Improves application performance|
|Query routing||Routes queries/stored procedures to different database servers based on regex rules||Avoids the time and effort needed to modify applications to increase write capacity
Routes reporting workloads away from production database servers
|Authentication offload for MySQL users||Authenticates SQL client connections on behalf of the server – with support for old and new password formats||Improves performance by reducing server compute cycles|
|SSL offload||Supports SSL encryption for both client and server connections||Enables compliance for organizations requiring end-to-end SSL encryption|
|Real-time SQL analytics||Logs all SQL traffic and charts SQL query finger prints on a four-quadrant heat map||Reduces troubleshooting effort Highlights poorly performing queries|
|RESTful API||Supports integration with existing monitoring and management tools and processes||Simplifies configuration, management, and monitoring of the ScaleArc software|
|Cloud support of ScaleArc high availability active/passive mode||Extends support for configuration synch between ScaleArc instances to enable active/passive mode in the cloud||Brings auto failover and continuous availability to cloud deployments|
Watch the full series to discover how to use ScaleArc to its full capability and see even better results. We will discuss the various capabilities of ScaleArc in detail such as utilizing caching, logs and analytics, failover and zero downtime, load balancing, migrating your databases to the cloud and more.
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.
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.