栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

command

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

command

        DROp TABLE IF EXISTS CUSTOMER_BAK;
        SELECT * INTO CUSTOMER_BAK FROM CUSTOMER;
        DROp TABLE IF EXISTS tsoc_report_bak;
        SELECT * INTO tsoc_report_bak FROM tsoc_report;

        DROp TABLE  IF EXISTS "public"."work_order" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_alarm_info" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_attachment" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_comment" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_config" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_content" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_field" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_msg_error" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_notifierid" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_notify_flag" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_operation" CASCADE ;
        DROP TABLE  IF EXISTS "public"."work_order_relation";
        DROP TABLE  IF EXISTS "public"."work_order_update";
        DROP TABLE  IF EXISTS "public"."work_order_user_config";
        DROP TABLE  IF EXISTS "public"."work_order_user_update";
        DROP TABLE  IF EXISTS "public"."work_order_view";
        DROP TABLE  IF EXISTS "public"."workorder_config_verify_info";
        DROP TABLE  IF EXISTS "public"."workorder_content";
        DROP TABLE  IF EXISTS "public"."workorder_display_fields";
        DROP TABLE  IF EXISTS "public"."workorder_vul_info";
        delete from "flyway_history_table_workorder-service" where installed_rank >1;
        delete from "flyway_history_table_alarmInPg-service" where installed_rank >1;

创建topic

 切换到kafka目录: cd /opt/xinghai/kafka/software/kafka/bin/

sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_attack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_ioc --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_virus --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_webattack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.heartdata --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.ngsoc_alert_info --partitions 6 --replication-factor 2

sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_webattack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_virus --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_ioc --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_attack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.sendsummarydata --partitions 3 --replication-factor 2

sh kafka-topics.sh --zookeeper localhost:2181 --create --replication-factor 3 --partitions 1 --topic tsoc.audit
sh kafka-topics.sh --zookeeper localhost:2181 --create --replication-factor 3 --partitions 2 --topic tsoc.advice

sh kafka-topics.sh --create --zookeeper 127.0.0.1:2181 --replication-factor 3 --partitions 1 --topic project-service-change
sh kafka-topics.sh --create --zookeeper 127.0.0.1:2181 --replication-factor 3 --partitions 1 --topic project-service-terminate
sh kafka-topics.sh --create --zookeeper 127.0.0.1:2181 --replication-factor 3 --partitions 2 --topic workerOrderReport

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/944835.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号