<div>Another option that seems to be very good for handling logs where you write quite a lot is Cassandra - <a href="http://cassandra.apache.org/">http://cassandra.apache.org/</a> - but of course you lose the SQL layer on top - unless you go for something like <a href="http://blog.mariadb.org/announcing-the-cassandra-storage-engine/">http://blog.mariadb.org/announcing-the-cassandra-storage-engine/</a> <br>
</div><div><br></div><div>This may not be completely off topic here because you get high data security / crash protection and parallel cluster writes, so you could insert tens/hundreds of thousands of events per second on a suitably dimensioned cluster for an Asterisk server cluster of similar size :)</div>
<div>l.</div><div><br></div><br><div class="gmail_quote">2012/9/28 Leif Madsen <span dir="ltr"><<a href="mailto:leif.madsen@asteriskdocs.org" target="_blank">leif.madsen@asteriskdocs.org</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5">On 27/09/12 11:45 AM, Matt Hamilton wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Date: Thu, 27 Sep 2012 10:23:35 +0200<br>
From: <a href="mailto:lenz.loway@gmail.com" target="_blank">lenz.loway@gmail.com</a><br>
To: <a href="mailto:asterisk-users@lists.digium.com" target="_blank">asterisk-users@lists.digium.com</a><br>
Subject: Re: [asterisk-users] MySQL InnoDB or MyISAM for CDR<br>
<br>
I'd go for MyISAM and would set up a remote replica if data integrity is important.<br>
<br>
If you have like 1000 calls of (say) 30 seconds avg length, and you create 10 events per call, you would expect an event every three seconds. This is about 300 inserts per second. Say 600 at peaks. This should be feasible with server-grade hardware without much difficulty. Also as you always INSERT it behaves as a log file (no seeking, no locking) if the table is optimized.<br>
l.<br>
<br>
<br>
We decided to go with MyISAM since it supports concurrent<br>
inserts (as you suggested). Data integrity (a slight loss of call records) is something we can live by. Right now we use DRBD for replication, but I guess with MyISAM it doesn't make much sense if the db crashes. We are looking into other options as well.<br>
</blockquote>
<br></div></div>
This may or may not be relevant, but you can also check out MySQL/Galera[0] for clustering solutions. Not sure if that gets you closer or further from your goal though :) It uses a modified InnoDB to allow a multi-master MySQL cluster.<br>
<br>
I used a chef cookbook to deploy it[1].<br>
<br>
[0] <a href="http://www.codership.com/content/using-galera-cluster" target="_blank">http://www.codership.com/content/using-galera-cluster</a><br>
[1] <a href="http://support.severalnines.com/entries/21453521-opscode-s-chef-mysql-galera-and-clustercontrol" target="_blank">http://support.severalnines.com/entries/21453521-opscode-s-chef-mysql-galera-and-clustercontrol</a><span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
-- <br>
Leif Madsen<br>
<a href="http://www.oreilly.com/catalog/asterisk" target="_blank">http://www.oreilly.com/catalog/asterisk</a></font></span><div class="HOEnZb"><div class="h5"><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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div>Loway - home of QueueMetrics - <a href="http://queuemetrics.com" target="_blank">http://queuemetrics.com</a><br></div><div>Test-drive WombatDialer beta @ <a href="http://wombatdialer.com" target="_blank">http://wombatdialer.com</a>
</div><br>