Mysql server duplicate

[louis]

Hello !

I need your advice. For my web servers I use vestacp on all of them.
I have a main web server + a backup server that are in sync. If the main server is down the ip Failover moves to the backup server.

For mysql I currently have only one server, I would also like to have a backup server. In the same idea as the web servers with the ip Failover that moves if the server is down.

My question is how can I have two mysql servers that always have the same data ?
With an php or Python script ?

Thanks for your help.
Louis