Easeprobe 使用实验 8.4: Navtive Client MySQL

好的程序员是那种过单行道马路都要往两边看的人 --Doug Linder
· 278字 · 2分钟

实验目的 🔗

  1. 创建 easeprobe native client mysql probe 配置并运行
  2. 执行内容
    • case 1: 验证 默认
    • case 2: 验证 key, value 均一致
    • case 3: 验证 key 一致， value 与设置不一致
    • case 4: 验证 key 不存在

准备工作 🔗

mysql -udemo -h 127.0.0.1 -p < /pre/db.sql

建表语句和测试数据

CREATE TABLE `demo`.`product`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `demo`.`product` (`name`) VALUES ("EaseProbe");

CREATE TABLE `demo`.`employee`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `age` int NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `demo`.`employee` (name, age) VALUES ("Xin", 39);
INSERT INTO `demo`.`employee` (name, age) VALUES ("Hao", 45);

docker-compose 配置 🔗

version: "3.9"
services:
  probe:
    image: megaease/easeprobe:v2.0.1
    container_name: probe
    volumes:
      - type: bind
        source: ./config.yaml
        target: /opt/config.yaml
        read_only: true
    network_mode: container:mysql
    depends_on:
      - mysql
  mysql:
    image: mysql:8.0
    container_name: mysql
    environment:
      MYSQL_RANDOM_ROOT_PASSWORD: yes
      MYSQL_DATABASE: demo
      MYSQL_USER: demo
      MYSQL_PASSWORD: secpass
    volumes:
      - type: bind
        source: ./db.sql
        target: /pre/db.sql
        read_only: true
    ports:
      - 8181:8181

easeprobe 配置 config.yaml 🔗

client:
  - name: MySQL Native Client (local) case 1
    driver: "mysql"
    host: "localhost:3306"
    username: "demo"
    password: "secpass"
    timeout: 5s
  - name: MySQL Native Client (local) case 2
    driver: "mysql"
    host: "localhost:3306"
    username: "demo"
    password: "secpass"
    timeout: 5s
    data:        
      "demo:product:name:id:1" : "EaseProbe"
      "demo:employee:age:id:2" : 45
  - name: MySQL Native Client (local) case 3
    driver: "mysql"
    host: "localhost:3306"
    username: "demo"
    password: "secpass"
    timeout: 5s
    data:         
      "demo:product:name:id:1" : "NameNotExists"
  - name: MySQL Native Client (local) case 4
    driver: "mysql"
    host: "localhost:3306"
    username: "demo"
    password: "secpass"
    timeout: 5s
    data:         
      "demo:product:sallary:id:1" : "NameNotExists"
notify:
  log:
    - name: notify
      file: /var/log/notify.log

settings:
  http:
    log:
      file: /var/log/access.log
  log:
    level: "debug"
    file: /var/log/debug.log

实验环境 🔗

验证 🔗

  • 查看日志
  • 查看 8181 端口

视频 🔗

问题 🔗

  1. 尝试使用非 admin 用户，显示认证失败
easeprobe native mysql config