aws-doc-sdk-examples [Enhancement]: Using EntityFrameworkCore 6, show example of write-forwarding on Aurora MySQL 5.7

[Enhancement]: Using EntityFrameworkCore 6, show example of write-forwarding on Aurora MySQL 5.7

Open adapter7 opened this issue 2 years ago • 1 comments

Background story

Having global databases for RDS Aurora MySQL 5.7 with primary (read/write) and secondary (read with write-forwarding enabled), show how to leverage EntityFrameworkCore to successfully forward insert, update and delete queries to primary cluster that are executed on secondary cluster.

What does this example accomplish?

INSERT, UPDATE, DELETE issued against secondary cluster should be forwarded to primary cluster.

Which AWS service(s)?

RDS Aurora MySQL 5.7

Which AWS SDKs or tools?

[ ] All languages
[X] .NET
[ ] Go (v2)
[ ] Java
[ ] Java (v2)
[ ] JavaScript
[ ] JavaScript (v3)
[ ] Kotlin
[ ] PHP
[ ] Python
[ ] Ruby
[ ] Rust
[ ] Swift
[ ] Not applicable

Are there existing code examples to leverage?

No response

Do you have any reference code?

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-write-forwarding.html#aurora-global-database-write-forwarding-txns