Hi everyone,
I’m exploring a setup for the Sonata Reports module and would like to know if the following architecture is feasible:
- Machine 1: hosts the GUI (graphical interface) for Sonata Reports
- Machine 2: runs a dedicated database for the reports
The goal is to offload processing from the main server and avoid performance issues by separating the reporting workload.
Has anyone implemented something similar? Is it possible to have the GUI on Machine 1 querying a separate database on Machine 2 without compromising performance or data integrity?
Thanks in advance!