MySQL and FreeRADIUS environment

[Fajar A. Nugraha]

On Tue, Sep 27, 2011 at 11:32 PM, tonimanel
<antoniofernandez at fabergames.com> wrote:
> Hi everybody,
>
> In my company we are thinking to implement a FreeRADIUS server with MySQL on
> Linux. We need to duplicate FreeRADIUS service because we think that this is
> a critical service for us but the authentication process only could be done
> with the master server(FreeRADIUS and MySQL service, both in only one
> server). For the other hand, if we want to replicate the data base servers,
> we would have to synchronize two database servers but we would not know wich
> would be the best solution, cluster or synchronize. Maybe we will not to
> need a MySQL cluster service and we will need two servers only. First with
> master FreeRADIUS service and master MySQL service and the second with slave
> FreeRADIUS service and slave MySQL service.
>
> What do you think about the best solution to implement this environment?

Hire someone who have implement a similar setup.

There are many possible configuration with varying degrees of cost and
complexity, depending on how much you can tolerate a single point of
failure.

The easiest way would be to have two or more servers running FR with
one mysql master and many mysql slaves (FR and mysql can use the same
server), with distributed sql reads (i.e. SELECT) and writes only to
the master. In the event of failure, you need to manually (for maximum
consistency) promote one slave to be master.

The most complex way would be to setup a full mysql cluster, possibly
with each server acting as FR, data node, and sql node.

-- 
Fajar