On Tue, 26 Oct 2004, user_Jamesday wrote:
For LVM are you thinking of having all writes go to all
database servers
at the same time, instead of via replication? Sounds as though that's what
you have in mind...
Not exactly. There is still one master database. However, it is stored
on an LVM (over hardware raid) volume. With some slack space in the volume
group, a stable snapshot can be made of the database on disk and then
replicate it to a new slave. At the the snapshot is created, begin
a new binlog that can be applied once the copy is complete.
Or am I just thinking crazy again?
--Ricky