failover and load balancing

Meyers, Dan d.meyers at lancaster.ac.uk
Wed Apr 22 11:54:00 CEST 2009


<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
Network Specialist, Lancaster University
E-Mail: d.meyers at lancaster.ac.uk




More information about the Freeradius-Users mailing list