Bryan,
> How can you sync 2 database to be identical in the case of a failover,
> where one server goes down, the other already has all of the correct
> info, then if the primary comes live, the secondary sync's all of it
> data back?
With a lot of work. Or by paying $$$$ to a contractor.
Or by waiting to Jan Wieck's new replication engine, expected in 6 months or
so.
What's your deadline & params?
--
Josh Berkus
Aglio Database Solutions
San Francisco