SSTable Files with SSTableloader

The Cassandra bulk loader also called the sstableloader, provides the ability to:
Bulk loads external data into a cluster.
Load existing SSTables into another cluster with a different number of nodes or replication strategy.
Restore snapshots.

My LinkedIn profile: https://www.linkedin.com/in/anil-kumar-5a3283117/

Commands used in the video:
CREATE KEYSPACE sales WITH replication = {'class': 'NetworkTopologyStrategy', 'us-eastDC1': '1'} AND durable_writes = true;
CREATE TABLE sales.products (
product_id bigint PRIMARY KEY,
product_category text,
product_code text,
product_description text,
product_name text,
product_price decimal,
product_qoh bigint
) ;
sales.products.md-25-big-Data.db -----Source
sales.products -----Target (“/path/sales/products”)
mkdir -p /apps/opt/cassandra/software/sales/products
scp * cassandra@3.210.87.177:/apps/opt/cassandra/software/sales/products
sstableloader -d 3.210.87.177 -u anil -pw anil /apps/opt/cassandra/software/sales/products

####Using the –verbose option will provide much more progress output

sstableloader -d 3.210.87.177 -u anil -pw anil --verbose /apps/opt/cassandra/software/sales/products
####To hide the output of progress and the summary statistics

sstableloader -d 3.210.87.177 -u anil -pw anil --no-progress /apps/opt/cassandra/software/sales/products

#####To speed up the load process, the number of connections per host can be increased.

sstableloader -d 3.210.87.177 -u anil -pw anil --connections-per-host 10 /apps/opt/cassandra/software/sales/products
#####To prevent the table loader from overloading the system resources

sstableloader -d 3.210.87.177 -u anil -pw anil --throttle 1 /apps/opt/cassandra/software/sales/products
Load sstables from a Snapshot
Copy the snapshot sstables into an accessible directory and use sstableloader to restore them.
nodetool snapshot -t salessbackup sales

cp /apps/opt/cassandra/data/data/sales/products-ecdf2630cb3311eb90494387b2ab8b45/snapshots/salessbackup/* /apps/opt/cassandra/software/bkp/sales/products
sstableloader -d 3.210.87.177 -u anil -pw anil --verbose /apps/opt/cassandra/software/bkp/sales/products

Видео SSTable Files with SSTableloader канала Anil Mittana