Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-70998

Conditionally move recordsets / cursors to the db readonly replica where possible

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Not a bug
    • Affects Version/s: Future Dev
    • Fix Version/s: None
    • Labels:
      None

      Description

      All recordsets (at least on postgres) are coming from the primary instead of a db replica. In MDL-70997 I'm moving some of these to be normal queries as they shouldn't be recordsets anyway, but in the more general case we can decide on a case by case basis whether each cursor is able to go to a replica based on the same logic as a normal read query. But we need to store this connection state decision and then keep honoring it and flipping it as we do all the internal cursor fetching and AUX calls so that all of a given cursors actions are on the same connection.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              brendanheywood Brendan Heywood
              Participants:
              Component watchers:
              Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: