-6

Recently we have been testing an HA Database solution from a 3rd party provider. I have done some stress tests to see some metrics for Master & Slave status etc, however I would like to test the actual failover.

I need a way to test the failover or some other way to disable the Master DB but not from the 3rd party's interface as I cannot guarantee that they dont have checks when you disable the Master. By the way the database HA solution is on the cloud so server access is not possible.

Any suggestions?

P.S is dba stackexchange a better place to ask?

Improve this question
10
  • 1
    Just stop one instance.
    – Michael Hampton
    Aug 19, 2016 at 7:48
  • 1
    Well, you failed to name the "3rd party", so no specific advice can be given.
    – Michael Hampton
    Aug 19, 2016 at 7:56
  • 2
    "Just stop one instance" is the generic answer. How you do that depends on the specifics of the setup.
    – Michael Hampton
    Aug 19, 2016 at 7:59
  • 1
    Then you stop it via whatever method they provide.
    – Michael Hampton
    Aug 19, 2016 at 8:00
  • 3
    I understood the point of the question perfectly well. The problem is that it is fatally flawed. If you're using some cloud provider, you can't do what you want without involving that provider in some way.
    – Michael Hampton
    Aug 19, 2016 at 8:28

1 Answer 1

Reset to default
1

There are likely several ways to do this.

  • Stop one instance is the obvius thing to do.

  • Block access to mysql (TCP port 3306) at the instance firewall.

  • Set the instance to read only may partially work (SET GLOBAL read_only = ON;)

My preference would always be to just unceremoniously dike one of the nodes out of service.

Improve this answer
1
  • the 3rd one is very interesting I will try it out. The others I cannot, but thnx!
    – czioutas
    Aug 19, 2016 at 13:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .