|
Hi, I hope that's the right list, sorry if I'm off topic_
I set up a HA-Linux cluster with Debian potato, heartbeat,
and rsync.
The system works fine, it gets syncronized via a crossover
patch between two 10/100 private ethernet cards.
I'm mirroring the whole filesystem except a dozen of files in /etc
and /ha-logs.
In case of a ha-master's fault, all services on the slave machine seems
to work without problems, as they're started via haresources in system
V's flavour, allowing daemons to read the newly-syncronized configuration
files.
I'm ok with ssh,http,https,ftp,smtp ... but what about databases?
I'm doing some tests with mysql but i'm not sure mirroring DBases with
rsync
will be always safe.
*First, i'm not a DB guru :)
My question is about DB inner chaching mechanism:
Let's suppose i need to mirror:
foo = '/usr/local/mysql/data/foo_DB'
every half hour with a crontab entry like that:
rsync --rsh=/usr/bin/ssh -aurvl --progress --delete $foo/ ha2:$foo;
How can I be sure that files i'm synchronizing are not being written
by mysqld?
How can I be sure about DB files consistency?
Is it the only solution to use an approach like that:
DB stop -> DB dump -> DB start
|
|----------rsync--------> ha2 machine
This solution surely works but it's quite slowly...
Any suggestions, experience?
thanks in advance
regards
Fabio
--
Fabio Pedrazzoli
Network admin
IT Consultant
|
