Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3531

columnStorebackup Should Support Non-Locking Backups

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • Icebox
    • N/A

    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.

      Attachments

        Activity

          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.

          adinsmor Alton J Dinsmore (Inactive) added a comment - 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.
          gferwani Girish added a comment -

          Need this asap or we may consider other solutions

          gferwani Girish added a comment - Need this asap or we may consider other solutions

          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.

          pleblanc Patrick LeBlanc (Inactive) added a comment - 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.

          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.

          toddstoffel Todd Stoffel (Inactive) added a comment - 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.

          People

            toddstoffel Todd Stoffel (Inactive)
            toddstoffel Todd Stoffel (Inactive)
            Votes:
            4 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.