Re: Migrating from mySQL to Cassandra

2013-03-04 Thread Steven Siebert
Since your just starting out and it seems like you want to get past the admin hurdles and start coding, may I suggest you use https://github.com/pcmanus/ccm to get your local test environment setup. Setting up a production Cassandra cluster takes a fair amount of planning (before) and tuning

Re: Migrating from mySQL to Cassandra

2013-03-04 Thread John Grogan
Thanks Steven - I will take a look. On 4 Mar 2013, at 11:41, Steven Siebert wrote: Since your just starting out and it seems like you want to get past the admin hurdles and start coding, may I suggest you use https://github.com/pcmanus/ccm to get your local test environment setup.

Re: Migrating from mySQL to Cassandra

2013-03-04 Thread Tyler Hobbs
On Mon, Mar 4, 2013 at 5:08 AM, John Grogan vangu...@dir-uk.org wrote: A quick question for you - I am completely new to noSQL databases and the architecture of Cassandra. So, I'm still way down the learning curve. I downloaded and installed the OpsCenter last night, but I first need to

Re: Migrating from mySQL to Cassandra

2013-03-04 Thread Hiller, Dean
@cassandra.apache.orgmailto:user@cassandra.apache.org Date: Monday, March 4, 2013 9:47 AM To: user@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: Migrating from mySQL to Cassandra On Mon, Mar 4, 2013 at 5:08 AM, John Grogan vangu...@dir

Migrating from mySQL to Cassandra

2013-03-03 Thread John Grogan
Hi, We have decided to explore moving our database from mySQL to Cassandra. I am now installing it on my machine (OSX system) and need to think about how to do a data export from mySQL. Using phpmyAdmin, I have a range of different options to export the database. However, the crux is figuring

Re: Migrating from mySQL to Cassandra

2013-03-03 Thread Tyler Hobbs
On Sun, Mar 3, 2013 at 5:06 AM, John Grogan vangu...@dir-uk.org wrote: However, the crux is figuring out an easy way to import the data into Cassandra. Does anyone have any thoughts they can share? If you don't have a very large dataset and you're not pressed for time, just iterating over

Re: Migrating from mySQL to Cassandra

2013-03-03 Thread Marco Matarazzo
There's DataStax OpsCenter, which has a free Community Edition: http://www.datastax.com/products/opscenter Is OpsCenter working with cassandra 1.2 with vnodes already ? -- Marco Matarazzo

Re: Migrating from mySQL to Cassandra

2013-03-03 Thread Tyler Hobbs
On Sun, Mar 3, 2013 at 11:38 AM, Marco Matarazzo marco.matara...@hexkeep.com wrote: Is OpsCenter working with cassandra 1.2 with vnodes already ? Yes, it's compatible with vnode-enabled clusters, but doesn't support vnode-specific things like running shuffle. For now, it basically randomly

Migrating from Mysql to Cassandra

2010-09-28 Thread sekhar kosuru
Hi I am involving in migrating our database Mysql to Cassandra. After Google about Cassandra database i feel following are some issues we need to find the solutions. Suggest me if my analysis is wrong or for my doubts. *1) Projecting all the rows* - If we fixed KeyRange count to N records and

Re: Migrating from Mysql to Cassandra

2010-09-28 Thread Aaron Morton
1) Thats the general approach http://wiki.apache.org/cassandra/FAQ#iter_world for Not sure why you think it will run into aninfinitelooop.2) Not sure what your question is here. You either need to maintain the indexes yourself (by using a CF where the cols are the keys for another CF) or use the