Re: Antw: [EXT] Re: SyncProv checkpointing

2021-05-06 Thread Quanah Gibson-Mount
--On Thursday, May 6, 2021 10:01 AM +0200 Ulrich Windl wrote: Quanah Gibson-Mount schrieb am 05.05.2021 um 18:09 in Nachricht : ‑‑On Wednesday, May 5, 2021 9:37 AM +0200 Ulrich Windl wrote: schrieb am 04.05.2021 um 17:27 in I just wonder: Are you talking about a slapcat‑type of

Re: Antw: [EXT] Re: SyncProv checkpointing

2021-05-06 Thread Ulrich Windl
>>> Quanah Gibson-Mount schrieb am 05.05.2021 um 18:09 in Nachricht : > > ‑‑On Wednesday, May 5, 2021 9:37 AM +0200 Ulrich Windl > wrote: > > schrieb am 04.05.2021 um 17:27 in > >> I just wonder: Are you talking about a slapcat‑type of backup or about a >> file‑level backup? > > They l

Re: Antw: [EXT] Re: SyncProv checkpointing

2021-05-05 Thread Quanah Gibson-Mount
--On Wednesday, May 5, 2021 9:37 AM +0200 Ulrich Windl wrote: schrieb am 04.05.2021 um 17:27 in I just wonder: Are you talking about a slapcat-type of backup or about a file-level backup? They literally stated multiple times they took the backup using the mdb_copy utility. --Quana

Antw: [EXT] Re: SyncProv checkpointing

2021-05-05 Thread Ulrich Windl
>>> schrieb am 04.05.2021 um 17:27 in >>> Nachricht <20210504152711.5262.64...@hypatia.openldap.org>: > Thanks for the follow up Quanah, > > Version: OpenLDAP: slapd 2.4.56 > We use delta sync replication > We have been provisioning 2 new providers to achieve multi master for a > total of 3 pro

Re: SyncProv checkpointing

2021-05-04 Thread Quanah Gibson-Mount
--On Tuesday, May 4, 2021 11:37 PM + thomaswilliampritch...@gmail.com wrote: You are correct we do not copy the access log, strictly the primary db. Ok good. When we restore a backup with a behind checkpoint we find some entries have incorrect fields in the new provider given the cu

Re: SyncProv checkpointing

2021-05-04 Thread thomaswilliampritchard
You are correct we do not copy the access log, strictly the primary db. When we restore a backup with a behind checkpoint we find some entries have incorrect fields in the new provider given the current state of the original provider, in other words, the databases do not match. The new provider

Re: SyncProv checkpointing

2021-05-04 Thread Quanah Gibson-Mount
--On Tuesday, May 4, 2021 7:13 PM + thomaswilliampritch...@gmail.com wrote: It is always running when we take backups via mdb_copy. Then it's expected the contextCSN won't be perfectly in sync at that point. I assume you're only doing an mdb copy of the primary db, and not the acces

Re: SyncProv checkpointing

2021-05-04 Thread thomaswilliampritchard
It is always running when we take backups via mdb_copy.

Re: SyncProv checkpointing

2021-05-04 Thread Quanah Gibson-Mount
--On Tuesday, May 4, 2021 4:27 PM + thomaswilliampritch...@gmail.com wrote: Provision Process: 1. Take backup of database with mdb_copy on initial provider. Is slapd stopped when you run mdb_copy, or running? Regards, Quanah -- Quanah Gibson-Mount Product Architect Symas Corporati

Re: SyncProv checkpointing

2021-05-04 Thread thomaswilliampritchard
Thanks for the follow up Quanah, Version: OpenLDAP: slapd 2.4.56 We use delta sync replication We have been provisioning 2 new providers to achieve multi master for a total of 3 providers. We have been testing the newly provisioned databases for accuracy with the ldiff-diff tool provided by htt

Re: SyncProv checkpointing

2021-05-03 Thread Quanah Gibson-Mount
--On Monday, May 3, 2021 10:52 PM + thomaswilliampritch...@gmail.com wrote: Hi, Through testing we have discovered restoring from backup is most accurate when we have the syncprov checkpointing at "1 1". Or checkpoint after 1 operation or 1 minute (olcSpCheckpoint: 1 1).

SyncProv checkpointing

2021-05-03 Thread thomaswilliampritchard
Hi, Through testing we have discovered restoring from backup is most accurate when we have the syncprov checkpointing at "1 1". Or checkpoint after 1 operation or 1 minute (olcSpCheckpoint: 1 1). Are there any concerns with having this frequent of checkpointing? Thanks, Thomas