Absolutely new (and ignorant) to NoSQL solutions and to Couchbase (my
apologies; but extensive experience with SQL RDBMS).
We consider a NoSQL DB deployment for a mission-critical application where
we need to store several hundreds of millions of data records, each record
consisting of about 6 string fields, record total length is 160 bytes.
There is a unique key in each record that seems suitable for hashing (20+
bytes string, e.g. "cle01_tpls01_2105328884").
The application should be able to write several hundreds of new records per
second, but first check if the unique key already exists. Writing is to be
done only if it is not there. If it is, the app needs to retrieve the whole
record and return it to the client and no writing is done in this case.
We need to have a cluster of at least 2-3 nodes, which must be able to grow
easily if a need be.
I need to know if Couchbase would be suitable for such application. Please,
advice, thank you!