Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can the CAP data persistence database and business database be of different types #1465

Closed
List8378 opened this issue Jan 5, 2024 · 2 comments
Labels

Comments

@List8378
Copy link

List8378 commented Jan 5, 2024

Can the CAP data persistence database and business database be of different types?
For example:

Using SqlServer for CAP data persistence dababase

Business dababase using MySql

But I must use database transactions to ensure strong consistency between messages and business

Because I am using multiple tenants, there will be different types of databases

If I don't use a database for CAP persistence and use NoSql (ex: MongoDB), but also use different databases type for multi tenancy, can I still ensure strong consistency between messages and business

@List8378 List8378 changed the title Can the CAP data persistence library and business library be of different types Can the CAP data persistence database and business database be of different types Jan 5, 2024
@yang-xiaodong
Copy link
Member

yang-xiaodong commented Jan 5, 2024

Can the CAP data persistence database and business database be of different types?

No, See transactional outbox pattern

If I don't use a database for CAP persistence and use NoSql (ex: MongoDB), but also use different databases type for multi tenancy, can I still ensure strong consistency between messages and business

Not support database isolated multi-tenancy. See #699

@List8378
Copy link
Author

List8378 commented Jan 6, 2024

Can the CAP data persistence database and business database be of different types?

No, See transactional outbox pattern

If I don't use a database for CAP persistence and use NoSql (ex: MongoDB), but also use different databases type for multi tenancy, can I still ensure strong consistency between messages and business

Not support database isolated multi-tenancy. See #699

Okay, thank you, I'll try another way

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants