Mysql on cluster
Michael E Brown
michael_e_brown at dell.com
Wed Jan 3 17:00:43 GMT 2001
The linux-ha list would probably be a better place to discuss this.
A Mysql clustering toolkit is here:
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.
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
> 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
> 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
> Fabio Pedrazzoli
> Network admin
> IT Consultant
> LinuxVirtualServer.org mailing list - lvs-users at LinuxVirtualServer.org
> Send requests to lvs-users-request at LinuxVirtualServer.org
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
More information about the lvs-users