Il db non relazionale creato da facebook e usato anche da altri social network

È fatto in java e adatto ad essere replicato, l'installazione non è proprio immediata conviene forse usare apt-get

Getting Started

from the official getting started guide I didn't like so much the apache documentation the commercial one seems better

  • cassandra.yaml in this file you can find useful information about the cluster , usually is in /etc/cassandra but depends from your installation
  • connect to the cluster with cqlsh, 9042 is the default port
cqlsh ipaddress 9042 -u myusername -p mypassword
  • list the cluster
cassandra@cqlsh> SELECT cluster_name, listen_address FROM system.local;

 cluster_name | listen_address
 my_cluster01 |

(1 rows)

all nodes cluster stauts

nodetool status

information of one node only

nodetool info

list all the keyspaces in the cluster

cassandra@cqlsh> DESCRIBE KEYSPACES;

Backup and restore

  • Opscenter is in able to save the backup to a directory or an s3 bucket

Dump and restore

connect with csql
and copy the tables structures

myuser@cqlsh> use use mykeyspacename;
myuser@cqlsh>DESCRIBE TABLES ;
mytableone mytable2 mytable3
myuser@cqlsh> DESCRIBE mytableone 
CREATE TABLE mykeyspacename.mytableone {

dump each table in a different file

myuser@cqlsh> copy mykeyspacename.mytableone to '/mypath/myfilename-mytableone .dat' with delimiter=';' AND QUOTE = '''' AND ESCAPE = '''' AND NULL = '<null>';
Salvo diversa indicazione, il contenuto di questa pagina è sotto licenza Creative Commons Attribution-ShareAlike 3.0 License