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

Read/Write splitting of DB operations.

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      TBA

      Test without a read slave

        

      Test with a read slave (connected to same place as master)

       - test the read stats in the footer
       
       

      Test lazy master connection

      only do some reads, master should never be connected at all (test with broken master credentials)
       

      Test when slave isn't available 

      Should fall back to read write to master
       

      Test the latency delay

      Read (slave)

      write (master)

      read (master)

      wait

      read (slave)

       

      Test read + write inside a transaction

       

      Test the db lock tables

       

      Test table exclusion config

       

       

       

       

      Show
      TBA Test without a read slave    Test with a read slave (connected to same place as master)  - test the read stats in the footer     Test lazy master connection only do some reads, master should never be connected at all (test with broken master credentials)   Test when slave isn't available  Should fall back to read write to master   Test the latency delay Read (slave) write (master) read (master) wait read (slave)   Test read + write inside a transaction   Test the db lock tables   Test table exclusion config        
    • Affected Branches:
      MOODLE_20_STABLE
    • Pull Master Branch:
      srdjan-slave-conn

      Description

      It would give an advantage on clusters if Moodle could allow slave (read-only) databases. Moodle could use master DB server for all write operations and could use slave DB server for all read operations. It will make clustering with Moodle simpler to setup and maintain.

      DB layer 2.0 could make it possible (easier) to do.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                23 Vote for this issue
                Watchers:
                31 Start watching this issue

                Dates

                • Created:
                  Updated: