Our previous set-up works as expected. So what we shall do now is to get one step further and configure two separate entity managers without affecting the functionality we achieved previously.
Check out previous posts: Read Replicas and Spring Data, Part 1: Configuring the Databases & Read Replicas and Spring Data, Part 2: Configuring the Base Project
The first step would be to set the default entity manager configuration to a primary one.
This is the first step: