Hello! I am trying to prepare a multi server ISPconfig setup with 1x panel, 1x mail, 1x web and 2x mysql (mariadb) servers. And I'd like to be able to fail over to a mysql replica in case my primary completely crashes. What I can't get is what the proper way to fail over is? I understand how to setup a replication, but let's suppose mysql01 is gone completely and no recovery possible. And I have my new primary mysql02, how I should make it primary in the ISPconfig admin area? Because in the master (dbispconfig) database all my websites are using mysql01, and even if I switch the IP to mysql02, I will end with messed up dbispconfig? Could please somebody explain what is the simplest way to fail mysql server over so that my ISPconfig database would not be broken with mysql names of the crashed server? Thank you in advance!
