incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <>
Subject Re: How to migrate any relational database to Cassandra
Date Sun, 08 Aug 2010 02:36:08 GMT
are you using OrderPreservingPartitioner then?

On Sat, Aug 7, 2010 at 10:32 PM, Zhong Li <> wrote:
> Here is just my personal experiences.
> I recently use Cassandra to implement a system cross 5 datacenters. Because
> it is impossible to do it in SQL Database at low cost, Cassandra helps.
> Cassandra is all about indexing, there is no relationship naturally, you
> have to use indexing to keep all relationships. This is fine, because you
> can add new index when you want.
> The big pain is the token. Only one token you can choose for a node, all
> system have to adopt same rule to create index. It is huge huge pain.
> If Cassandra can implement token at CF level, it is much nature and easy for
> us to implement a system.
> Best,
> Zhong
> On Aug 6, 2010, at 9:23 PM, Peter Harrison wrote:
>> On Sat, Aug 7, 2010 at 6:00 AM, sonia gehlot <>
>> wrote:
>>> Can you please help me how to move forward? How should I do all the setup
>>> for this?
>> My view is that Cassandra is fundamentally different from SQL databases.
>> There
>> may be artefact's which are superficially similar between the two systems,
>> but
>> I guess I'm thinking of a move to Cassandra like my move from dBase to
>> Delphi;
>> in other words there were concepts which modified how you write
>> applications.
>> Now, you can do something similar to a SQL database, but I don't think you
>> would
>> be leveraging the features of Cassandra. That said, I think there will be
>> a new
>> generation of abstraction tools that will make modeling easier.
>> A perhaps more practical answer: there is no one to one mapping between
>> SQL
>> and Cassandra.

Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support

View raw message