ScaleArc

ScaleArc for MySQL (other versions available for SQL Server and Oracle), developed by DevFactory solution and acquired by Ignite Technologies in January 2018, is database load balancing software that promises to increase uptime, performance, and scale out for applications leveraging the MySQL database.

The software drops in between applications and databases and directs queries into the database on behalf of the app - it looks to the app as if it were the database, and it looks to the database as if it were the app.

The software lets organizations leverage modern, scaled out databases with no application changes. It automatically supports scale out, performing read/write split dynamically, so users don't have to code read-intent strings into the application.

It avoids app downtime from database outages, both planned and unplanned. During a database failover, ScaleArc software queues inbound queries, waiting for the secondary to take over as the new primary, and then drains the queue in a FIFO manner, so apps see delay but not errors. Users can invoke the same functionality to force a switchover, enabling them to achieve zero downtime maintenance.

App-transparent caching speeds performance with no app changes, and the software also supports connection management for greater database server efficiency.