PG_BADGER

pgbadger -j 4 --outfile $HOME/rapport_complet.html -f stderr -p '%t:%r:%u@%d:[%p]:' /pglog/postgresql-2021-09-10_000000.log

Upgrade Casssandra

upgrade.txt

Backup Cassandra

Pour sauvegarde incrémentale: 

 

incremental_backups à true dans le fichier .yaml

 

https://docs.datastax.com/en/cassandra-oss/2.2/cassandra/configuration/configCassandra_yaml.html#configCassandra_yaml__incremental_backups

 

 

backup : 

nodetool -h localhost -p 7199 snapshot mykeyspace

https://docs.datastax.com/en/cassandra-oss/2.2/cassandra/operations/opsBackupTakesSnapshot.html


supprimer backup : 

nodetool -h localhost -p 7199 clearsnapshot

restaurer : 

cp snapshots/1535397029191/* /path/to/keyspace1/standard1/

sstableloader --nodes 172.17.0.2 /var/lib/cassandra/loadme/keyspace1/standard1-f8a4fa30aa2a11e8af27091830ac5256/

https://docs.datastax.com/en/cassandra-oss/3.0/cassandra/operations/opsBackupSnapshotRestore.html

https://docs.datastax.com/en/cassandra-oss/2.2/cassandra/tools/toolsBulkloader.html