Hi, i want to use aurora in jmix with seperate cluster read and write so how jmix support this already or not
Aurora PostgreSQL is declared as a drop-in replacement for PostgreSQL, so you should be able to use it in Jmix applications in the same way as the regular PostgreSQL database.
As for separating read and write operations, Jmix doesn’t offer an out-of-the-box solution for this. You can achieve this to some extent if you for example deploy a separate application with the Reports add-on and connect it to the read-only database.
Regards,
Konstantin
Thanks for info
Regards,
Tanakon
Hi,
Although Jmix does not support it out of the box there are a lot of articles around how to achieve that with a routing datasource which dynamically dispatches to the spring data source.
Here are some examples:
Not all of those articles mention the problem with nested transactions though, so you have to be careful about those.
Additionally when it is about AWS RDS in particular, there is a special lib from AWS which seems to do that automatically:
Not sure how easy this is to integrate with Jmix, as they normally on @Transactional, but perhaps there is also another way.
Cheers
Mario
1 Like