I have 2 MySQL/MariaDB servers each of them with its own database and I would like to set up a continuous backup on each other via replication.
Is it possible to make 1 DB master and 1 slave on each one of the servers?
Server 1 Server 2
db1 (master) db1 (slave)
db2 (slave) db2 (master)
Or is there a better option to do it? But I would like to have ready-to-use DB(no dump files) in case of a failure of one of the servers so I can quickly switch to another.