Moqui connect to Master and Replica database

Question

I am new in Moqui and want to connect to two mysql databases, one to write on(master) and one to read from (replica), how to do this?

Answer 1

I found a solution for this, i used

Connection con = ec.entity.getConnection("replica-group-name")
ps = con.prepareStatement("SElECT statement")
rs = ps.executeQuery()

this code is doing 50% of what i want, i am now trying to make the entity-find to use the replica instead of transactional datasource