How do you force a mysql flexible failover for testing purposes?

alex 106 Reputation points
2021-02-19T21:25:23.227+00:00

How an app recovers from a mysql server failure and a fail-over needs to be checked, you can't just assume it will be fine.

So there needs to be a way to force it. How?

There's a note in the docs

In case of the compute scaling operation, we scale the secondary replica server followed by the primary server. There is no failover involved.

So compute scaling is not adequate for this.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
747 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Navtej Singh Saini 4,221 Reputation points Microsoft Employee
    2021-02-25T02:30:04.757+00:00

    @alex

    We checked with our product team and they have conveyed that this functionality is not available right now.

    But they are working on it and tentatively it should be released next month depending on testing and other needed evaluations. You can reach out to get more info here.

    Regards
    Navtej S