Answer the question
In order to leave comments, you need to log in
Site mirroring / MySQL replication?
I would like to have an active / passive scheme for mirroring a site on Bitrix.
Those. there is a main site, and if something happens to it, we use a mirror. Moreover, it is enough to make the mirror read-only.
The questions are:
1. Is the solution reasonable: the database is replicated by master-slave using standard MySQL tools, files from the main server are periodically transferred by rsync?
Or is there something better?
2. Is it possible to make a read-only slave database so that users cannot add anything new to the site while the main server is being repaired?
3. How does replication behave if master falls off? Will she wait until the master starts working or will she have to restart something manually?
4. Prompt means for automatic switching to a mirror.
Answer the question
In order to leave comments, you need to log in
> Prompt means for automatic switching to a mirror.
nginx/upstream - for WEB
mysql_proxy
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question