Uploaded image for project: 'Apache Airflow'
  1. Apache Airflow
  2. AIRFLOW-6094

Mysql script for 1.8 to 1.10 airflow db upgrade

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.8.2
    • Fix Version/s: None
    • Component/s: database
    • Labels:
      None

      Description

      We noticed that there isn't any script out there to upgrade airflow metadata db from 1.8 to 1.10. Also when we tried to run `airflow upgradedb` by going first to 1.9 and then 1.10, that didn't quite scale for our production db with millions of rows. So we wrote our own mysql script to go from 1.8 to 1.10 that scales and is optimized for runtime. Contributing this back to the community(see attachment). Credits to Ananth PackkilDurai, Deepak Barge.

        Attachments

        1. airflow-1.8-to-1.10-mysql.txt
          8 kB
          Ashwin Shankar

          Activity

            People

            • Assignee:
              vananth22 Ananth Packkildurai
              Reporter:
              ashwin.shankar77 Ashwin Shankar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: