search

bootiful-media-mogul / mogul-service

0 stars 1 forks source link

is there any benefit in sharding the system for security / multitenancy? #59

Open joshlong opened 2 days ago

joshlong commented 2 days ago

imagine: each new user results in a copy of the schema being installed in a new database with a unique password tied to the user's identity. they get their own databases and tables. and those tables in turn could be sharded. this way nobody would be able to see the user's data except them. but it also means we'd have to defer maintenance to their tables until the first time they login sincve we wouldn't have the key to unlock their database otherwise. what if there are CVEs whose fixes require changes to the code/tables. would w simply

would that quell any worries about data privacy? at hopefully not too crazy a cost? how would tings like flyway/liquibase work in this scenario?

joshlong commented 2 days ago

this could get super complicated. wed have to figure out s3 buckets.

most of the functionality is plugins the user configures with theri creds. so thats inherently multitenant. wed use AbstractRoutingDataSource