分布式任务调度平台XXL-JOB安装

安装xxl-job-admin

1.拉取镜像

#拉取镜像
docker pull xuxueli/xxl-job-admin:2.3.0
#新建挂载目录
mkdir /usr/local/xxl-job
mkdir /usr/local/xxl-job/admin
mkdir /usr/local/xxl-job/admin/logs

Mysql8安装教程

#
XXL-JOB v2.3.0
Copyright (c) 2015-present, xuxueli.

CREATE database if NOT EXISTS xxl_job default character set utf8mb4 collate utf8mb4_unicode_ci;
use xxl_job;

SET NAMES utf8mb4;

CREATE TABLE xxl_job_info (
  id int(11) NOT NULL AUTO_INCREMENT,
  job_group int(11) NOT NULL COMMENT '执行器主键ID',
  job_desc varchar(255) NOT NULL,
  add_time datetime DEFAULT NULL,
  update_time datetime DEFAULT NULL,
  author varchar(64) DEFAULT NULL COMMENT '作者',
  alarm_email varchar(255) DEFAULT NULL COMMENT '报警邮件',
  schedule_type varchar(50) NOT NULL DEFAULT 'NONE' COMMENT '调度类型',
  schedule_conf varchar(128) DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型',
  misfire_strategy varchar(50) NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略',
  executor_route_strategy varchar(50) DEFAULT NULL COMMENT '执行器路由策略',
  executor_handler varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
  executor_param varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
  executor_block_strategy varchar(50) DEFAULT NULL COMMENT '阻塞处理策略',
  executor_timeout int(11) NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位秒',
  executor_fail_retry_count int(11) NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  glue_type varchar(50) NOT NULL COMMENT 'GLUE类型',
  glue_source mediumtext COMMENT 'GLUE源代码',
  glue_remark varchar(128) DEFAULT NULL COMMENT 'GLUE备注',
  glue_updatetime datetime DEFAULT NULL COMMENT 'GLUE更新时间',
  child_jobid varchar(255) DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
  trigger_status tinyint(4) NOT NULL DEFAULT '0' COMMENT '调度状态：0-停止，1-运行',
  trigger_last_time bigint(13) NOT NULL DEFAULT '0' COMMENT '上次调度时间',
  trigger_next_time bigint(13) NOT NULL DEFAULT '0' COMMENT '下次调度时间',
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE xxl_job_log (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  job_group int(11) NOT NULL COMMENT '执行器主键ID',
  job_id int(11) NOT NULL COMMENT '任务，主键ID',
  executor_address varchar(255) DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
  executor_handler varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
  executor_param varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
  executor_sharding_param varchar(20) DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
  executor_fail_retry_count int(11) NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  trigger_time datetime DEFAULT NULL COMMENT '调度-时间',
  trigger_code int(11) NOT NULL COMMENT '调度-结果',
  trigger_msg text COMMENT '调度-日志',
  handle_time datetime DEFAULT NULL COMMENT '执行-时间',
  handle_code int(11) NOT NULL COMMENT '执行-状态',
  handle_msg text COMMENT '执行-日志',
  alarm_status tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
  PRIMARY KEY (id),
  KEY I_trigger_time (trigger_time),
  KEY I_handle_code (handle_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE xxl_job_log_report (
  id int(11) NOT NULL AUTO_INCREMENT,
  trigger_day datetime DEFAULT NULL COMMENT '调度-时间',
  running_count int(11) NOT NULL DEFAULT '0' COMMENT '运行中-日志数量',
  suc_count int(11) NOT NULL DEFAULT '0' COMMENT '执行成功-日志数量',
  fail_count int(11) NOT NULL DEFAULT '0' COMMENT '执行失败-日志数量',
  update_time datetime DEFAULT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY i_trigger_day (trigger_day) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE xxl_job_logglue (
  id int(11) NOT NULL AUTO_INCREMENT,
  job_id int(11) NOT NULL COMMENT '任务，主键ID',
  glue_type varchar(50) DEFAULT NULL COMMENT 'GLUE类型',
  glue_source mediumtext COMMENT 'GLUE源代码',
  glue_remark varchar(128) NOT NULL COMMENT 'GLUE备注',
  add_time datetime DEFAULT NULL,
  update_time datetime DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE xxl_job_registry (
  id int(11) NOT NULL AUTO_INCREMENT,
  registry_group varchar(50) NOT NULL,
  registry_key varchar(255) NOT NULL,
  registry_value varchar(255) NOT NULL,
  update_time datetime DEFAULT NULL,
  PRIMARY KEY (id),
  KEY i_g_k_v (registry_group,registry_key,registry_value)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE xxl_job_group (
  id int(11) NOT NULL AUTO_INCREMENT,
  app_name varchar(64) NOT NULL COMMENT '执行器AppName',
  title varchar(12) NOT NULL COMMENT '执行器名称',
  address_type tinyint(4) NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
  address_list text COMMENT '执行器地址列表，多地址逗号分隔',
  update_time datetime DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE xxl_job_user (
  id int(11) NOT NULL AUTO_INCREMENT,
  username varchar(50) NOT NULL COMMENT '账号',
  password varchar(50) NOT NULL COMMENT '密码',
  role tinyint(4) NOT NULL COMMENT '角色：0-普通用户、1-管理员',
  permission varchar(255) DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
  PRIMARY KEY (id),
  UNIQUE KEY i_username (username) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE xxl_job_lock (
  lock_name varchar(50) NOT NULL COMMENT '锁名称',
  PRIMARY KEY (lock_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO xxl_job_group(id, app_name, title, address_type, address_list, update_time) VALUES (1, 'xxl-job-executor-sample', '示例执行器', 0, NULL, '2018-11-03 22:21:31' );
INSERT INTO xxl_job_info(id, job_group, job_desc, add_time, update_time, author, alarm_email, schedule_type, schedule_conf, misfire_strategy, executor_route_strategy, executor_handler, executor_param, executor_block_strategy, executor_timeout, executor_fail_retry_count, glue_type, glue_source, glue_remark, glue_updatetime, child_jobid) VALUES (1, 1, '测试任务1', '2018-11-03 22:21:31', '2018-11-03 22:21:31', 'XXL', '', 'CRON', '0 0 0 * * ? *', 'DO_NOTHING', 'FIRST', 'demoJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2018-11-03 22:21:31', '');
INSERT INTO xxl_job_user(id, username, password, role, permission) VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, NULL);
INSERT INTO xxl_job_lock ( lock_name) VALUES ( 'schedule_lock');

commit;

3.创建容器

docker create --name xxl-job-admin -p 18080:8080 \
-e PARAMS="\
--spring.datasource.url=jdbc:mysql://【数据库IP】:13306/xxl_job?Unicode=true&characterEncoding=UTF-8 \
--spring.datasource.username=【数据库账号】 \
--spring.datasource.password=【数据库密码】" \
-v /usr/local/xxl-job/admin/logs:/data/applogs \
--privileged=true \
xuxueli/xxl-job-admin:2.3.0
#开放端口
firewall-cmd --add-port=18080/tcp --permanent
firewall-cmd --reload

在浏览器输入[IP]:18080/xxl-job-admin 访问，初始账号密码为admin 密码：123456

Original: https://www.cnblogs.com/blogof-fusu/p/16710887.html
Author: 山有扶苏QWQ
Title: 分布式任务调度平台XXL-JOB安装