Self-Hosted Configuration for Unlimited Storage

For self-managed deployments, unlimited storage requires S3 compatible object storage.

Run sdb-report calibrate-blob-storage to validate that your object store is S3 compatible.

Use CREATE DATABASE to create an unlimited storage database.

Creating and managing unlimited storage databases on self-managed deployments requires the SUPER permission. The root user has this permission by default. For other users, grant the SUPER permission before running unlimited storage commands:

GRANT SUPER ON *.* TO '<username>'@'%';

This requirement applies to the following operations:

  • CREATE DATABASE ... ON <object_store_settings>

  • RESTORE DATABASE ... ON <object_store_settings>

  • ATTACH DATABASE (for unlimited storage databases)

Note

SingleStore will troubleshoot any issues that are reproducible on AWS S3. If an issue cannot be reproduced on AWS S3 and appears specific to a given storage system, customers should work with their storage vendor to resolve it.

Last modified:

Was this article helpful?