Breaking News: Grepper is joining You.com. Read the official announcement!

Problem: Cross-Service Queries and Write Commands on Distributed Scaled Databases

Add Answer

Anjali Sharma answered on February 2, 2023 Popularity 2/10 Helpfulness 1/10

answer Problem: Cross-Service Queries and Write Commands on Distributed Scaled Databases

Problem: Cross-Service Queries and Write Commands on Distributed Scaled Databases

Comment

Considerations

● Cross-services queries that retrieve data fromseveral microservices ?

● Separate read and write operations at scale ?

Problems

● Cross-Service Queries with Complex JOIN operations

● Read and write operations at scale

● Distributed Transaction Management

Solutions

● Microservices Data Query Pattern and Best

Practices

● Materialized View Pattern

● CQRS Design Pattern

● Event Sourcing Patte

@Configuration
public class MultitenantConfiguration {

    @Value("${defaultTenant}")
    private String defaultTenant;

    @Bean
    @ConfigurationProperties(prefix = "tenants")
    public DataSource dataSource() {
        File[] files = Paths.get("allTenants").toFile().listFiles();
        Map<Object, Object> resolvedDataSources = new HashMap<>();

        for (File propertyFile : files) {
            Properties tenantProperties = new Properties();
            DataSourceBuilder dataSourceBuilder = DataSourceBuilder.create();

            try {
                tenantProperties.load(new FileInputStream(propertyFile));
                String tenantId = tenantProperties.getProperty("name");

                dataSourceBuilder.driverClassName(tenantProperties.getProperty("datasource.driver-class-name"));
                dataSourceBuilder.username(tenantProperties.getProperty("datasource.username"));
                dataSourceBuilder.password(tenantProperties.getProperty("datasource.password"));
                dataSourceBuilder.url(tenantProperties.getProperty("datasource.url"));
                resolvedDataSources.put(tenantId, dataSourceBuilder.build());
            } catch (IOException exp) {
                throw new RuntimeException("Problem in tenant datasource:" + exp);
            }
        }

        AbstractRoutingDataSource dataSource = new MultitenantDataSource();
        dataSource.setDefaultTargetDataSource(resolvedDataSources.get(defaultTenant));
        dataSource.setTargetDataSources(resolvedDataSources);

        dataSource.afterPropertiesSet();
        return dataSource;
    }

}

https://microservices.io/patterns/data/shared-database.html

Popularity 2/10 Helpfulness 1/10 Language java

Source: Grepper

Tags: distributed java

Link to this answer
Share Copy Link

Contributed on Feb 02 2023

Anjali Sharma

0 Answers Avg Quality 2/10

Problem: Cross-Service Queries and Write Commands on Distributed Scaled Databases

Contents

More Related Answers

Problem: Cross-Service Queries and Write Commands on Distributed Scaled Databases

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.