Jump to content

Blob storage for Resco Cloud: Difference between revisions

From Resco's Wiki
No edit summary
No edit summary
Line 1: Line 1:
{{WIP}}
Database space can be expensive. In [[Resco Cloud]], you can use external storage for binary documents to save database space and money.
Database space can be expensive. In [[Resco Cloud]], you can use external storage for binary documents to save database space and money.


Line 18: Line 17:
# Select '''Settings > Organization''' from the menu.
# Select '''Settings > Organization''' from the menu.
# Click '''Blob Storage'''.
# Click '''Blob Storage'''.
# Select the '''Blob Storage Type''', for example, "Azure Storage" or "Amazon S3".
# Select the '''Blob Storage Type''':
# Enter the connection details.
#* Use "Cloud Storage" to use external storage managed by Resco. This is the default option for new organizations.
# Set the '''Minimal Blob Size'''. Smaller documents stay in the database, larger ones are stored externally.
#* Use "Azure Storage", "Amazon S3", or "SharePoint" if you have cloud storage that you would like to use.
#* Use "None" to store all binary files directly in the database.
# When using your storage, you must also enter:
#* Connection details: provider-specific parameters necessary to access the storage.
#* '''Minimal Blob Size''': Smaller documents stay in the database, while larger ones are stored externally.
# Save all changes.
# Save all changes.



Revision as of 11:04, 15 November 2022

Database space can be expensive. In Resco Cloud, you can use external storage for binary documents to save database space and money.

Select fields

Using the Admin Console, enable blob storage for fields that should be stored externally.

  1. Select Data > Entities from the menu.
  2. Click the entity that stores binary documents, for example, Note (annotation).
  3. Click the field that should be stored externally to display its details.
  4. Enable Blob storage.
  5. Save all changes.

Repeat the procedure for all fields that you want to store outside of the database.

Set up the storage

Before you can use external storage, you have to connect your organization to it.

  1. Select Settings > Organization from the menu.
  2. Click Blob Storage.
  3. Select the Blob Storage Type:
    • Use "Cloud Storage" to use external storage managed by Resco. This is the default option for new organizations.
    • Use "Azure Storage", "Amazon S3", or "SharePoint" if you have cloud storage that you would like to use.
    • Use "None" to store all binary files directly in the database.
  4. When using your storage, you must also enter:
    • Connection details: provider-specific parameters necessary to access the storage.
    • Minimal Blob Size: Smaller documents stay in the database, while larger ones are stored externally.
  5. Save all changes.

Migrate documents

When you set up the storage for the first time or when you modify the minimal blob size, you can migrate your existing documents to the correct storage.

  1. Select Settings > Organization from the menu.
  2. Click Blob Storage.
  3. Click Transfer Blobs. If blob storage is configured and the organization has enabled some fields for blob storage, the server schedules the job 'ExportLocalBlobsToBlobStorage' that transfers all blobs of configured size from the database to the configured blob storage.
  4. Click Processes Center > Logs to check the status of the job.