4 ms·
Interesting read! I like the depth of CDBs technical blog posts! I do wonder when they’ll add the BACKUP feature to the community edition. Dump isn’t very usef
by sandstrom 6y ago
Interesting read! I like the depth of CDBs technical blog posts!
I do wonder when they’ll add the BACKUP feature to the community edition. Dump isn’t very useful for larger datasets and frequent backup snapshots.
- namibj 6y agoArchive changefeeds, and replay later. Treat them like a WAL, and you should reach a loss-window down to <15 seconds with ease.
- latch 6y agoNot sure that I'd want my job to depend on me doing this correctly. 1. The feature is still flagged as experimental 2. If you fail to sync within the ttl window (25 hours by default), you'll lose data 3. There are cases (which might not be an issue for you) where it simply won't work (multiple column families, data imports, ...) Much much simpler and safer to use PG+barman.
- namibj 6y ago1. Yes. 2. No, you just loose the ability to rollback to an arbitrary position in that window. It might also be more expensive to re-start, but it's been a few months since I looked at the code. 3. I am aware of multi-column-families not working (but that should get tackled?): https://github.com/cockroachdb/cockroach/issues/28667 https://github.com/cockroachdb/cockroach/issues/28667 I know PG is easier in that respect, but the performance ceiling is much lower.