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

Temporary tables not safe on Mysql replication

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.3, 2.6.5, 2.7.2
    • Fix Version/s: BACKEND
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Database:
      MySQL
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_23_STABLE, MOODLE_26_STABLE, MOODLE_27_STABLE

      Description

      Just to think about this. This is Mysql specific.

      Using temporary tables can break Mysql replication as stated here:

      http://dev.mysql.com/doc/refman/5.5/en/replication-features-temptables.html

      I've just recovered a slave (mixed binary logging) because a missing backup_ids_temp table after a server restart.

      Maybe a temporary table may be an "ordinary" table that is dropped after used.

      What do you think about this?

      Thanks in advance.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                3 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated: