I’m curious what the best way to do something functionality similar to what MongoDB’s upsert gives you. We need to take in values (integers) at a very high rate and slot them into the appropriate key value pairs. This means setting them to the first number if they don’t exist already, or adding th…

Let’s talk Python then. If key ‘foo’ exists you want to either initialize ‘counter’ to 3, or increment its value by 3: client = aerospike.client(config).connect() key = ('test', 'demo', 'foo') client.increment ( key, 'counter', 3, 3) If the key ‘foo’ does not exist you want to create the record w…

Thanks, with the exceptions it becomes clear how this should in theory reduce the chance of problematic multiple-client operations on the same key. BUT… we were really hoping to see an atomic operator from the db itself since we are handling thousands of transactions per second, so even ‘next line …

Hey Joshua. You can definitely write a UDF that wraps around it and just call it, but as UDFs have the performance penalty of invoking the Lua interpreter, it’ll probably be faster to do the logic in the app, especially since there are going to be more increments than record creations happening. Th…

I’d like to work through that with you. Let me know if you want to pursue it. Again, we’re working with transaction volumes outside of Mongo’s capability, though yes it has more features.

Absolutely, let me explain our potential use case more - I think it would help more than trying to pick apart Aerospike feature by feature. We want to store time series data with lots of “tags” - arbitrary key-value pairs to help us find the values we’re interested in. We are currently using Kairo…

I’ll get back to you with a more detailed answer soon. Right now I’m looking in the C client whether we can have the increment also create the key atomically if it doesn’t exist. It may be an artificial limitation on the clients wrapping around it, such as Python.

Alright, the Python and PHP clients do not behave correctly for increment(). It should create the record if none exists, then set the bin, similar to how append() behaves. Therefore: Increment should create both record and bin if the record does not yet exist · Issue #41 · aerospike/aerospike-clien…

That’s awesome, thank you for filing the bug. Any ideas on how best to use aerospike for our “counters with tags” problem? Or maybe aerospike isn’t a good fit for such a ‘search heavy’ and unbounded problem domain?

Hey Joshua, it’s implemented in the new Python client, release 1.0.38 . Regarding the counters scenario you mentioned, as we don’t yet support compound predicates (AND), I suggest you simply synthesize the data into the primary key for the counter record. Let’s assume this is a namespace ‘test’, se…

Awesome about the python client, I’ll try it right away! As for the schema, that’s about the same route I was going to take, but I wasn’t sure about the size of the key getting too big. We have 10 tags right now but that could grow quite a bit. I was wondering if we could actually put everything …

Mongo upsert-like capability?

How Developers Are Using Aerospike

Joshua_Buss March 10, 2015, 8:56pm 26

absolutely. Read with secondary indexes

Topic		Replies	Views
MySQL 'ON DUPLICATE KEY' Alternative How Developers Are Using Aerospike	13	4062	January 15, 2015
Command like redis incr :atomic increment operations How Developers Are Using Aerospike	23	16536	March 3, 2021
How well suited is Aerospike for this niche use case Data Modeling	6	2457	June 30, 2016
Designing map behavior using set in aerospike	2	1218	May 4, 2016
How do incrementations work on bins containing maps that contain counters Data Types aws , counter	0	1637	June 27, 2016

Mongo upsert-like capability?

Related topics