How to migrate MYSQL to cassandra -special case in scoop+datastax

MySQL Table: User | PhoneNumber raman1234 bhuvan 2345 atul 5678 Using single Collection column and map collection : Phone Number --- Map Want to transform data in this way, i.e. key is

Re: how to migrate?

One final question: should I add new nodes as Brisk instances instead of my home brew cassandra + hadoop nodes? I've obviously already put in the pain/effort of learning how to run hadoop + cassandra… yes, make you life easier. create keyspace civicscience with replication_factor=3 and

Re: how to migrate?

create keyspace civicscience with replication_factor=3 and strategy_options = [{us-east:3}] and placement_strategy='org.apache.cassandra.locator.NetworkTopologyStrategy'; FYI the replication_factor property with the NTS is incorrect, the next(?) revision of 0.8 will raise an error on

how to migrate?

I was hoping to transition my simple cassandra cluster (where each node is a cassandra + hadoop tasktracker) to a cluster with two virtual datacenters (vanilla cassandra vs. cassandra + hadoop tasktracker), based on this: http://wiki.apache.org/cassandra/HadoopSupport#ClusterConfig The problem

Re: How to migrate any relational database to Cassandra

Maybe you could integrate with Hadoop. On Mon, Aug 9, 2010 at 1:15 PM, sonia gehlot sonia.geh...@gmail.com wrote: 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

Re: How to migrate any relational database to Cassandra

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

Re: How to migrate any relational database to Cassandra

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

Re: How to migrate any relational database to Cassandra

are you using OrderPreservingPartitioner then? On Sat, Aug 7, 2010 at 10:32 PM, Zhong Li z...@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

Re: How to migrate any relational database to Cassandra

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 z...@voxeo.com wrote: Here is just my personal

How to migrate any relational database to Cassandra

Hi All, Little background about myself. I am ETL engineer worked in only relational databases. I have been reading and trying Cassandra since 3-4 weeks. I kind of understood Cassandra data model, its structure, nodes etc. I also installed Cassandra and played around with it, like cassandra

Re: How to migrate any relational database to Cassandra

...@duergner.dewrote: In my opinion it's the wrong approach when so ask how to migrate from MySQL to Cassandra from a database level view. The lack of joins in NoSQL should lead to think about what you wanna get out of your persistent storage and afterwards think about how to migrate and most of the time how

Re: How to migrate any relational database to Cassandra

to migrate from MySQL to Cassandra from a database level view. The lack of joins in NoSQL should lead to think about what you wanna get out of your persistent storage and afterwards think about how to migrate and most of the time how to denormalize the data you have in order to insert

Re: How to migrate any relational database to Cassandra

On Sat, Aug 7, 2010 at 6:00 AM, sonia gehlot sonia.geh...@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