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

Temporary tables not safe on Mysql replication

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Inactive
    • Minor
    • None
    • 2.3, 2.6.5, 2.7.2
    • Database SQL/XMLDB
    • MySQL
    • MOODLE_23_STABLE, MOODLE_26_STABLE, MOODLE_27_STABLE
    • Easy

    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

              moodle.com Moodle HQ
              jsegarra Juan Segarra Montesinos
              Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: