Bug 33502 - Run reports against a replicated database
Summary: Run reports against a replicated database
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-12 08:20 UTC by Magnus Enger
Modified: 2023-04-12 08:20 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Magnus Enger 2023-04-12 08:20:09 UTC 
One potential problem when running Koha is that someone can create a report that makes the database really slow and/or crash. 

This will be mitigated to some extent by bug 33116, but for sites that have a setup where the database is replicated to a second database server, it could be interesting to be able to direct queries generated by reports to the replica, not to the main server. Then a heavy/slow/big report would only affect the replica, not the main database.