Delete record in aerospike

I could not understand why when I delete record and then restart aerospike record come back (it is again in the “set”)? Is it normal? How I can delete it forever?

You can’t, this is by design. It probably will be overwritten by another record, someday.

Best solution for now: don’t restart aerospike.

I find a cold-restart-empty option. Have you experience using it? Can it help me?

PS http://www.aerospike.com/docs/reference/configuration/#cold-start-empty

No, it does not get overwritten by another record. It gets picked up by the evictor and removed completely, it just doesn’t happen immediately. In general, it helps to read the manual:

https://www.aerospike.com/docs/architecture/#data-storage-layer https://www.aerospike.com/docs/architecture/storage.html#eviction-based-on-storage

@max83, yes, one solution is to issue an empty cold restart. The index will not be rebuilt from the disk, so no zombies may rise. However, if you have a lot of data it will have to be migrated over. This is similar to an empty new node joining the cluster. The usual cold restart attempts to shorten that process by keeping as much data as is available locally.

You would add the cold-start-empty line inside your namespace config, within the storage device block. Once the configuration file is modified you would issue a cold restart.

Aerospike 3.10.0 introduces durable deletes for Aerospike Enterprise. Learn more about how they work here: www.aerospike.com/docs/guide/durable_deletes.html.