Re: Migrating from mySQL to Cassandra

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

Re: Migrating from mySQL to Cassandra

2013-03-04 Thread Tyler Hobbs
On Mon, Mar 4, 2013 at 5:08 AM, John Grogan 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 > configure it. I w

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. > > S

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 (duri

Re: Migrating from mySQL to Cassandra

2013-03-04 Thread John Grogan
Tyler, 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 configure it. I want to install 2 nodes on my laptop and then start bui

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

Re: Migrating from mySQL to Cassandra

2013-03-03 Thread Jabbar Azam
No, it doesn't work with vnodes. However it's useful for monitoring the cluster or individual node performance. On 3 Mar 2013 17:39, "Marco Matarazzo" wrote: > > There's DataStax OpsCenter, which has a free Community Edition: > http://www.datastax.com/products/opscenter > > Is OpsCenter working

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 5:06 AM, John Grogan 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 your existing data

Re: Migrating from mySQL to Cassandra

2013-03-03 Thread Marco Matarazzo
> In addition, are there any GUI tools like phpmyAdmin for Cassandra? Something similar is : https://github.com/sebgiroux/Cassandra-Cluster-Admin -- Marco Matarazzo

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

2010-10-02 Thread Peter Schuller
>   4) If we delete a record in clustered environment (In a single node), > after that before sync with remaining nodes the node got failure means we > wont have the data consistency - how to handle it. This database wont follow > ACID properties, how to handle this one for a huge ERP kind of appli

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 an infinite looop.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

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 i