[asterisk-users] MySQL InnoDB or MyISAM for CDR

[Lenz Emilitri]

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 <leif.madsen at asteriskdocs.org>

> On 27/09/12 11:45 AM, Matt Hamilton wrote:
>
>>
>> Date: Thu, 27 Sep 2012 10:23:35 +0200
>> From: lenz.loway at gmail.com
>> To: asterisk-users at lists.digium.com
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121003/fe84a8f7/attachment.htm>