Re: [GENERAL] Postgres High Availablity Solution needed for hot-standby and load balancing
Hi Usama yes, currently I am reading a brochure about Continuent uni/cluster for PostgreSQL. Looks quite interesting. Another product sounds promising: Cybercluster from www.postgres.at English Product Description: http://www.postgresql.at/picts/download/dokumentation/documentation_cybe rcluster.pdf Anyone has made experiences with it? thanks Ragnar From: Usama Dar [mailto:[EMAIL PROTECTED] Sent: Freitag, 30. November 2007 10:35 To: Ragnar Heil Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres High Availablity Solution needed for hot-standby and load balancing On 11/29/07, Ragnar Heil <[EMAIL PROTECTED]> wrote: Hi our customer has got the following requirements: Req1) Master master replication supported, not only master / slave replication with only the master being writable. If you do have multiple slave systems they are only useful from a backup and standby perspective. Our Application must have a db-connection it can write to. Req2) Replication of schema should also be possible, not only data Req3) Not only a hot-standby-solution is needed. Load Balancing is wanted for the future. Currently I am looking at EnterpriseDB but it seems that they dont support multiple master-replication best regards Ragnar ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ Have you looked at pgCluster or Continuent's uni/Cluster? -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Postgres High Availablity Solution needed for hot-standby and load balancing
WHich solution are you using now, Guido? Has anyone made experiences with cybercluster? I am thankful to hear comments and especially comparision to other products thanks Ragnar > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Guido Neitzer > Sent: Freitag, 30. November 2007 21:03 > To: Shane Ambler > Cc: Postgresql General > Subject: Re: [GENERAL] Postgres High Availablity Solution > needed for hot-standby and load balancing > > On 30.11.2007, at 12:50, Shane Ambler wrote: > > >> I project where the "latest news" page shows the newest entry from > >> March 2005 and the install talks only about PostgreSQL 8.0 isn't > >> really inspiring confidence ... > > > > Although they aren't the fastest with releases, they really > aren't as > > bad as that. > > Nicely said ... ;-) Yeah, I was looking at the wrong site. > Maybe there should be a redirect to the new page to avoid that. > > I have last looked at pgcluster back in 2005 when I was > trying to find an affordable multi master solution an the > setup sounded so horrific that we spent about 10k EUR to get > a different solution that is actually working fine now. > Setting this up on just two machines was about 10 minutes work ... > > I hope the setup has changed to the better. > > cug > > ---(end of > broadcast)--- > TIP 5: don't forget to increase your free space map settings > ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] Fault Tolerance & Master-master-Replication Solution needed
Hi, I am searching for a Fault Tolerance & Master-master-Replication Solution which fulfills these requirements Req1) Master master replication supported, not only master / slave replication with only the master being writable. If you do have multiple slave systems they are only useful from a backup and standby perspective. Ad Mo must have a db-connection it can write to. Req2) A plan is needed for deploying changes on the database structure. What needs to be done to apply a change saved into a live db environment? Req3) Not only a warm-standby-solution is needed which is not scalable. Load Balancing is wanted for the future. Do you have experience with Cybercluster or Continuent uni/cluster? Sounds very promising. best regards Ragnar ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] Postgres High Availablity Solution needed for hot-standby and load balancing
Hi our customer has got the following requirements: Req1) Master master replication supported, not only master / slave replication with only the master being writable. If you do have multiple slave systems they are only useful from a backup and standby perspective. Our Application must have a db-connection it can write to. Req2) Replication of schema should also be possible, not only data Req3) Not only a hot-standby-solution is needed. Load Balancing is wanted for the future. Currently I am looking at EnterpriseDB but it seems that they dont support multiple master-replication best regards Ragnar ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/