<p>Sorry for the top post, but I am using a silly mail client. I havent talked about ndb tables, just multimaster setup. It is really stable if done with just two mysql servers. I am running a couple of asterisk servers sharing a common cdr and cnam database for at least 3 years without problems. Simple Mysql multimaster replication is really solid and easy to setup and maintain. Dont forget to handle the autoincrement columns with a distinct starting point and a common step, greater than one of course!</p>
<p>Leandro</p>
<div class="gmail_quote">Il giorno 10/feb/2012 14:23, "Vieri" <<a href="mailto:rentorbuy@yahoo.com">rentorbuy@yahoo.com</a>> ha scritto:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
--- On Fri, 2/10/12, Leandro Dardini <<a href="mailto:ldardini@gmail.com">ldardini@gmail.com</a>> wrote:<br>
<br>
> mysql multimaster replication and<br>
> asterisk realtime.<br>
<br>
Just a word of caution: I've had terrible luck with MySQL NDB tables in a multimaster setup. I'm not a big expert but v.5.0 and 5.1 have given me lots of reliability issues (I lost table data several times).<br>
I'd like to try postgresql in a multimaster setup.<br>
<br>
Realtime with a clustered database is a nice idea but is it reliable? Any long-term success stories?<br>
<br>
Vieri<br>
<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div>