V
V
Vladislav Ross2010-12-22 03:34:18
MySQL
Vladislav Ross, 2010-12-22 03:34:18

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

4 answer(s)
Z
Zazza, 2010-12-22
@Zazza

www.tushkan.com/replic.htm

A
Alexander, 2010-12-22
@akalend

> Prompt means for automatic switching to a mirror.
nginx/upstream - for WEB
mysql_proxy

I
iTNitro, 2010-12-23
@iTNitro

With MySQL replica master-slave is fine.
According to the replica of the files, I would recommend the DRBD + OCFS2 option habrahabr.ru/blogs/hi/50143/ or there is a lot of information in the hum.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question