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