I've got a website that uses a mysql backend database. Due to the way in
the database and development has been architected, I'm unable to
the database between multiple DB servers, taking advantage of replication
in mysql. (this is due largely to developmental constraints, and heavy use
I *need* to somehow mirror and create a decent failover environment for my
Currently, I mirror the master DB on another server, and can switch over
if the master dies.
I'm wondering if others on this list have encountered a similar situation --
you finally architect your DB environment?