Re: [GENERAL] Log-based repliaction?

2006-10-21 Thread Joshua D. Drake
*) boss has decided that a failover solution is important and should be prioritied in 2007 ... even to the point where he's willing to of throw money at it. If anyone have experiences with failover-solutions built over a SAN, and can do consultancy services for us, please send me a private

Re: [GENERAL] Log-based repliaction?

2006-10-21 Thread Tobias Brox
[Joshua D. Drake - Sat at 08:14:51AM -0700] 1. Slony - Trigger based I don't know ... I'm not overly happy with the idea of using triggers for the replication. I'm a bit concerned about the overheads, both on the primary database server as well as the administrative costs setting it up and

[GENERAL] Log-based repliaction?

2006-10-20 Thread Tobias Brox
I would eventually like to: 1) find a way to (stress) test a mockup database server. 2) fix a near-realtime replication of our production database server for pulling out statistics and reports. Minor bugs would be permitable in such a setup. We don't need a full-fledged data