Re: Backups in Cassandra

2019-08-07 Thread cclive1601
We have also made backup and restore for Apache Cassandra,backup process are 1.do incremental backup for flushed sstable ;do incremental backup for commitlog ; 2.do snapshot for the cluster periodically,also meta info are needed to backup(token and table info); 3.for exception like node joining and

Re: insert into ... select statement

2019-04-22 Thread cclive1601
you can use cassandra trigger xiaobo 于2019年4月23日周二 下午1:23写道: > Hi, > > Can we use the result from a select statement to insert into another table > directlly like other RDBMS in cassandra? > > Thanks. > -- you are the apple of my eye !

Re: Using Cassandra as an object store

2019-04-19 Thread cclive1601
we have use cassandra as object store for some years, you can just split the object into some small pieces. object got a pk, then the some small pieces got some pks ,object's pk and pieces's pk can be store in meta table in cassandra, and small pieces's pk and some pieces store in data table. we st

Re: Cassandra single unreachable node causing total cluster outage

2018-12-12 Thread cclive1601
Hi can you put some java stack ? Agrawal, Pratik 于2018年12月11日周二 下午10:26写道: > Hello all, > > > > I’ve been doing more analysis and I’ve few questions: > > > >1. We observed that most of the requests are blocked on NTR queue. I >increased the queue size from 128 (default) to 1024 and this