how to deploy xxl-job-admin on kubernetes1.19

1. setup mysql

   git clone https://github.com/xuxueli/xxl-job.git
   git checkout 2.2.0
   cd xxl-job/doc/db
   cat tables_xxl_job.sql
   

   #
   # XXL-JOB v2.2.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_cron` varchar(128) NOT NULL COMMENT '任务执行CRON',
     `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 '报警邮件',
     `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 '执行失败-日志数量',
     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` varchar(512) DEFAULT NULL COMMENT '执行器地址列表，多地址逗号分隔',
     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`) VALUES (1, 'xxl-job-executor-sample', '示例执行器', 0, NULL);
   INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `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, '0 0 0 * * ? *', '测试任务1', '2018-11-03 22:21:31', '2018-11-03 22:21:31', 'XXL', '', '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;
   

   mysql -h192.168.0.211 -uroot -p
   source /root/xxl-job/doc/db/tables_xxl_job.sql
   

2. prepare yaml

   apiVersion: apps/v1
   kind: Deployment
   metadata:
     creationTimestamp: null
     labels:
       app: xxl-job-admin
     name: xxl-job-admin
   spec:
     replicas: 1
     selector:
       matchLabels:
         app: xxl-job-admin
     strategy: {}
     template:
       metadata:
         creationTimestamp: null
         labels:
           app: xxl-job-admin
       spec:
         containers:
         - image: xuxueli/xxl-job-admin:2.2.0
           name: xxl-job-admin
           imagePullPolicy: IfNotPresent
           env:
           - name: PARAMS
             value: "--spring.datasource.url=jdbc:mysql://192.168.0.211:3306/xxl_job?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai --spring.datasource.password=chenshi.de"
           ports:
           - containerPort: 8080
           resources:
             limits:
               memory: 1Gi
             requests:
               memory: 512Mi
   ---
   apiVersion: v1
   kind: Service
   metadata:
     creationTimestamp: null
     labels:
       app: xxl-job-admin
     name: xxl-job-admin
   spec:
     ports:
     - port: 8080
       protocol: TCP
       targetPort: 8080
     selector:
       app: xxl-job-admin
     type: ClusterIP
   

3. setup executor

   cd /root/xxl-job/xxl-job-executor-samples/xxl-job-executor-sample-springboot
   cat Dockerfile
   

   FROM openjdk:8-jre-slim
   MAINTAINER xuxueli
   
   ENV PARAMS=""
   
   ENV TZ=PRC
   RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone
   
   ADD target/xxl-job-executor-sample-springboot-*.jar /app.jar
   
   ENTRYPOINT ["sh","-c","java -jar $JAVA_OPTS /app.jar $PARAMS"]
   

   mv Dockerfile Dockerfile.bak
   cat Dockerfile
   

   FROM centos:7
   MAINTAINER chenshi.de
   ENV TZ=PRC
   RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone
   RUN yum makecache fast
   RUN yum install java-1.8.0-openjdk -y
   RUN yum install python3 -y
   RUN yum clean all && rm -rf /var/cache/yum
   ENV JAVA_HOME="/usr/lib/jvm/jre-openjdk"
   ENV PARAMS="--xxl.job.admin.addresses=http://xxl-job-admin:8080/xxl-job-admin --xxl.job.executor.appname=chenshi.de"
   ADD target/xxl-job-executor-sample-springboot-*.jar /app.jar
   ENTRYPOINT ["sh","-c","java -jar $JAVA_OPTS /app.jar $PARAMS"]
   

   docker build -t chenshi.de/jobs:v1 .
   docker push chenshi.de/jobs:v1
   cat job1.yaml
   

   apiVersion: apps/v1
   kind: Deployment
   metadata:
     creationTimestamp: null
     labels:
       app: job1
     name: job1
   spec:
     replicas: 1
     selector:
       matchLabels:
         app: job1
     strategy: {}
     template:
       metadata:
         creationTimestamp: null
         labels:
           app: job1
       spec:
         imagePullSecrets:
         - name: chenshi.de
         containers:
         - image: chenshi.de/jobs:v1
           name: job1
           imagePullPolicy: IfNotPresent
           ports:
           - containerPort: 9999
           resources:
             limits:
               memory: 1Gi
             requests:
               memory: 512Mi
   ---
   apiVersion: v1
   kind: Service
   metadata:
     creationTimestamp: null
     labels:
       app: job1
     name: job1
   spec:
     ports:
     - port: 9999
       protocol: TCP
       targetPort: 9999
     selector:
       app: job1
     type: ClusterIP
   

   edit executor AppName to job1.