On Tue, 26 Oct 2004 17:24:42 -0400 (EDT), Ricky Beam
<jfbeam(a)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?
--
[[en:User:Dori]]