[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Apache/MySQL question

On Mon, 2004-01-19 at 12:30, Francis Tyers wrote:
> hmm, you might want to look into mysql replication, i just googled and
> got:
> http://www.mysql.com/doc/en/Replication.html
> http://jeremy.zawodny.com/mysql/managing-mysql-replication.html

> if you are on a lower budget, perhaps look at rsync ...
> http://samba.anu.edu.au/rsync/

We have this setup running here on a production server with 500+ web
hosts, fs replicated using rsync (homebrown replication scripts in
python, can be done in bash or just anything) and MySQL replication as
described in the  documentation (also managed through scripts).

We check the replication using Netsaint and both systems are an exact
copy, at worst of 5 minutes ago. We stopped at the point of implementing
some sort of STONITH, so no ip/service takeover yet.. considered how
MySQL replication is crippled and unreliable (IMHO), this should not be
done automagically anyway (or you have to provide really extensive
workarounds and integrity checking).

Jan Kokoska
Linux Administrator
GLOBE INTERNET, s.r.o. - http://globe.cz
Planickova 1, 162 00 Praha 6
mail: kokoska.jan@globe.cz
Tel: +420 235 365 302

Reply to: