failover and load balancing

[Michael Schwartzkopff]

Am Mittwoch, 22. April 2009 15:20:11 schrieb Uwe Kastens:
> Hello,
>
> >>> 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 :)
> >>
> >> What is your need? More Read than write? Mabye think about mysql proxy
> >> or some free cluster option.
> >
> > First the disclaimer:
> >
> > I have not used this only read about it!
> > What about pgpoolII?
> > supposedly a PostgreSQL master-master replication package
>
> I think there might be much more read access then write access by using
> a DB backend for RADIUS. If so it might be enough to have one master to
> write and many slaves to read from. Or many master with a kind of sql
> proxy like Sequoia or mysql-proxy. The problem with master master for
> mysql is, that you have to resync each time you are dropping a table, a
> view etc.pp.
>
> BR
>
> uwe


It depends on what you are doing. If you want to read out you user database 
for authentication you are right. But If you want to write accouting you have 
a lot of writes. I have seen up to 300 writes/sec for a small national 
provider.

Greetings,
-- 
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