airflow分布式部署（二）mysql安装

airflow生产环境一般以mysql作为元数据库，所以需要安装mysql

下载mysql的repo源
wget -P /root http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
#通过rpm安装
rpm -ivh mysql-community-release-el7-5.noarch.rpm
#安装mysql
yum install mysql-server
#授权
chown -R mysql:mysql /var/lib/mysql
#开启Mysql服务
service mysqld start
#用root用户连接登录mysql:
mysql -uroot
#重置mysql密码
use mysql;
update user set password=password('password') where user='root';
flush privileges;
#为Airflow建库、建用户
#建库airflow:
create database airflow default charset utf8 collate utf8_general_ci;
#建用户,airflow用户不如root好用:
create user 'airflow'@'%' identified by 'password';
create user 'airflow'@'localhost' identified by 'password';
#为用户授权:
grant all on airflow.* to 'airflow'@'%';
grant all on airflow.* to 'root'@'%';
#允许以外部服务器以IP=192.168.1.18远程访问airflow库
grant all on airflow.* TO 'root'@'192.168.1.18' IDENTIFIED BY 'password'
flush privileges;
exit;
#mysql设置下列属性提示只读，需要在/etc/my.cnf的[mysqld]下新增explicit_defaults_for_timestamp = 1
set global explicit_defaults_for_timestamp =1;

mysql运维常用命令

service mysqld start

service mysqld stop

service mysqld restart