docker部署PowerJob 定时任务

原创 已于 2024-06-12 11:32:16 修改 · 882 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java

于 2023-08-31 09:43:30 首次发布

docker部署PowerJob 定时任务
项目文档请移步官方地址
原文地址: https://blog.pw131.com/

与xxl_job的优势对比

在这里插入图片描述

powerjob-server数据库建表sql,有需要的可自行获取。


-- ----------------------------
-- Table structure for app_info
-- ----------------------------
DROP TABLE IF EXISTS `app_info`;
CREATE TABLE `app_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '应用ID',
  `app_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '应用名称',
  `current_server` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Server地址,用于负责调度应用的ActorSystem地址',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '应用密码',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uidx01_app_info`(`app_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '应用表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for container_info
-- ----------------------------
DROP TABLE IF EXISTS `container_info`;
CREATE TABLE `container_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '容器ID',
  `app_id` bigint NOT NULL COMMENT '应用ID',
  `container_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '容器名称',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  `last_deploy_time` datetime(0) NULL DEFAULT NULL COMMENT '上次部署时间',
  `source_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源信息,内容取决于source_type\n1、FatJar -> String\n2、Git -> JSON，{\"repo”:””仓库,”branch”:”分支”,”username”:”账号,”password”:”密码”}',
  `source_type` int NOT NULL COMMENT '资源类型,1:FatJar/2:Git',
  `status` int NOT NULL COMMENT '状态,1:正常ENABLE/2:已禁用DISABLE/99:已删除DELETED',
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '版本',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx01_container_info`(`app_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '容器表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for instance_info
-- ----------------------------
DROP TABLE IF EXISTS `instance_info`;
CREATE TABLE `instance_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务实例ID',
  `app_id` bigint NOT NULL COMMENT '应用ID',
  `instance_id` bigint NOT NULL COMMENT '任务实例ID',
  `type` int NOT NULL COMMENT '任务实例类型,1:普通NORMAL/2:工作流WORKFLOW',
  `job_id` bigint NOT NULL COMMENT '任务ID',
  `instance_params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '任务动态参数',
  `job_params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '任务静态参数',
  `actual_trigger_time` bigint NULL DEFAULT NULL COMMENT '实际触发时间',
  `expected_trigger_time` bigint NULL DEFAULT NULL COMMENT '计划触发时间',
  `finished_time` bigint NULL DEFAULT NULL COMMENT '执行结束时间',
  `last_report_time` bigint NULL DEFAULT NULL COMMENT '最后上报时间',
  `result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '执行结果',
  `running_times` bigint NULL DEFAULT NULL COMMENT '总执行次数,用于重试判断',
  `status` int NOT NULL COMMENT '任务状态,1:等待派发WAITING_DISPATCH/2:等待Worker接收WAITING_WORKER_RECEIVE/3:运行中RUNNING/4:失败FAILED/5:成功SUCCEED/9:取消CANCELED/10:手动停止STOPPED',
  `task_tracker_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'TaskTracker地址',
  `wf_instance_id` bigint NULL DEFAULT NULL COMMENT '工作流实例ID',
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '附加信息 (JSON)',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx01_instance_info`(`job_id`, `status`) USING BTREE,
  INDEX `idx02_instance_info`(`app_id`, `status`) USING BTREE,
  INDEX `idx03_instance_info`(`instance_id`, `status`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 881 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务实例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for job_info
-- ----------------------------
DROP TABLE IF EXISTS `job_info`;
CREATE TABLE `job_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app_id` bigint NULL DEFAULT NULL COMMENT '应用ID',
  `job_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务名称',
  `job_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务描述',
  `job_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '任务默认参数',
  `concurrency` int NULL DEFAULT NULL COMMENT '并发度,同时执行某个任务的最大线程数量',
  `designated_workers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运行节点,空:不限(多值逗号分割)',
  `dispatch_strategy` int NULL DEFAULT NULL COMMENT '投递策略,1:健康优先/2:随机',
  `execute_type` int NOT NULL COMMENT '执行类型,1:单机STANDALONE/2:广播BROADCAST/3:MAP_REDUCE/4:MAP',
  `instance_retry_num` int NOT NULL DEFAULT 0 COMMENT 'Instance重试次数',
  `instance_time_limit` bigint NOT NULL DEFAULT 0 COMMENT '任务整体超时时间',
  `lifecycle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生命周期',
  `max_instance_num` int NOT NULL DEFAULT 1 COMMENT '最大同时运行任务数,默认 1',
  `max_worker_count` int NOT NULL DEFAULT 0 COMMENT '最大运行节点数量',
  `min_cpu_cores` double NOT NULL DEFAULT 0 COMMENT '最低CPU核心数量,0:不限',
  `min_disk_space` double NOT NULL DEFAULT 0 COMMENT '最低磁盘空间(GB),0:不限',
  `min_memory_space` double NOT NULL DEFAULT 0 COMMENT '最低内存空间(GB),0:不限',
  `next_trigger_time` bigint NULL DEFAULT NULL COMMENT '下一次调度时间',
  `notify_user_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警用户(多值逗号分割)',
  `processor_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器信息',
  `processor_type` int NOT NULL COMMENT '执行器类型,1:内建处理器BUILT_IN/2:SHELL/3:PYTHON/4:外部处理器（动态加载）EXTERNAL',
  `status` int NOT NULL COMMENT '状态,1:正常ENABLE/2:已禁用DISABLE/99:已删除DELETED',
  `task_retry_num` int NOT NULL DEFAULT 0 COMMENT 'Task重试次数',
  `time_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '时间表达式,内容取决于time_expression_type,1:CRON/2:NULL/3:LONG/4:LONG',
  `time_expression_type` int NOT NULL COMMENT '时间表达式类型,1:CRON/2:API/3:FIX_RATE/4:FIX_DELAY,5:WORKFLOW\n）',
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'TAG',
  `log_config` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志配置',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  `alarm_config` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx01_job_info`(`app_id`, `status`, `time_expression_type`, `next_trigger_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oms_lock
-- ----------------------------
DROP TABLE IF EXISTS `oms_lock`;
CREATE TABLE `oms_lock`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '序号ID',
  `lock_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `max_lock_time` bigint NULL DEFAULT NULL COMMENT '最长持锁时间',
  `ownerip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拥有者IP',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uidx01_oms_lock`(`lock_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据库锁' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for server_info
-- ----------------------------
DROP TABLE IF EXISTS `server_info`;
CREATE TABLE `server_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '服务器ID',
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器IP地址',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uidx01_server_info`(`ip`) USING BTREE,
  INDEX `idx01_server_info`(`gmt_modified`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '服务器表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
  `web_hook` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'webhook地址',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uidx01_user_info`(`username`) USING BTREE,
  UNIQUE INDEX `uidx02_user_info`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for workflow_info
-- ----------------------------
DROP TABLE IF EXISTS `workflow_info`;
CREATE TABLE `workflow_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '工作流ID',
  `app_id` bigint NOT NULL COMMENT '应用ID',
  `wf_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工作流名称',
  `wf_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作流描述',
  `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
  `lifecycle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生命周期',
  `max_wf_instance_num` int NOT NULL DEFAULT 1 COMMENT '最大运行工作流数量,默认 1',
  `next_trigger_time` bigint NULL DEFAULT NULL COMMENT '下次调度时间',
  `notify_user_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警用户(多值逗号分割)',
  `pedag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'DAG信息(JSON)',
  `status` int NOT NULL COMMENT '状态,1:正常ENABLE/2:已禁用DISABLE/99:已删除DELETED',
  `time_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '时间表达式,内容取决于time_expression_type,1:CRON/2:NULL/3:LONG/4:LONG',
  `time_expression_type` int NOT NULL COMMENT '时间表达式类型,1:CRON/2:API/3:FIX_RATE/4:FIX_DELAY,5:WORKFLOW\n）',
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx01_workflow_info`(`app_id`, `status`, `time_expression_type`, `next_trigger_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工作流表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for workflow_instance_info
-- ----------------------------
DROP TABLE IF EXISTS `workflow_instance_info`;
CREATE TABLE `workflow_instance_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '工作流实例ID',
  `wf_instance_id` bigint NULL DEFAULT NULL COMMENT '工作流实例ID',
  `workflow_id` bigint NULL DEFAULT NULL COMMENT '工作流ID',
  `actual_trigger_time` bigint NULL DEFAULT NULL COMMENT '实际触发时间',
  `app_id` bigint NULL DEFAULT NULL COMMENT '应用ID',
  `dag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'DAG信息(JSON)',
  `expected_trigger_time` bigint NULL DEFAULT NULL COMMENT '计划触发时间',
  `finished_time` bigint NULL DEFAULT NULL COMMENT '执行结束时间',
  `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '执行结果',
  `status` int NULL DEFAULT NULL COMMENT '工作流实例状态,1:等待调度WAITING/2:运行中RUNNING/3:失败FAILED/4:成功SUCCEED/10:手动停止STOPPED',
  `wf_context` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作流上下文',
  `wf_init_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作流启动参数',
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `parent_wf_instance_id` bigint NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uidx01_wf_instance`(`wf_instance_id`) USING BTREE,
  INDEX `idx01_wf_instance`(`workflow_id`, `status`) USING BTREE,
  INDEX `idx02_wf_instance`(`app_id`, `status`, `expected_trigger_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工作流实例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for workflow_node_info
-- ----------------------------
DROP TABLE IF EXISTS `workflow_node_info`;
CREATE TABLE `workflow_node_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '节点ID',
  `app_id` bigint NOT NULL COMMENT '应用ID',
  `enable` bit(1) NOT NULL COMMENT '是否启动,0:否/1:是',
  `extra` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '扩展字段',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  `job_id` bigint NULL DEFAULT NULL COMMENT '任务ID',
  `node_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '节点名称',
  `node_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '节点参数',
  `skip_when_failed` bit(1) NOT NULL COMMENT '是否允许失败跳过,0:否/1:是',
  `type` int NULL DEFAULT NULL COMMENT '节点类型,1:任务JOB',
  `workflow_id` bigint NULL DEFAULT NULL COMMENT '工作流ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx01_workflow_node_info`(`workflow_id`, `gmt_create`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工作流节点表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

编写调度中心（powerjob-server）的docker-compose部署文件

version: '3'
services:
  powerjob-server:
    image: tjqq/powerjob-server:latest
    container_name: powerjob-server
	# 定义网络模式为host, 不然客户端不在同一网段无法注册进powerjob-server服务
    network_mode: host
    ports:
      - 7700:7700
      - 10086:10086
      - 10010:10010
    volumes:
      - ./data/powerjob-server:/root/powerjob/server
      - ./data/.m2:/root/.m2
    environment:
        JVMOPTIONS: "-Xmx512m"
		# mysql连接信息请替换为自己的
        PARAMS: "--spring.profiles.active=product --spring.datasource.core.jdbc-url=jdbc:mysql://127.0.0.1:3306/power_job?useUnicode=true&characterEncoding=UTF-8 --spring.datasource.core.username=${mysql_username}  --spring.datasource.core.password=${mysql_password} --oms.mongodb.enable=false"

执行部署命令

docker-compose up -d

查看是否部署成功

访问地址：http://${你的服务器ip}:7700/#/welcome

在这里插入图片描述

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值