恢复cassandra群集数据时意外删除表 [英] Restore cassandra cluster data when acccidentally drop table

问题描述

如你所知，Cassandra群集有复制功能，以防止数据丢失，即使群集中的某个节点关闭。但是在管理员意外删除了大量数据的表，并且该命令已经由集群中的所有副本执行的情况下，这是否意味着您丢失了该表，并且无法还原？

As you know, Cassandra cluster have replication to prevent data loss even if some node in the cluster down. But in the case that an admin accidentally drop a table with big amount of data, and that command had already executed by all the replica in cluster, is this means you lost that table and cannot restore it? Is there any suggestion to cope with this kind of disaster with short server down time?

推荐答案

来自cassandra 文档：

From cassandra docs:

auto_snapshot
（默认值：true）在键空间截断或删除表之前，启用或禁用数据的快照。为了防止
数据丢失，强烈建议使用默认设置。如果将
设置为false，则会丢失截断或丢弃的数据。

auto_snapshot (Default: true ) Enable or disable whether a snapshot is taken of the data before keyspace truncation or dropping of tables. To prevent data loss, using the default setting is strongly advised. If you set to false, you will lose data on truncation or drop.

这篇关于恢复cassandra群集数据时意外删除表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！