[OpenSIPS-Users] Solution to storing a lot of siptrace

Jon Abrams ffshoh at gmail.com
Fri Dec 8 15:21:40 EST 2017

You might try using TokuDB table storage for MySql/MariaDB without
compression. The penalty for indexing is much reduced over InnoDB.

You might also replicate the sip traces off your live proxy to another
OpenSIPs capture node and let that node handle the inserts. Take a look at
Web Homer as well.

On Fri, Dec 8, 2017 at 1:43 PM, Daniel Zanutti <daniel.zanutti at gmail.com>

> Hi
> I have around 2000 simultaneous calls, 50 CPS and would like to store sip
> trace for all of them.
> Storing on MySQL is not working. If you have some indexes on the table,
> after 1M register it starts to slow down the whole server. If no indexes,
> it's not searchable.
> Do you guys have a good solution to store a lot of sip trace on Opensips?
> Like 200 GB.
> It needs to be searchable almost real-time (a few minutes is fine).
> I was thinking on store on a flat text file and move to a NOSQL solution,
> what do you guys think?
> Thanks
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20171208/2476bd53/attachment.html>

More information about the Users mailing list