You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@airflow.apache.org by "Ashwin Shankar (Jira)" <ji...@apache.org> on 2019/11/27 22:42:00 UTC

[jira] [Updated] (AIRFLOW-6094) Mysql script for 1.8 to 1.10 airflow db upgrade

     [ https://issues.apache.org/jira/browse/AIRFLOW-6094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashwin Shankar updated AIRFLOW-6094:
------------------------------------
    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.  (was: 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. Credits to Ananth PackkilDurai, Deepak Barge.)

> Mysql script for 1.8 to 1.10 airflow db upgrade
> -----------------------------------------------
>
>                 Key: AIRFLOW-6094
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-6094
>             Project: Apache Airflow
>          Issue Type: Improvement
>          Components: database
>    Affects Versions: 1.8.2
>            Reporter: Ashwin Shankar
>            Assignee: Ananth PackkilDurai
>            Priority: Major
>         Attachments: airflow-1.8-to-1.10-mysql.txt
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)