How Does: ScaleArc handle 'read_only' parameter during Percona DB Fail-over?
- Does ScaleArc's Failover logic consider 'read_only' parameter for each database?
- Which of the ScaleArc logs has this captured?
- Yes. ScaleArc's Failover script will consider "read_only" variable and flip it prior to promotion or demotion during the failover.
For instance, if your Slave has "read_only" variable ON -->
Then during failover, ScaleArc will change it to 'OFF' prior to promoting it to an R/W server.
Likewise, for an R/W server, it will be turned 'ON' prior to demoting it to be a Slave.
- This change in parameter is captured in following log -->
Note : This behavior is same as in a native MySQL Master/Slave setup within ScaleArc, with "AUTO FAILOVER > Replication Type = Synchronous".
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.