|Release||Document Status||DB Platform||Categories|
|3.4 or higher||All||Failover Settings|
Permission Required on MySQL database for new failover feature to work with ScaleArc 3.4 and higher Version
In previous versions, ScaleArc was not designed to modify the replication by changing Slave pointers to new master when a Primary master goes down. To change the slave pointers to new master, ScaleArc needs the following permission to be set on database for that specific user with which the cluster was created:
- SELECT and INSERT privileges on mysql database
- REPLICATION SLAVE
- REPLICATION CLIENT
- GRANT OPTION
IMPORTANT: Grant the permission to user which you used or are using to create a ScaleArc cluster.
Also, Often reffered to as "ScaleArc Cluster User" or "ScaleArc Root User"
GRANT UPDATE, SELECT, INSERT, CREATE, DROP, RELOAD, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'scalearc'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
In addition to above, ScaleArc use's utility 'mysqlreplicate' for Failover (Unplanned) and 'mysqlrpladmin' for Switchover (Planned). To support this, it is required to create following users as well -
create user 'scalearc'@'DB IP' identified by 'admin@123';
GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'scalearc'@'DB IP' WITH GRANT OPTION;
Perform above for each of the MySQL server participating in the cluster.
This additional step is necessary for Percona Clusters too.
Compatibility and Options
Internal Scalearc Autofailover handles the following MySQL Server versions:
- mysql 5.5.40
- mysql 5.6.21 with GTID
- mysql 5.6.22 without GTID
- mysql 5.7.18
Other MySQL Server version can be handled by using the External ScaleArc Autofailover option.
You can read more about GTID on this MySQL site:
If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support. We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315. For general support inquiries, you can also e-mail us at firstname.lastname@example.org.