[
https://issues.apache.org/jira/browse/CASSANDRA-15301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16922367#comment-16922367
]
maxwellguo commented on CASSANDRA-15301:
----------------------------------------
First you can not make snapshot frequently, make snapshot frequently will have
an impact on the cluster.
Second, you can not determine the frequency of making snapshots. One minute a
snapshot ? or one second?
Third , you can not guarantee the when the keyspace / table is created , as
well as the data insert after the keyspace/ table was created.
After all , the data you backup to another place will contains the ddl Mutation
and the insert sstable .
but you can not read it or even use the keyspace/table .
You can do a test : 1. make snapshot ,and export the data to other place on the
node. and backup the commitlog all the time even you do step 2 ;
2. create a new keyspace , you can also make table and do some insert.
3. use the snapshot data to restore the database.
4. you can read the old data, but for new created keyspace and table , you can
not select . but the commitlog contains the data with new keyspace you insert.
> DDL operation during backup process after made snaphot ,restore will lost
> data
> -------------------------------------------------------------------------------
>
> Key: CASSANDRA-15301
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15301
> Project: Cassandra
> Issue Type: Bug
> Reporter: maxwellguo
> Priority: Normal
>
> As the document described
> https://docs.datastax.com/en/archived/cassandra/3.0/cassandra/operations/opsBackupRestore.html
> , the setp to do bakcup and restore, we make snapshot and do table file
> export , but during thie process new keyspace / table was created ,The table
> file can be export to new cluster ,but when restore snapshot and files, new
> added table want't be loaded . so the new added table's data can not be get .
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
