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