+1 for Homer. Nosql also seems a good idea.
Arsen Semionov www.eurolan.info cell: +442035198881 On Fri, Dec 8, 2017 at 10:21 PM, Jon Abrams <[email protected]> wrote: > 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 <[email protected]> > wrote: > >> 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 >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
