ScaleArc MySQL Key Features

Auto failover

Description

Detects MySQL server failures and performs role changes within the ScaleArc cluster. Supports multi-data center topologies with auto failover framework

Benefit
  • Enables automatic database failover
    that prevents application errors
  • Provides automatic failover by handling
    both replication and client connection on database failure

Auto cache invalidation

Description

Uses inserts/updates/comments/APIs as invalidation directives to cached responses, and enables ACID compliant
caching for application data

Benefit
  • Broadens the data sets that can be
    cached – e.g., shopping cart data, user profile tables
  • Lessen network load and enables faster data retrieval

Connection multiplexing

Description

Uses inserts/updates/comments/APIs as invalidation directives to cached responses, and enables ACID compliant
caching for application data

Benefit
  • Broadens the data sets that can be
    cached – e.g., shopping cart data, user profile tables
  • Lessen network load and enables faster data retrieval

Query-response caching

Description

Uses agentless pattern-based in-memory NoSQL cache for query responses

Benefit
  • Provides instant scale up without app modifications
  • Extends life of servers and increases ROI

Surge protection

Description

Manages client connection surges, queuing excess traffic when all server connections are busy

Benefit
  • Increases uptime during traffic surges
  • Reduces app errors during peak loads
  • Buffers traffic during auto failover

Read/write split

Description

Distributes reads to slaves and writes to master servers on behalf of the application

Supports read/write split for stored
procedures

Benefit
  • Provides transparent scale out with no
    application modifications

Load balancing

Description

Directs queries based on optimum server response time and replication status

Benefit
  • Increases uptime and availability
  • Improves application performance

Query routing

Description

Routes queries/stored procedures to
different database servers based on regex rules

Benefit
  • 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

Description

Authenticates MySQL client connections on behalf of the server – with support for old and new password formats

Benefit
  • Improves performance by reducing server
    compute cycles

SSL offload

Description

Supports SSL encryption for both client and server connections

Benefit
  • Enables compliance for organizations
    requiring end-to-end SSL encryption

Real-time SQL analytics

Description

Logs all SQL traffic and charts SQL query finger prints on a four-quadrant heat map
caching for application data

Benefit
  • Reduces troubleshooting effort
  • Highlights poorly performing queries

RESTful API

Description

Supports integration with existing monitoring and management tools and processes

Benefit
  • Simplifies configuration, management, and monitoring of the ScaleArc software

Cloud support of ScaleArc
high availability
active/passive mode

Description

Extends support for configuration synch between ScaleArc instances to enable active/passive mode in the cloud

Benefit
  • Brings auto failover and continuous
    availability to cloud deployments

Supported MySQL Versions

MySQL 4.0, 5.0, 5.1, 5.5, 5.6, 5.7

MariaDB, Percona, Percona XtraDB cluster

More from ScaleArc

 

ScaleArc for MySQL

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Know More

ScaleArc Product Overview

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Know More

ScaleArc Product Highlights

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Know More