Comprehensive request for cassandra

Question

I heard about the cassandra database engine a few days ago and was looking for good documentation for it. after studying on cassandra i got cassandra more scalable than other engine data. I also read about Amazon SimpleDB, but since SimpleDB has a 10GB / table limit and Google Datastore is slower than Amazon SimpleDB, I prefer not to use them (Google Datastore, Amazon SimpleDB). Thus, in order to make our site scalable, especially the high level of recording with massive data, I like to use Cassandra as our Data Engine.

But before I start using cassandra, I am confused: "How to handle complex data using casssandra." I give you the MySQL database structure below, please read this and give me a good suggestion.

User table
hasColum ID Primary
hasColum email Unique
hasColum FirstName
hasColum LastName

Category table
hasColum ID Primary
hasColum Parent
hasColum Category

Message table
hasColum ID Primary
hasColum UID Index foreign key associated with
users- > hasColum ID CID Index - foreign key associated with Category-> ID
hasColum Title Security
index hasColum
hasColum PunDate

hasColum ID
hasColum UID , - > ID
hasColum PID Index - , Posts- > ID
hasColum Comment

hasColum ID
hasColum Name

UserToGroup ( - )
hasColum UID , Users- > ID
hasColum GID, Group- > ID

, SimpleCassie PHP Class http://code.google.com/p/simpletools-php/ , , SimpleCassie

Answer 1

wiki cassandra:

, , , Cassandra , , . , , : . ;

goog .

, .

Answer 2

, , , , , , 10k + .

, , . , , , . (, cassandra/hbase/etc) , . ( , , ) , . pk-fk.

cassandra ( ) api.

:

getAllUserPosts($userId) api, : UserPosts ColumnFamily ColumnFamily ( ). , ? , , , , TimeUID , uids. , " ", .

, - cassandra, api , , , , , . , " ", . , ( , ). , , - , cassandra: , . Hadoop.

PS: , , , , . , , .

Answer 3

. . Twissandra.com http://github.com/ericflo/twissandra

http://wiki.apache.org/cassandra/ArticlesAndPresentations

Answer 4

Twissandra (Twitter clone on Cassandra), . http://www.rackspacecloud.com/blog/2010/05/12/cassandra-by-example/

Answer 5

Are you really competing with Google and Amazon in terms of traffic? I would recommend starting with a study of upgrading your existing MySQL infrastructure - how many database servers do you currently use in your clusters? Share the data?

WITH.