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
