cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Melinda Zoe <>
Subject Re: Planning to Use Cassandra
Date Sat, 09 Jul 2016 19:17:42 GMT
Thank you so much, Paul. This is extremely useful information for me. The new content will
come from websites (brief program information i.e. just titles and times) that will be copy/paste
into a text file. I've thought about other alternatives but I'd rather have a clean database
and put in the work than anything else. Thank you so much for all of your help.


    On Saturday, July 9, 2016 2:10 PM, Paul Fife <> wrote:

 Hello Melinda,
1. My recommendation is to script your database creation instead of copying database files
around. You could use code executing statements via a driver, or simply write a CQL script
and execute with CQLSH to create your schema and possibly some minimal data set if needed.
This is a good practice regardless of what database you use - you'll have an easy way to create
a known environment for repeatable testing. If you have a large amount of data to load into
a cluster after creating the schema you can use sstableloader, otherwise known as Cassandra
bulk loader, to quickly stream large amounts of data into an existing database. sstableloader
bulk loads sstables (the Cassandra data file format) into an existing data via network connection,
and is pretty flexible in that you can take files from a test system and load into a production
database that has completely different replication settings.
2. Since you haven't said where your new content is coming from it is hard to make a decent
recommendation on how to do your daily process. If it's something as simple as preparing new
data and wanting it loaded the sstableloader might work. If there's something more complicated
happening, you could be better off writing a tool/application to do this. Either way, definitely
automate as much as possible since it's going to be done regularly!
On Sat, Jul 9, 2016 at 10:15 AM, Melinda Zoe <> wrote:

Hello Group,
I’m ready tohave a go at Cassandra. I have two questions as I plan everything out: 1.   If
I create the database on Mac OS, what is theprocess for migrating it to another environment
like Windows? This concerns mebecause I’m not sure who will host me later. Is it as simple
as copying andpasting the database and moving all of the files over or will the database needto
be converted?
2.   I want to use Cassandra for a website that willrely heavily on content that I provide
the user over new profiles and/or newaccounts that the user creates. I plan on uploading content
daily. Have any ofyou created a template for uploading records into Cassandra or have any
of you createda script for loading multiple records at a time?  Melinda

View raw message