Microservices and statistics, which path to take?

Question

Ruby on Rails

Good afternoon, when developing an admin panel that controls the behavior of micro-services, a question arose.
What are the ways to implement getting statistics (relatively large data pools)?
The micro-services themselves communicate with the admin panel and other services as a result of AMQP (rabbitmq). Everything went fine until we ran into the issue of statistics, it takes a long time to get it via the API, even if intermediate results are cached.
Maybe someone had similar tasks .. thanks!

Answer 1

I would advise you to read Building Microservices by Sam Newman
There are chapters:
Reporting
The Reporting Database
You need a microservice to collect and analyze data. Either analyze your queue (so that the statistics microservice is subscribed to all the necessary events), or replicate databases of different world services into the databases of the statistics microservice (and this is what major players do). Well, either just let your microservices know about the statistics and send requests to one end with some data, but then there will be too many gestures when this or that information is needed.