Aerospike Bin Data deletion

Abhinav_Gupta1 · February 1, 2021, 6:30pm

Hey! We have a usecase to deprecate a bin from our Aerospike Cluster.

Can someone help me out with the different options that we have come across to understand the pros and cons of each? Say bin to be deprecated - binToBeDeleted

Setting a value of null to binToBeDeleted for each record key
Giving ttl of say 1 day to each record for binToBeDeleted
Writing a UDF to delete the bin from each record and doing rolling restart for Aerospike.

Factors to keep in mind would be the compute used for deletion and the storage space saved. Thanks and Regards!

Abhinav_Gupta1 · February 2, 2021, 6:01am

@kporter @rbotzer Would really appreciate if you could help me out with this query. Thanks in advance

meher · February 2, 2021, 10:59pm

Is the end goal to get back from the bin quota? (And eventually follow this process: How to clear up set and bin names when it exceeds the maximum set limit ?).

Should work for sure.
Not sure why you would give a TTL on the whole record… is the intent to delete the full record or just the bin?
That should work as well but I think this can even be done with background operations which should be lighter compared to UDFs.

Abhinav_Gupta1 · February 3, 2021, 7:03am

@meher Thanks for replying.

We have not reached the bin quota so that is not a concern for us right now. Our end goal being reducing the overall disk size used for our Aerospike cluster, hence deleting the unused bin.

Regarding point 2, sorry I meant giving a TTL to binToBeDeleted. Intent is just to “delete the bin”