Thanks,
it's good solution.
My billing solution collect acc table each one hour. I will write other
script to puch flatstore's file in acc DB each one hour or other
frequencies.
In "harmony" with billing team ;)
bye
Le 08/03/2013 15:47, Bogdan-Andrei Iancu a écrit :
Hi Mickael,
Use the db_flatstore engine for acc (as SQL backend) to write Acc data
on files on disk. You can later import this files into DB without
affecting or slowing down opensips.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 03/08/2013 02:39 PM, Mickael HUBERT wrote:
Hi list,
I have a issue when my backend mysql (to acc's table) is slow (it's
mysql server shared between differents services).
Endeed Opensips slowed too to SIP processing or if mysql crash,
Opensips crash too.
My Acc's table is the only realtime table.
Is there any method to improve this ? Opensips cache's service ?
external services ?
my db_mysql's module conf:
/# ----------------- module db_mysql ---------------//
//loadmodule "db_mysql.so"//
//# ----- db_mysql params -----//
//modparam("db_mysql", "ping_interval", 60)//
//modparam("db_mysql", "timeout_interval", 2)/
my acc's module conf:
/# ----------------- module acc ---------------//
//loadmodule "acc.so"//
//# ----- acc params -----//
//modparam("acc", "early_media", 1)//
//modparam("acc", "report_cancels", 1)//
//modparam("acc", "detect_direction", 0)//
//modparam("acc", "failed_transaction_flag", '3')//
//modparam("acc", "log_flag", '1')//
//modparam("acc", "log_missed_flag", '2')//
//modparam("acc", "db_flag", '1')//
//modparam("acc", "db_missed_flag", '2')//
//modparam("acc", "db_url",
"mysql://u_opensips:*****@*****/hexasipbeta")//
//modparam("acc", "db_extra", "caller_id=$fu; callee_id=$rU;
source_ip=$avp(sourceip); ai=$avp(userai); pu=$pU;
provider_id=$avp(providerid); reason=$avp(reason); display_name=$fn")//
//modparam("acc", "log_facility", "LOG_LOCAL1")/
thanks in advance
Mickael
_______________________________________________
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
