Re: Clustering MySQL

[Karanbir Singh <mail-lists@xxxxxxxxx>]

Matt Shields wrote:
> 
> If this were master-slave, I'd probably do an LVM Snapshot and get a
> fresh copy of the master db.  The same could be done for
> master-master.
> 

has a live lvm-snapshot ever worked for you as a real move-data-around
policy ? you would, at the very least, need to flush in memory data, and
have a system wide write lock in place while the snapshot is created.

its been a tempting idea, but so far of the few people I know having
tried this lvm snapshoting, have never actually managed to get it
working right for mysql dumps. So, would be good to hear from someone
who has it working.

-- 
Karanbir Singh : http://www.karan.org/ : 2522219@icq
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos