e.g. if multiple users are connecting to different nodes, they are inserting record with same key at the same time, how does aerospike sync up the data among the cluster, and which one will be last one to save in the database?
Writes always go to the master copy of the record. There will only be 1 master node for a given record, unless there is a split-brain/problem condition. Does that help answer your question?