<div dir="ltr">also ,,,<br><br>each node (FR+MySQL) is connected to different NAS server like this :<br><br>Cisco NAS1 --> Node1 (FR+MySQL) <==> Node2(FR+MySQL) <-- Cisco NAS2<br><br>This is what we need to deploy exactly ,<br>
<br>so does the master-master replication is suited enough to accommodates our needs or there is any better recommendations .<br><br><br>Thanks in Advance ,<br><br><div class="gmail_quote">On Tue, May 24, 2011 at 11:48 AM, Fajar A. Nugraha <span dir="ltr"><<a href="mailto:list@fajar.net">list@fajar.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Tue, May 24, 2011 at 3:40 PM, Student University <<a href="mailto:studentmf@gmail.com">studentmf@gmail.com</a>> wrote:<br>
> Hi,<br>
><br>
> my testing lab like this :<br>
><br>
> Node1 (FreeRadius+MySQL)<br>
> Node2 (FreeRadius+MySQL)<br>
><br>
> i am setting Master-Master MySQL Replication between this two node ,<br>
<br>
</div>Master-Master seems easy, but needs proper care. For example:<br>
- have you taken care of auto increment values? What if there's<br>
concurrent insert of different acct record to both sql node, will they<br>
have the same radacctid?<br>
- what happens when an acct-start got to node 1, but before the change<br>
was replicated, an acct-stop for the same session got to node 2? Can<br>
your sql query/replication setup handle that?<br>
<br>
--<br>
<font color="#888888">Fajar<br>
</font><div><div></div><div class="h5">-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br></div>