Add restore procedure using Scylla Manager

[mflendrich]

Issue originally authored by tnozicka as #1387

The current restore procedure is fairly manual, slow and @zimnx mentioned that it has a size limit as well. We should migrate to using the Scylla Manager for the restore.

Tasks

Preview Give feedback

1. Create design doc for restore using Scylla Manager
2. Implement support for restore using Scylla Manager in the Operator
3. Replace sstable based restore procedure with manager

[mflendrich]

@zimnx do you continue to feel that we should keep this issue open?

[zimnx]

It's a limitation we have, we should eventually automate it, that's why it's open.

[scylla-operator-bot]

The Scylla Operator project currently lacks enough contributors to adequately respond to all issues.

This bot triages un-triaged issues according to the following rules:

• After 30d of inactivity, lifecycle/stale is applied
• After 30d of inactivity since lifecycle/stale was applied, lifecycle/rotten is applied
• After 30d of inactivity since lifecycle/rotten was applied, the issue is closed

You can:

• Mark this issue as fresh with /remove-lifecycle stale
• Close this issue with /close
• Offer to help out

/lifecycle stale

[zimnx]

/remove-lifecycle stale
/triage accepted