Why we chose ScaleArc for MySQL
December 29, 2016
Why we chose ScaleArc for MySQL
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.