I need to store a maximum of 200 billion records, each having 2 fields: A, and B, both strings of no more than 255 characters. I’ll be inserting records into this database at a pace of about 50 000 per second. About once a second, I’ll also be querying the database. All the queries will be the same: I’ll need all the records where the field A=X, for a given X string.
- Is it possible to use Aerospike to store such a database?
- What kind of hardware would I need to store it?