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.

Sign up for GitHub

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

Jump to bottom

Add implementation of AbstractRoutingDataSource and ability to execute read-only queries on replica #209

Open
mfvanek opened this issue Mar 22, 2022 · 1 comment
Open

Add implementation of AbstractRoutingDataSource and ability to execute read-only queries on replica #209

mfvanek opened this issue Mar 22, 2022 · 1 comment
Labels
enhancement New feature or request good first issue Good for newcomers help wanted Extra attention is needed

Comments

@mfvanek
Copy link
Owner

mfvanek commented Mar 22, 2022 •
edited
Loading

After #208

See
https://www.baeldung.com/spring-abstract-routing-data-source
and
https://spring.io/blog/2007/01/23/dynamic-datasource-routing/

The main idea here is to execute write queries only on primary (master) host and dynamically redirect read-only queries to replicas

Watch https://youtu.be/hjJ6ODxgYqE
@mfvanek mfvanek changed the title Add implementation pf AbstractRoutingDataSource and ability to execute read-only queries on replica Add implementation of AbstractRoutingDataSource and ability to execute read-only queries on replica Sep 18, 2022
@mfvanek
Copy link
Owner Author

mfvanek commented May 7, 2023

See also https://vladmihalcea.com/read-write-read-only-transaction-routing-spring/

@mfvanek mfvanek transferred this issue from mfvanek/pg-index-health-spring-boot-demo May 27, 2024
@mfvanek mfvanek added enhancement New feature or request help wanted Extra attention is needed good first issue Good for newcomers labels Nov 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request good first issue Good for newcomers help wanted Extra attention is needed
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@mfvanek