Another option that seems to be very good for handling logs where you write quite a lot is Cassandra - http://cassandra.apache.org/ - but of course you lose the SQL layer on top - unless you go for something like http://blog.mariadb.org/announcing-the-cassandra-storage-engine/
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 :) l. 2012/9/28 Leif Madsen <[email protected]> > On 27/09/12 11:45 AM, Matt Hamilton wrote: > >> >> Date: Thu, 27 Sep 2012 10:23:35 +0200 >> From: [email protected] >> To: [email protected] >> Subject: Re: [asterisk-users] MySQL InnoDB or MyISAM for CDR >> >> I'd go for MyISAM and would set up a remote replica if data integrity is >> important. >> >> 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. >> l. >> >> >> We decided to go with MyISAM since it supports concurrent >> 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. >> > > 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. > > I used a chef cookbook to deploy it[1]. > > [0] http://www.codership.com/content/using-galera-cluster > [1] > http://support.severalnines.com/entries/21453521-opscode-s-chef-mysql-galera-and-clustercontrol > > > -- > Leif Madsen > http://www.oreilly.com/catalog/asterisk > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > -- Loway - home of QueueMetrics - http://queuemetrics.com Test-drive WombatDialer beta @ http://wombatdialer.com
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
