https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29938 Bug ID: 29938 Summary: Allow a secondary database Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: pasi.kallinen@koha-suomi.fi QA Contact: testopia@bugs.koha-community.org Our database has two servers, primary and secondary where the data is replicated from primary to secondary. Koha can only use the primary, which means the secondary is sitting idle. Allow defining a secondary database server in koha-conf. Allow executing some queries in the secondary instead of the primary one. Specifically, the saved reports would have the most benefit here: 1) Reports only do selects, never anything that changes the database, so are safe to do on the secondary server. 2) Normally, running very heavy reports can affect Koha use. If the queries were executed on the secondary server, they would have no effect on Koha. 3) It generally doesn't matter if report data is few minutes old. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.