How to make a dynamic translation of a stream from one database to another?

Question

Database

Hello!
There are two servers (one combat, the second backup), each has a database installed, let's say the combat server began to refuse service (overheating, power problem, DDoS or something else), how in such a situation to transfer all requests to the backup server?

Answer 1

How will switching help you from DDOS?
make balancing on both servers, let both work, if one is bent all requests will go to the other, the base to the replica

Answer 2

Ilya Kosmodemyansky recommends doing it manually (answers questions at the end).

how in such situation to transfer all requests to the reserve server?

A common practice is to build a cluster.