I need to decide which database to use for a system where I need AP from CAP theorem. Data I constantly but slowly going in. Big queries are expected. It should be reliable – no single point of failure. I can use up to 3 instances on different nodes. In-memory solutions are bad for me because of data size –
it should be running for years and I expect up to terabyte data sizes. Most guys in my team prefer SQL. But I understand that traditional SQL databases are not fault tolerant in terms of hardware failure. Any ideas?
Advertisement
Answer
Amazon Redshift seems to be the best answer(thank you kuujo). But we will try rethinkdb because it has some nice feature