Hosted vs

Hosted vs. private Cassandra NoSQL DB


  • - smallest setup Mira 4 costs $1810 /month



Setup on private server

cd ~/local
gunzip apache-cassandra-1.2.2-bin.tar.gz 
tar -xf apache-cassandra-1.2.2-bin.tar
cd apache-cassandra-1.2.2/

cat README.txt 

# We should do these steps according to the README
sudo mkdir -p /var/log/cassandra
sudo chown -R `whoami` /var/log/cassandra
sudo mkdir -p /var/lib/cassandra
sudo chown -R `whoami` /var/lib/cassandra

# Let's try to start
./bin/cassandra -f

An example of usage coped from the README file:

# Open a new shell and run some queries

  cqlsh> CREATE SCHEMA schema1 
         WITH replication = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
  cqlsh> USE schema1;
  cqlsh:Schema1> CREATE TABLE users (
                   user_id varchar PRIMARY KEY,
                   first varchar,
                   last varchar,
                   age int
  cqlsh:Schema1> INSERT INTO users (user_id, first, last, age) 
                 VALUES ('jsmith', 'John', 'Smith', 42);
  cqlsh:Schema1> SELECT * FROM users;
   user_id | age | first | last
    jsmith |  42 |  john | smith