网站建设会用到ppt吗产品营销方案案例范文

当前位置： 首页 > news >正文

网站建设会用到ppt吗,产品营销方案案例范文,商务网站设计制作,危险网站怎么办1、前提条件 一个k8s集群#xff0c;其中有三个master 节点#xff0c;这三个节点的标签名称为etcd 三个master节点的ip 分别为#xff1a;192.165.187.170 、192.165.187.171、192.165.187.172一个mysql 数据库#xff0c; 数据库的ip 为#xff1a;192.165.187.180 用户…1、前提条件 一个k8s集群其中有三个master 节点这三个节点的标签名称为etcd 三个master节点的ip 分别为192.165.187.170 、192.165.187.171、192.165.187.172一个mysql 数据库 数据库的ip 为192.165.187.180 用户名root 密码123456 2、准备nacos 数据库 在mysql 数据库中创建一个nacos名称的数据库然后执行下面的建表语句 SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS 0;– —————————- – Table structure for config_info

DROP TABLE IF EXISTS config_info; CREATE TABLE config_info (id bigint(0) NOT NULL AUTO_INCREMENT COMMENT id,data_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT data_id,group_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,content longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT content,md5 varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT md5,gmt_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 创建时间,gmt_modified datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 修改时间,src_user text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT source user,src_ip varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT source ip,app_name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT 租户字段,c_desc varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,c_use varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,effect varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,type varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,c_schema text CHARACTER SET utf8 COLLATE utf8_bin NULL,encrypted_data_key text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 秘钥,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX uk_configinfo_datagrouptenant(data_id, group_id, tenant_id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 9 CHARACTER SET utf8 COLLATE utf8_bin COMMENT config_info ROW_FORMAT Dynamic;– —————————- – Table structure for config_info_aggr

DROP TABLE IF EXISTS config_info_aggr; CREATE TABLE config_info_aggr (id bigint(0) NOT NULL AUTO_INCREMENT COMMENT id,data_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT data_id,group_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT group_id,datum_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT datum_id,content longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 内容,gmt_modified datetime(0) NOT NULL COMMENT 修改时间,app_name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT 租户字段,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX uk_configinfoaggr_datagrouptenantdatum(data_id, group_id, tenant_id, datum_id) USING BTREE ) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_bin COMMENT 增加租户字段 ROW_FORMAT Dynamic;– —————————- – Table structure for config_info_beta

DROP TABLE IF EXISTS config_info_beta; CREATE TABLE config_info_beta (id bigint(0) NOT NULL AUTO_INCREMENT COMMENT id,data_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT data_id,group_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT group_id,app_name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT app_name,content longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT content,beta_ips varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT betaIps,md5 varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT md5,gmt_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 创建时间,gmt_modified datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 修改时间,src_user text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT source user,src_ip varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT source ip,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT 租户字段,encrypted_data_key text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 秘钥,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX uk_configinfobeta_datagrouptenant(data_id, group_id, tenant_id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 1 CHARACTER SET utf8 COLLATE utf8_bin COMMENT config_info_beta ROW_FORMAT Dynamic;– —————————- – Table structure for config_info_tag

DROP TABLE IF EXISTS config_info_tag; CREATE TABLE config_info_tag (id bigint(0) NOT NULL AUTO_INCREMENT COMMENT id,data_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT data_id,group_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT group_id,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT tenant_id,tag_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT tag_id,app_name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT app_name,content longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT content,md5 varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT md5,gmt_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 创建时间,gmt_modified datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 修改时间,src_user text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT source user,src_ip varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT source ip,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX uk_configinfotag_datagrouptenanttag(data_id, group_id, tenant_id, tag_id) USING BTREE ) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_bin COMMENT config_info_tag ROW_FORMAT Dynamic;– —————————- – Table structure for config_tags_relation

DROP TABLE IF EXISTS config_tags_relation; CREATE TABLE config_tags_relation (id bigint(0) NOT NULL COMMENT id,tag_name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT tag_name,tag_type varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT tag_type,data_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT data_id,group_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT group_id,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT tenant_id,nid bigint(0) NOT NULL AUTO_INCREMENT,PRIMARY KEY (nid) USING BTREE,UNIQUE INDEX uk_configtagrelation_configidtag(id, tag_name, tag_type) USING BTREE,INDEX idx_tenant_id(tenant_id) USING BTREE ) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_bin COMMENT config_tag_relation ROW_FORMAT Dynamic;– —————————- – Table structure for group_capacity

DROP TABLE IF EXISTS group_capacity; CREATE TABLE group_capacity (id bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 主键ID,group_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT COMMENT Group ID空字符表示整个集群,quota int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 配额0表示使用默认值,usage int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 使用量,max_size int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 单个配置大小上限单位为字节0表示使用默认值,max_aggr_count int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 聚合子配置最大个数0表示使用默认值,max_aggr_size int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 单个聚合数据的子配置大小上限单位为字节0表示使用默认值,max_history_count int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 最大变更历史数量,gmt_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 创建时间,gmt_modified datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 修改时间,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX uk_group_id(group_id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 1 CHARACTER SET utf8 COLLATE utf8_bin COMMENT 集群、各Group容量信息表 ROW_FORMAT Dynamic;– —————————- – Table structure for his_config_info

DROP TABLE IF EXISTS his_config_info; CREATE TABLE his_config_info (id bigint(0) UNSIGNED NOT NULL,nid bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT,data_id varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,group_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,app_name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT app_name,content longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,md5 varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,gmt_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),gmt_modified datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),src_user text CHARACTER SET utf8 COLLATE utf8_bin NULL,src_ip varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,op_type char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT 租户字段,encrypted_data_key text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 秘钥,PRIMARY KEY (nid) USING BTREE,INDEX idx_gmt_create(gmt_create) USING BTREE,INDEX idx_gmt_modified(gmt_modified) USING BTREE,INDEX idx_did(data_id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 11 CHARACTER SET utf8 COLLATE utf8_bin COMMENT 多租户改造 ROW_FORMAT Dynamic;– —————————- – Table structure for permissions

DROP TABLE IF EXISTS permissions; CREATE TABLE permissions (role varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,resource varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,action varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,UNIQUE INDEX uk_role_permission(role, resource, action) USING BTREE ) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT Dynamic;– —————————- – Table structure for roles

DROP TABLE IF EXISTS roles; CREATE TABLE roles (username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,role varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,UNIQUE INDEX idx_user_role(username, role) USING BTREE ) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT Dynamic;– —————————- – Table structure for tenant_capacity

DROP TABLE IF EXISTS tenant_capacity; CREATE TABLE tenant_capacity (id bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 主键ID,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT COMMENT Tenant ID,quota int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 配额0表示使用默认值,usage int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 使用量,max_size int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 单个配置大小上限单位为字节0表示使用默认值,max_aggr_count int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 聚合子配置最大个数,max_aggr_size int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 单个聚合数据的子配置大小上限单位为字节0表示使用默认值,max_history_count int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 最大变更历史数量,gmt_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 创建时间,gmt_modified datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT 修改时间,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX uk_tenant_id(tenant_id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 1 CHARACTER SET utf8 COLLATE utf8_bin COMMENT 租户容量信息表 ROW_FORMAT Dynamic;– —————————- – Table structure for tenant_info

DROP TABLE IF EXISTS tenant_info; CREATE TABLE tenant_info (id bigint(0) NOT NULL AUTO_INCREMENT COMMENT id,kp varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT kp,tenant_id varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT tenant_id,tenant_name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT COMMENT tenant_name,tenant_desc varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT tenant_desc,create_source varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT create_source,gmt_create bigint(0) NOT NULL COMMENT 创建时间,gmt_modified bigint(0) NOT NULL COMMENT 修改时间,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX uk_tenant_info_kptenantid(kp, tenant_id) USING BTREE,INDEX idx_tenant_id(tenant_id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8 COLLATE utf8_bin COMMENT tenant_info ROW_FORMAT Dynamic;– —————————- – Table structure for users

DROP TABLE IF EXISTS users; CREATE TABLE users (username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,password varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,enabled tinyint(1) NOT NULL,PRIMARY KEY (username) USING BTREE ) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT Dynamic;SET FOREIGN_KEY_CHECKS 1; 3、 nacos的安装 1、下载镜像

docker pull nacos/nacos-server:v2.2.32、安装的yaml文件 nacos.yaml 文件如下

apiVersion: apps/v1 kind: StatefulSet metadata:annotations: {}labels:k8s.kuboard.cn/name: nacosname: nacosnamespace: kube-systemresourceVersion: 11313486 spec:podManagementPolicy: OrderedReadyreplicas: 3revisionHistoryLimit: 10selector:matchLabels:app: nacosserviceName: nacos-headlesstemplate:metadata:annotations:kubectl.kubernetes.io/restartedAt: 2023-06-05T15:01:4608:00pod.alpha.kubernetes.io/initialized: truecreationTimestamp: nulllabels:app: nacosspec:affinity:podAntiAffinity:requiredDuringSchedulingIgnoredDuringExecution:- labelSelector:matchExpressions:- key: appoperator: Invalues:- nacostopologyKey: kubernetes.io/hostnamecontainers:- env:- name: NACOS_REPLICASvalue: 3- name: MYSQL_SERVICE_HOSTvalue: 192.165.187.180- name: MYSQL_SERVICE_DB_NAMEvalue: NACOS- name: MYSQL_SERVICE_PORTvalue: 3306- name: MYSQL_SERVICE_USERvalue: root- name: MYSQL_SERVICE_PASSWORDvalue: 123456- name: SPRING_DATASOURCE_PLATFORMvalue: mysql- name: NACOS_SERVER_PORTvalue: 8848- name: PREFER_HOST_MODEvalue: ip- name: MODEvalue: cluster- name: NACOS_SERVER_IPvalueFrom:fieldRef:apiVersion: v1fieldPath: status.hostIP- name: NACOS_SERVERSvalue: 192.165.187.170:8848 192.165.187.171:8848 192.165.187.172:8848image: nacos/nacos-server:v2.2.3imagePullPolicy: Alwaysname: nacosports:- containerPort: 8848hostPort: 8848name: clientprotocol: TCP- containerPort: 9848hostPort: 9848name: client-rpcprotocol: TCP- containerPort: 9849hostPort: 9849name: raft-rpcprotocol: TCP- containerPort: 7848hostPort: 7848name: old-raft-rpcprotocol: TCPresources:requests:cpu: 500mmemory: 2GiterminationMessagePath: /dev/termination-logterminationMessagePolicy: FilednsPolicy: ClusterFirstnodeSelector:k8s.kuboard.cn/role: etcdrestartPolicy: AlwaysschedulerName: default-schedulersecurityContext: {}terminationGracePeriodSeconds: 30updateStrategy:rollingUpdate:partition: 0type: RollingUpdate status:availableReplicas: 3collisionCount: 0currentReplicas: 3currentRevision: nacos-65755f874observedGeneration: 41readyReplicas: 3replicas: 3updateRevision: nacos-65755f874updatedReplicas: 3 安装的名称空间在 kube-system k8s.kuboard.cn/role: etcd 这个需要注意这个标签里面一定要包含你要安装的三个节点 安装方式一、kubectl安装 把需要的yaml 修改好后把nacos.yaml 放到在master1上进入所在的目录中执行 kubectl apply -f nacos.yaml即可安装成功 方式二、 在kuboard中安装 1、进入kuboard 的kube-system名称空间点击导入工作负载。
根据提示一步一步操作即可。