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
