I have a specific requirement for storing financial related transactions. This requires transaction support, high availability, fault tolerance and horizontal scalability. I am looking for an open source solution.
Now as I understand none of the free RDBMS (the likes of Postgres or MySql) provide this. I have used cassandra for a previous project which had great amount of convenience in terms of replication & sharding. Wow, I love it for its performance as well. But unfortunately there is no ACID transactions support from Cassandra because it was built with CAP theoram in mind.
Now, I am not even particular about great/blazing fast performance. I am looking for a performance little more than or equal to an RDBMS, but with replication & sharding. The reason is we are looking for putting many servers for handling the load and each instance should be capable of serving some x client at any point in time.
Can any one think of either a free(or very cost-effective sub 500 dollar) RDBMS database or No sql store with - transaction support (commit/rollback) - replication - sharding.
Currently we have ravendb in the choices list. Do you think this would fit?
PS: I've taken a look at the following links Can you recommend a database that scales horizontally? - was discussed in 2008 and very old.
RavenDB would be a good batch. It can scale horizontally, support sharding and replication out of the box. It has ACID transactions and automatic failover.
See here for more details: http://ravendb.net/features