failover and load balancing

[Michael Schwartzkopff]

Am Mittwoch, 22. April 2009 11:54:00 schrieb Meyers, Dan:
> <snip>
>
> > I use a PostgreSQL DB form my three AAA server and the DB is enough
> > quick for serveral request per second.
>
> Aah. We were wanting to handle 100 or so requests a second. Postgres
> might well have done this, but we wanted room for expansion and our
> tests with 10'000 requests at ~100 a second showed Postgres being
> noticeably slower than MySQL. As long as it's good enough for your
> purposes there's no reason to switch though.
>
> > However, I am looking for a (free) master-master DB, and the
> > replication in postgres crashes. And the problem in MySQL it was told
> > before.
> >
> > I admit suggestions for a BETTER free DB.
>
> We had a good look and were unfortunately unable to find anything for
> free. If you can deal with master-slave, MySQL seems to be the best bet.
> If you must have master-master, you're out of luck until Postgres gets
> it working or someone else implements it. It seems that to get something
> like this you'll have to end up paying Oracle or someone similar a fat
> pile of money.
>
> I could be wrong, there might be one we've missed. If so, i'd love to
> know as well, as master-master replication would make our lives easier
> too :)
>
> --
> Dan Meyers


Hi,

I never tried it myself, but I know the author. He is quite good. so my advise 
would be cybercluster. See:
http://www.postgresql.at/english/pr_cybercluster_e.html

-- 
Dr. Michael Schwartzkopff
MultiNET Services GmbH
Addresse: Bretonischer Ring 7; 85630 Grasbrunn; Germany
Tel: +49 - 89 - 45 69 11 0
Fax: +49 - 89 - 45 69 11 21
mob: +49 - 174 - 343 28 75

mail: misch at multinet.de
web: www.multinet.de

Sitz der Gesellschaft: 85630 Grasbrunn
Registergericht: Amtsgericht München HRB 114375
Geschäftsführer: Günter Jurgeneit, Hubert Martens

---

PGP Fingerprint: F919 3919 FF12 ED5A 2801 DEA6 AA77 57A4 EDD8 979B
Skype: misch42