|
The linux-ha list would probably be a better place to discuss this.
A Mysql clustering toolkit is here:
http://prometheus.zerodivide.net/mysql_cluster/
Short answer: no, you don't want to use rsync to copy mysql databases from
machine to machine.
You might investigate DRBD or GFS as an alternative to the above
for clustering mysql.
--
Michael Brown
On Wed, 3 Jan 2001, Fabio Pedrazzoli wrote:
>
> 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
>
>
>
> _______________________________________________
> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
|
