Why we chose ScaleArc for MySQL
December 29, 2016

Why we chose ScaleArc for MySQL

Balwan Singh | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with ScaleArc for MySQL

We are using ScaleArc for MySQL to achieve a high availability solution across multiple clusters of MySQL databases. ScaleArc has helped us in achieving high availability by providing us a seamless interface for auto failover as well as a script based customized solution. While failing over to a slave database, it does take care of syncing the data from a previous master through its binlogs.
  • ScaleArc does provide high availability and during failover it takes care of the master slave lag as well seamless switch between master and slave.
  • ScaleArc also helps to reduce application traffic on MySQL database server by filtering frequently used commands like AUTOCOMMIT.
  • ScaleArc provides a single interface for all application and database user management. This helps in strengthening security aspects of user management.
  • Checkboxes for selection of multiple users to enhance easier management.
  • There should be a rule within the ScaleArc cluster to send traffic to particular slave replica for re-routing of read queries.
  • Logging generation is excessive and causes pressure on disk resources. This should be further improved to log information to not miss the necessary but also not include the unnecessary.
  • Provided a single management interface for a complete MySQL farm in our company. It has helped particularly in managing high availability of MySQL databases thus overall improving the business website reliability. This in turn further enhances the confidence of our customers.
Well suited for automated failover between Master and Slave
Works well with Galera cluster technology
Works very well for database load balancing
Less suited for CPU and memory related optimization for ScaleArc cluster
Prerequisite to run ScaleArc on standalone machine should be avoidable so that customer is not forced to provide dedicated hardware for this software