What is the best solution if I need to have a database with a billion + objects, and I need to immediately (or almost immediately) access any of the elements in the database at any time.
This database will be queried at approximately 1000 queries per second. The rows in the database are fairly unrelated and therefore should not be relational.
If you're wondering why, for modeling moving elements.
I was thinking of something like several balanced loads of Cassandra clusters accessed through a load balanced cluster of web servers.
Money is a factor, so the cheaper the better. There are no restrictions on the software or tool, however it must be open.
Just looking for a database solution that would be useful for processing a ridiculous amount of data (generally not necessarily to be relational) by a large number of users.
It is important that it handles redundancy and errors.
Just a high level idea to put me in the right direction would be great.
source
share