D
D
Dmitry Bogovik2015-11-02 11:58:11
MySQL
Dmitry Bogovik, 2015-11-02 11:58:11

How to synchronize MySQL DB without replication?

There are two servers (on different hostings), one works as the main one, the second as a backup, in case the first one falls, the second one takes over the main work through dns failover, until the first one is restored. You need to set up database synchronization so that while the first one is working, all the data from it is duplicated on the second (backup) server, except for the data itself and the structure of the database too, all of a sudden it will be changed on the main server, well, in cases of restoring the first (main), so that all the data that was written to the backup, they were automatically transferred to the database on the main server.
The problem is, it is not possible to set up replication of the master-master type, because due to the specific work of hosting, we do not have the opportunity to edit the server configuration files, the same my.cnf is trite.
Thank you.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
V
Viktor Taran, 2015-11-02
@shambler81

mysqldump
wget
sql

R
Ruslan Fedoseev, 2015-11-02
@martin74ua

if you cannot change the database server settings, then do the replication yourself, which thread is an additional script.

I
Ilya Panarin, 2015-11-02
@anyday

bash+rsync+mysqldump

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question