also ,,,

each node (FR+MySQL) is connected to different NAS server like this :

Cisco NAS1 --> Node1 (FR+MySQL) <==> Node2(FR+MySQL) <-- Cisco NAS2

This is what we need to deploy exactly ,

so does the master-master replication is suited enough to accommodates our needs or there is any better recommendations .

Thanks in Advance ,

On Tue, May 24, 2011 at 11:48 AM, Fajar A. Nugraha <list@fajar.net> wrote:

On Tue, May 24, 2011 at 3:40 PM, Student University <studentmf@gmail.com> wrote:
> Hi,
>
> my testing lab like this :
>
> Node1 (FreeRadius+MySQL)
> Node2 (FreeRadius+MySQL)
>
> i am setting Master-Master MySQL Replication between this two node ,

Master-Master seems easy, but needs proper care. For example:
- have you taken care of auto increment values? What if there's
concurrent insert of different acct record to both sql node, will they
have the same radacctid?
- what happens when an acct-start got to node 1, but before the change
was replicated, an acct-stop for the same session got to node 2? Can
your sql query/replication setup handle that?

--
Fajar

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html