[OpenSIPS-Users] High Reliable Couchbase Queries

[Jonathan Hulme]

Hi Vlad,

 

                I have ran some tests on level 4 (Debug) and when using
memcached driver I get the following:

DBG:core:cachedb_fetch: from script [memcached] - with grp [cbdb]

ERROR:cachedb_memcached:wrap_memcached_get: Failed to get: SERVER ERROR

 

If I use couchbase I get:

DBG:core:cachedb_fetch: from script [couchbase] - with grp [cbdb]

With no additional error information from within the driver itself.

 

I have created a PHP script, which loads a few million records into
couchbase, this also provides validation for each of the loaded records. 

 

After I load data, I can run the external script and achieve repeatable 100%
success rate (on validation), even if I load it up and hit 30K queries/sec
it does not drop a single one.

 

Regards Jonathan

 

From: users-bounces at lists.opensips.org
[mailto:users-bounces at lists.opensips.org] On Behalf Of Vlad Paiu
Sent: 28 July 2014 07:53
To: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] High Reliable Couchbase Queries

 

Hello,

The OpenSIPS cachedb layer connecting to the Couchbase server should not
change at all the actual success rate offered by the back-end.
Have you tried running the queries from within an external script and got a
better success rate ? Also, when the OpenSIPS queries are failing, what are
the errors that you are seeing in the log ?

Best Regards,



Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com 

On 27.07.2014 22:28, Jonathan Hulme wrote:

Hi,

 

                I understand that memcached is not designed to have 100%
success rate on hitting existing keys, but as far as I am know couchbase key
requests should, maybe it is the entire opensips caching layer which was
designed like this.

 

I am getting about 99.5%+ success rate on both memcache and native couchbase
driver, however this is too low for my required application.

 

I have tried concatenating 3 identical sequential queries to increase
success rate, but this makes no difference.

 

Can anyone suggest how I can improve the reliability of my queries to
couchbase, ideally internally within opensips. Alternatively a low latency
way if it has to go via an external system

 

Kind Regards

 

Jonathan






_______________________________________________
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/20140728/760c013c/attachment.htm>