zenguru
asked on
what NoSQL based datastore do u recommend from your experience
Suppose there is highly interactive and very high traffic website (10,000 visitors per day) with interactive content and gaming applications that requires each game move to be persisted to datastore along with over a million user profiles. Think of games like farmville etc.
The requirement is that datastore must be based on one of NoSQL datastores. No relational database like MySQL can be used in any place in the whole web application.
Extremely high performance like super fast writes and reads is number one requirement.
Second most important requirement is data security and automatic fail over in case one part of datastore gets corrupted, another takes over.
Third requirement it should be open source and free for commercial use.
Fourth requirement good tools should be avaialble to admin and query the datastore during development time like we have tools MySQLWorkbench for MySQL database.
I notice a whole bunch alternative in the NoSQL space like:
Membased, Cassandra, Redis, Hadoop, BigTable etc.
From your experience what do you recommend and why given the above requirements?
The requirement is that datastore must be based on one of NoSQL datastores. No relational database like MySQL can be used in any place in the whole web application.
Extremely high performance like super fast writes and reads is number one requirement.
Second most important requirement is data security and automatic fail over in case one part of datastore gets corrupted, another takes over.
Third requirement it should be open source and free for commercial use.
Fourth requirement good tools should be avaialble to admin and query the datastore during development time like we have tools MySQLWorkbench for MySQL database.
I notice a whole bunch alternative in the NoSQL space like:
Membased, Cassandra, Redis, Hadoop, BigTable etc.
From your experience what do you recommend and why given the above requirements?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. I should mention the server would be entirely linux based and no MS$ is involved anywhere.
GemsStone/S is Linux and MacOS only but you can program it from every platform where Pharo runs.
Regards
Friedrich
Regards
Friedrich
This seems a bit like a homework question.
"must be based on one of NoSQL datastores. No relational database"
"NoSQL" does not mean non relational. It just means not SQL.
"must be based on one of NoSQL datastores. No relational database"
"NoSQL" does not mean non relational. It just means not SQL.
I suggest Apache Hadoop. It's gaining ground very fast...
Also you can check out Voldemort, distributed key-value storage system, recently published by LinkedIn, under Apache 2.0:
http://project-voldemort.com/
and also Sensei, distributed, horizontally scaled database that supports SQL-type queries:
http://sna-projects.com/sensei/
The whole family:
http://sna-projects.com/
Also you can check out Voldemort, distributed key-value storage system, recently published by LinkedIn, under Apache 2.0:
http://project-voldemort.com/
and also Sensei, distributed, horizontally scaled database that supports SQL-type queries:
http://sna-projects.com/sensei/
The whole family:
http://sna-projects.com/
Because of the probably quite massive parallel accessings to it, thinking about using Erlang for it may be a worthwhile consideration.
Homepage couchedb: http://couchdb.apache.org/
Homepage of Erlang: http://www.erlang.org/