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

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

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656