Aerospike vs. Google Cloud Spanner

We were developing an advertisement time auction application, where we had to store the client's personal details, advertisement-related details, location, and many other details. Moreover, we required a promotion, cookies, and a few more details from the front end. All this information is heavy in terms of size and cannot be lost if the server crash. So, we required an extremely fast disk database with high scalability and low throughput.

Incentivized

If you have a large relational database and it is growing fast on daily basis, and if you have a strong need in ACID across all your clusters, and most importantly, if you need to maintain high availability in a large region, Google Cloud Spanner can be a very good choice.

Incentivized

• featured with robustness and reliability
• low hardware resource consumption especially RAM
• open-source
• distributed no-sql server

Incentivized

• Super high availability
• Scales automatically
• High standard SLA

Incentivized

• AQL is pretty limited and not as useful as the java client
• Documentation can be lacking for some products
• replication configuration is complicated

Incentivized

• Support for Views
• Support for more databases (schemas).
• More index types that can be supported (Functional)
• Backups (ie table/data backup) if data is deleted or truncate by accident.

Incentivized

If money isn't an issue, and you're not on the cloud, then I'd go with Aerospike. If you're the cloud ie, aws or azure, then i'd stick with dynamoDB or Cosmos then. Aerospike is definitely not something you want to put into the cloud. It doesn't work well w/ cross regions. If cross DC, you'll have to write some stuff for data integrity checks.

Incentivized

Could be easier to use and install. Also developer experience needs some work

We used the community edition.

Incentivized

Aerospike is much more performant than MongoDB, however there is much greater community adoption and support for mongo

Incentivized

Spanner scales quickly compared to Amazon RDS. Azure Database is about the same as well. MongoDB can scale to horizontal scalability, however, because Mongo doesn't support full ACID, Spanner comes into that aspect. GCP Cloud SQL not as scalable as Spanner. Spanner has more functionality than MongoDB and Amazon RDS & Azure Databases.

Incentivized

• Being able to power the same workload on a fraction of the servers has led to better ROI for my application.
• Less servers needed also meant less time to manage the cluster, leading to savings in engineering time

• Backups specifically if transactional data is deleted. Restoring made us lose time.
• Sharding on Horizontal level was quick and easy. Deployment and increasing nodes is easy
• Large dataset handling.
• ACID compliance

Incentivized