Is there a per table / per database way to store the database by per directory?

ScyllaDB
1

e.g. 1 db or 1 table stores in 1 database folder or 1 table folder.
if i want to delete a database / table, i can just delete the folder

2

You should definitely not do that, you should DROP it before-hand.

e.g. 1 db or 1 table stores in 1 database folder or 1 table folder.

Kinda. workdir specifies which folder the database will use to store its files (commitlog, hints, etc). Although unusual, there’s nothing preventing you from creating different filesystems on a directory basis. I didn’t test it, but you should be able to assign a different filesystem to different keyspaces, tables are a bit different as they require assigning a random UUID at creation time.

1 Like