cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sonia gehlot <sonia.geh...@gmail.com>
Subject Re: How to migrate any relational database to Cassandra
Date Mon, 09 Aug 2010 05:15:49 GMT
Hi Guys,

Thanks for sharing your experiences and valuable links.... these are really
helpful.

But I want to do ETL and then wanted to load data in Cassandra. I have link
10-15 various source system, presently daily ETL jobs runs load data in our
database which is Netezza. How can I do this in Cassandra, like what if my
target data base is source are the same (MySQL, Oracle, Netezza..etc)?

-Sonia

On Sat, Aug 7, 2010 at 7:46 PM, Zhong Li <zli@voxeo.com> wrote:

> Yes, I use OrderPreservngPartitioner, the token considers
> datacenter+ip+function+timestamp+recordId+...
>
>
> On Aug 7, 2010, at 10:36 PM, Jonathan Ellis wrote:
>
>  are you using OrderPreservingPartitioner then?
>>
>> On Sat, Aug 7, 2010 at 10:32 PM, Zhong Li <zli@voxeo.com> 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 <sonia.gehlot@gmail.com>
>>>> 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
>> http://riptano.com
>>
>
>

Mime
View raw message