# Install Airflow on ubuntu 16.04

1. install `MySQL` first
2. Mysql Setting

    mysql -u root
    mysql> set global validate_password.policy=LOW;
    mysql> create database airflow default charset utf8 collate utf8_general_ci;
    mysql> create user airflow@'localhost' identified by 'password';
    mysql> grant all on airflow.* to airflow@'localhost';
    mysql> flush privileges;

3. install pymysql

    pip install PyMySQL==0.9.3
    pip install SQLAlchemy==1.3.23

4. Setup airflow default home

    mkdir -p ~/airflow
    export AIRFLOW_HOME=~/airflow
    export SLUGIFY_USES_TEXT_UNIDECODE=yes

5. install airflow

    pip install apache-airflow

6. Modify ~/airflow/airflow.cfg

    $ airflow db init
    $ vi ~/airflow/airflow.cfg
    # set
    sql_alchemy_conn = mysql+pymysql://airflow:password@localhost:3306/airflow

7. Create dags folder

    $ mkdir ~/airflow/dags
    $ vi ~/airflow/airflow.cfg
    # set dags path
    dags_folder = /home/ubuntu/airflow/dags

8. airflow init db

    $ airflow db init

9. Create users

    airflow users create \
        --username admin \
        --firstname pj \
        --lastname wang \
        --role Admin \
        --email [e-mail]

10. RUN
下面兩個都要開

    $ airflow webserver -p 8080
    $ airflow scheduler

airflow users create \
--username admin \
--firstname poyu \
--lastname chiu \
--role Admin \
--email [e-mail]