incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Prescod <p...@prescod.net>
Subject Re: How to import data from MYSQL to Cassandra
Date Fri, 02 Jul 2010 06:01:32 GMT
As Paul said, you need to re-build your data in a Cassandra-friendly
manner. Reading SQL files does not seem a very efficient way to do
that though. Most databases can output in much simpler formats, like
CSV. But then, why export at all? If the MySQL instance and the
Cassandra instance are both addressable over the same network, you
could just write a program that reads data from one, reorganizes it
and writes it to the other.

On Thu, Jul 1, 2010 at 1:33 PM, Rana Aich <ranaaich@yahoo.com> wrote:
> Hi,
>
> Can someone please please throw some light how can I import the Data from mysql into
Cassandra cluster.
>
> - Is there any tool available?
> OR
> - Do I have to write my own Client using Thrift that will read the export file (*.sql)
and insert the record in the database.
>
> Thanks
>
> raich
>
>
>

Mime
View raw message