[MCOL-3531] columnStorebackup Should Support Non-Locking Backups Created: 2019-09-30 Updated: 2023-07-03 Resolved: 2023-07-02 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | None |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | Todd Stoffel (Inactive) | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 4 |
| Labels: | Backup | ||
| Epic Link: | Consolidate & Redevelop All Columnstore Tools (SDK, Adapters, Backup, Restore, mcsimport) |
| Description |
|
Find a way to improve columnStorebackup to provide a non-locking mechanism or at least more granular locking. Suspending all writes during the duration of rsync is time consuming and causes a 'write' outage. |
| Comments |
| Comment by Alton J Dinsmore (Inactive) [ 2019-09-30 ] |
|
With today's streaming technologies applying updates to CS continuous it is not possible to just stop all streams of input while backup is running. People can have in the 100's of data streams and pausing for an update is not always possible. Must have no blocking HOT backups. |
| Comment by Girish [ 2019-09-30 ] |
|
Need this asap or we may consider other solutions |
| Comment by Patrick LeBlanc (Inactive) [ 2019-10-02 ] |
|
Todd brought up what is likely the quickest-to-impl sol'n. We could accept a dirty initial backup, then lock for writing and do an incremental backup. It would still block writes but for a shorter duration, and we'd get a consistent snapshot. That or something similar might be acceptable in the short term. |
| Comment by Todd Stoffel (Inactive) [ 2023-07-02 ] |
|
The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket. |