Spring data with JPA (mySQL) - changing the data source dynamically

Question

We are using a spring MVC web application with a single data source (MySQL). We have a new requirement now:

We would like that some of our clients will use as their data source - machine#1's MySQL db.

And other clients should use as their data source - machine#2's MySQL db.

both of these data sources are identical in structure, only with different data.

This 2 different machines contain databases of two different customers that do not want to share the same database for obvious reasons.

Is that possible to do with minimal change of our code base?

Master Slave · Accepted Answer · 2015-03-03 16:09:42Z

3

You can consider AbstractRoutingDataSource

The general idea is that a routing DataSource acts as an intermediary - while the ‘real’ DataSource can be determined dynamically at runtime based upon a lookup key.

https://spring.io/blog/2007/01/23/dynamic-datasource-routing/

answered Mar 3, 2015 at 16:09

Master Slave

28.6k4 gold badges61 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring data with JPA (mySQL) - changing the data source dynamically

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related