On Tue, 26 Oct 2004 17:24:42 -0400 (EDT), Ricky Beam jfbeam@bluetronic.net wrote:
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.
You would need a true transaction system for this to work right (i.e. the last write has either been completely done or none at all), does MySQL support this? Also, the slave(s) would then lag behind right?