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 to have a go at Cassandra. I have two questions as I plan > everything out: > > 1. If I create the database on Mac OS, what is the process for > migrating it to another environment like Windows? This concerns me because > I’m not sure who will host me later. Is it as simple as copying and pasting > the database and moving all of the files over or will the database need to > be converted? > > 2. I want to use Cassandra for a website that will rely heavily on > content that I provide the user over new profiles and/or new accounts that > the user creates. I plan on uploading content daily. Have any of you > created a template for uploading records into Cassandra or have any of you > created a script for loading multiple records at a time? > > Melinda >
