From user-return-32344-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Mon Mar 4 11:08:49 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E6412D8A4 for ; Mon, 4 Mar 2013 11:08:48 +0000 (UTC) Received: (qmail 23685 invoked by uid 500); 4 Mar 2013 11:08:46 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 23447 invoked by uid 500); 4 Mar 2013 11:08:42 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 23428 invoked by uid 99); 4 Mar 2013 11:08:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Mar 2013 11:08:42 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [84.93.230.244] (HELO avasout03.plus.net) (84.93.230.244) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Mar 2013 11:08:35 +0000 Received: from [192.168.33.65] ([31.169.113.202]) by avasout03 with smtp id 7P8C1l0064N4HMb01P8D9h; Mon, 04 Mar 2013 11:08:14 +0000 X-CM-Score: 0.00 X-CNFS-Analysis: v=2.0 cv=Df3JXIRW c=1 sm=1 a=lthe7Je5BJtnsi0SZ4RL4g==:17 a=tmCOLQW7UVcA:10 a=QteqOjfqI7IA:10 a=Rcc-uj-xAAAA:8 a=EqUMdK9ZBngA:10 a=5GG0SCeFAAAA:8 a=4NHnD7bIKC-ZcqaCiY0A:9 a=CjuIK1q_8ugA:10 a=OPjMFLY-dXEA:10 a=_W_S_7VecoQA:10 a=tXsnliwV7b4A:10 a=SISD-giMHgS13xMv:21 a=lthe7Je5BJtnsi0SZ4RL4g==:117 X-AUTH: jgrogan:2500 From: John Grogan Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: multipart/alternative; boundary=Apple-Mail-3--311480421 Subject: Re: Migrating from mySQL to Cassandra Date: Mon, 4 Mar 2013 11:08:12 +0000 In-Reply-To: To: user@cassandra.apache.org References: <8D5F39A2CC391041BDFAB3A5D1AA94D567F98E87@AMSPRD0610MB387.eurprd06.prod.outlook.com> <7B070845-9791-46BF-8076-48AB82B0E252@dir-uk.org> Message-Id: <6344EEE4-A36D-41DB-8FDD-78784D518AC5@dir-uk.org> X-Mailer: Apple Mail (2.1085) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-3--311480421 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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 = building some code around it to move my DB from mySQL. I've had a look = at the DataStax website for some info on the very basics - setting up = nodes, configuration etc, but couldn't see anything. Is there anything = there that you can point me at? Or alternatively, any other sites that = provide a good overview with examples? I see that Jonathan Ellis is in London Wednesday at the Cassandra = group's talk so will try to drop by and say hello. Best, John. On 3 Mar 2013, at 17:06, Tyler Hobbs wrote: >=20 > On Sun, Mar 3, 2013 at 5:06 AM, John Grogan = wrote: >=20 > However, the crux is figuring out an easy way to import the data into = Cassandra. Does anyone have any thoughts they can share? >=20 > If you don't have a very large dataset and you're not pressed for = time, just iterating over your existing data with a normal mysql client = and inserting into Cassandra with a normal Cassandra client is the = easiest option. Using multiple threads or processes can make this = pretty quick. >=20 > For larger datasets, loading through a map/reduce job is typical. > =20 > In addition, are there any GUI tools like phpmyAdmin for Cassandra? >=20 > There's DataStax OpsCenter, which has a free Community Edition: = http://www.datastax.com/products/opscenter >=20 > (Disclosure: I work at DataStax.) >=20 > --=20 > Tyler Hobbs > DataStax --Apple-Mail-3--311480421 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii

On = Sun, Mar 3, 2013 at 5:06 AM, John Grogan <Vanguard@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 your existing data with = a normal mysql client and inserting into Cassandra with a normal = Cassandra client is the easiest option.  Using multiple threads or = processes can make this pretty quick.

For larger datasets, loading through a map/reduce job is = typical.
 
In addition, are there any GUI tools = like phpmyAdmin for Cassandra?

There's DataStax OpsCenter, which has a free Community = Edition: http://www.datastax.co= m/products/opscenter

(Disclosure: I work at DataStax.)

--
Tyler Hobbs
DataStax
=

= --Apple-Mail-3--311480421--