Simple 2 Server High Availability

[James Bensley]

Hi All,

I've had a scan of the archives and the Internet;

I wish to deploy two new FreeRADIUS servers for a new network. I don't
need fancy floating IPs like with LVS, incoming requests are
load-balanced across both server IPs (but the session are "sicky" in
that they always go to the same RADIUS once established). So all I
need (I believe) is master-master MySQL replication so that
authentication can be made against either RADIUS and updates like new
users etc are replicated beween the two.

For many people "master-master" is a bad phrase, is anyone doing this
successfully? Post reading all I seem to need is the power of
auto_increment_offset and auto_increment_increment to make my MySQL
repliation safe from PK clashing issues.

Can anyone who is doing this confirm what they have done or have you
tried this and it failed terribly? If you have two servers for
load-balacning how have you done it if you are using a different
configuration?

Cheers,
James.