I am exploring Aerospike for one of my projects. Have configured device as my storage-engine (ssd ("~250GB")). RAM per box in the cluster is "~50GB".
My question : Will setting "data-in-memory true" give any significant boost to the cluster performance ? I tried benchmarking writes to the Aerospike cluster first by setting "data-in-memory true", than "data-in-memory false". There was no significant boost/drop in the performance. Does it really makes sense to put "data-in-memory true" here (alongside an SSD). Please suggest.
You are correct, the impact on writes is not going to be noticeable, in fact, it probably will be exactly the same. data-in-memory true will boost read performance by having those served out of memory as opposed to from storage. Finally, you can also check the post-write-queue setting to have in-memory performance on reads for records that were recently inserted/updated.