[Koha-bugs] [Bug 29938] New: Allow a secondary database

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: pasi.kallinen at koha-suomi.fi
        QA Contact: testopia at 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.