Want to separate data sources by user within multi-tenant services

Asked 1 years ago, Updated 1 years ago, 241 views

I plan to develop a multi-tenant service.
It is assumed that each user (service user) will have a direct reference to the database of this service from an external system.
We want to separate data sources for each user so that we don't have access to other users' data.
Is there any useful way?

The environment is AWS. Application is Java SpringBoot (5.0.6)
RDS is Amazon RDS for MySQL (5.7.33)

java mysql aws spring-boot

2022-09-30 22:01

1 Answers

Here's a suggestion:

You can create tables separately for each user, prefix them before the username, and avoid naming them with other tables.


2022-09-30 22:01

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.