From dev-return-49171-archive-asf-public=cust-asf.ponee.io@couchdb.apache.org Wed Mar 18 18:58:51 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 38DE918025F for ; Wed, 18 Mar 2020 19:58:51 +0100 (CET) Received: (qmail 9469 invoked by uid 500); 18 Mar 2020 18:58:50 -0000 Mailing-List: contact dev-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@couchdb.apache.org Delivered-To: mailing list dev@couchdb.apache.org Received: (qmail 9457 invoked by uid 99); 18 Mar 2020 18:58:50 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Mar 2020 18:58:50 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 79577C0962 for ; Wed, 18 Mar 2020 18:58:49 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.201 X-Spam-Level: X-Spam-Status: No, score=-0.201 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id MSZwOq6qRulT for ; Wed, 18 Mar 2020 18:58:48 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.167.49; helo=mail-lf1-f49.google.com; envelope-from=paul.joseph.davis@gmail.com; receiver= Received: from mail-lf1-f49.google.com (mail-lf1-f49.google.com [209.85.167.49]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id EE43BBB853 for ; Wed, 18 Mar 2020 18:58:47 +0000 (UTC) Received: by mail-lf1-f49.google.com with SMTP id a28so9511270lfr.13 for ; Wed, 18 Mar 2020 11:58:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :content-transfer-encoding; bh=Uk6I4cpttWNL3JxidxpEPzPu6K7UDRcnTAROcArY/Qg=; b=XVf+2MuTpaPNtryFv2FEzoU5rJKvLsG/7CkZgpddvlUZlSkZAePkw5RRdFbSRoHUKB 9IdeEtjTsSGT3rOCvOwgooN+KnWBlwszJMI/mAEVDz1DKGDy74m/QXrA7Zy0Ddeeom4n qkwYD8Asy8Z48Y/kvP6J3N7B9O49eJaKCyNxlZlrfwGmvlvtqWk5GYoamVoH1+VJ9Faf tztM+AB9dGAjF4ZJEDw4tA6Hy85TEjwHUzeoUHVDNDmi8HjP0SbcnQk/XOBkPWzDolfs yVMavgs66ApIkKF0PiYIF17kzq7tZqcNB3HMnc38EhkKe+K9rJx2dMTqDl4WPIrfh89z cWbg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:content-transfer-encoding; bh=Uk6I4cpttWNL3JxidxpEPzPu6K7UDRcnTAROcArY/Qg=; b=B/d2Qg7G59NK6EVrVyeLJ1aSpVez/yRLTljW0qtA9hNMxnLvGLyWxMuy43H2wbZCQc Jp5d/n4EzGGx5Gu5jXby+a0JZ0I/5N7QjbsMnqR8nouE+FaO3yibtF3nbFA8XttHF7kB oZanXMIu3ok6h5XllmKAhqR56+dVdjN7jLp8OTiJkhr6Yz8gSyIQU4SyDm+TGzwlWdI5 s9dTmp7RAS0BWxuyPc1vvZFu62781fP/VljSrrw8/ZmLPpCzJFTzu/NIyhal637KGXbS 0FNwF3Vlo/QPf1FoK7Yt6rs0K6iI6gPfdjrdpzuLP7uos/MNS3oYYZFDUfZ1UP5D/zxL 04Tw== X-Gm-Message-State: ANhLgQ3AjQTBdt4ICOlz4eyaAFhl/rnMoAVtYEHKG/gsqu+ic3LqC5gV sHvwbmIZakcu2IsNY9R5U2LjBmoRjpwUasF9gPGjQQ== X-Google-Smtp-Source: ADFU+vuvtcYDkInfah2MZ6bPMepJYQArLLAVQ0FDTWJu6TrxS6o4UeTlX2cCNjychjMdcRLy+5JKjOVOUXBY7ISQsmM= X-Received: by 2002:ac2:5de1:: with SMTP id z1mr3671485lfq.95.1584557920820; Wed, 18 Mar 2020 11:58:40 -0700 (PDT) MIME-Version: 1.0 References: <905A4E67-FC8E-4D7F-B9FC-3847C656CCE9@apple.com> In-Reply-To: From: Paul Davis Date: Wed, 18 Mar 2020 13:59:00 -0500 Message-ID: Subject: Re: [DISCUSS] soft-deletion To: dev@couchdb.apache.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Alex, All joking aside, soft-deletion's target use case is accidental deletions. This isn't a replacement for backup/restore which will still happen for all the usual reasons. Paul On Wed, Mar 18, 2020 at 1:42 PM Paul Davis wr= ote: > > On Wed, Mar 18, 2020 at 1:29 PM Alex Miller > wrote: > > > > > > > On Mar 18, 2020, at 05:04, jiangph wrote: > > > > > > Instead of automatically and immediately removing data and index in d= atabase after a delete operation, soft-deletion allows to restore the delet= ed data back to original state due to a =E2=80=9Cfat finger=E2=80=9Dor unde= sired delete operation, up to defined periods, such as 48 hours. > > > > > > In CouchDB 3.0, soft-deletion of database is implemented in [1]. The = .couch file is renamed with the ..deleted.couch file after soft-= deletion is enabled, and such file can be changed back to .couch for the pu= rpose of restore. If restore is not needed and some specified period passed= , the ..deleted.couch file can be deleted to achieve deletion of= database permanently. > > > > > > In CouchDB 4.0, with the introduction of FoundationDB, the data model= and storage is changed. In order to support soft-deletion, we propose belo= w solution and then implement them. > > > > > > > > I=E2=80=99ve sort of hand waved some answers to this in my head, but wo= uld you mind expanding a bit on the advantages of keeping soft-deleted data= in FoundationDB as opposed to actually deleting it and relying on Foundati= onDB=E2=80=99s backup and restore to recover it if needed? > > From: Panicked User > To: Customer Support > Subject: URGENT! EMERGENCY DATABASE RESTORE! > > Dear, > > I have accidentally deleted my Very Important Database and need to > have it restored ASAP! Without this mission critical database my > company is completely offline which is costing $1B an hour!!!!! > > Please respond ASAP! > > Sincerely, > Panicky McPanics