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.
Melinda
On Saturday, July 9, 2016 2:10 PM, Paul Fife <paulf...@gmail.com> 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!
Paul
On Sat, Jul 9, 2016 at 10:15 AM, Melinda Zoe <zoe.meli...@yahoo.com> 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
