Thread: Continuent (was: Postgres Clustering)
Hmmm. Anyone out there have the Continuent solution working with PostgreSQL? If so, what release? We're at 8.3 right now. thanks, -Alan p.s. I'm continuing the cross-post because that is the way I started this thread. Future threads will not be cross-posted. On Thu, May 28, 2009 at 9:34 AM, Scot Kreienkamp <SKreien@la-z-boy.com> wrote: > We didn't have much luck with Continuent. They had to make multiple > code level changes to get their product to work correctly with our app > on PG 8.2. We never did get it successfully implemented. At this point > I'm stuck with WAL shipping as I can't find anything that fits my > constraints. > > Thanks, > > Scot Kreienkamp -- “Mother Nature doesn’t do bailouts.” - Glenn Prickett
----- "Alan McKay" <alan.mckay@gmail.com> escreveu:
> Hmmm. Anyone out there have the Continuent solution working with PostgreSQL?
> If so, what release? We're at 8.3 right now.
I have tested Sequoia 2.10.10 with a high transaction rate database with good servers and plenty of memory. Since that's a OLTP system the performance droped to as low as 30%.
I can't recomend their solution for a OLAP system because I never tested in this situation.
Configuration of Sequoia is quite complicated and I think a very good Database Administrator is needed to keep it working correctly and nodes syncronized.
Sequoia also is very complicated to run ddl and dml scripts since your scrips should be written for Sequoia, not for PostgreSQL.
If log-shipping works for you, try Slony. Your slaves can serve as read-only databases and you can distribute some load.
Flavio
> Hmmm. Anyone out there have the Continuent solution working with PostgreSQL?
> If so, what release? We're at 8.3 right now.
I have tested Sequoia 2.10.10 with a high transaction rate database with good servers and plenty of memory. Since that's a OLTP system the performance droped to as low as 30%.
I can't recomend their solution for a OLAP system because I never tested in this situation.
Configuration of Sequoia is quite complicated and I think a very good Database Administrator is needed to keep it working correctly and nodes syncronized.
Sequoia also is very complicated to run ddl and dml scripts since your scrips should be written for Sequoia, not for PostgreSQL.
If log-shipping works for you, try Slony. Your slaves can serve as read-only databases and you can distribute some load.
Flavio