On Oct 26, 2004, at 2:24 PM, Ricky Beam wrote:
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?
The files on disk aren't guaranteed to be in a stable state unless the
server is cleanly shut down.
You could perhaps copy the entire snapshot to another machine, let it
replay the innoDB transaction logs to recover the innoDB tables, and
run a repair on the MyISAM tables, and then copy things from there, but
that sounds itchy to me.
-- brion vibber (brion @
pobox.com)