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.com/products/opscenter

(Disclosure: I work at DataStax.)

--
Tyler Hobbs
DataStax