Some database queries that retrieve very large amounts of data can potentially impact the performance of your production database and Moodle or Totara. We strongly recommend that Zoola access a copy of the Moodle or Totara data via a replica database. A replica or backup can provide a buffer between your production Moodle or Totara site and Zoola Analytics and allow both systems to perform optimally.

For more information on database replicas, please visit:

• MySQL 5.7
  https://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
  
  
• PostgreSQL 9
  https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial
  
  
• AWS Read Replicas 
  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html