mac 上学习k8s系列（48）es +grafana可视化

version: "3"

services:
  elasticsearch:
    image: docker.io/elasticsearch:7.17.6
    # networks:
    # - elastic-jaeger
    ports:
      - "9200:9200"
      - "9300:9300"
    restart: on-failure
    environment:
      - cluster.name=jaeger-cluster
      - discovery.type=single-node
      - http.host=0.0.0.0
      - transport.host=127.0.0.1
      - ES_JAVA_OPTS=-Xms512m -Xmx512m
      - xpack.security.enabled=false
    volumes:
      - ~/bilibili/live/learn/elasticsearch/esdata:/usr/share/elasticsearch/data
    extra_hosts:
     - host.docker.internal:host-gateway
  
  grafana:
    image: grafana/grafana:latest
    restart: always
    container_name: grafana
    hostname: grafana
    environment:
     - TZ=Asia/Shanghai
     - ELASTICSEARCH_HOSTS=http://host.docker.internal:9200
    volumes:
  #  - /opt/grafana/defaults.ini:/etc/grafana/grafana.ini
     - ~/bilibili/live/learn/elasticsearch/grafana:/var/lib/grafana
    ports:
     - 3000:3000
    
  kibana:
    image: docker.io/kibana:7.17.6
    ports:
      - "5601:5601"
    depends_on:
      - elasticsearch
    extra_hosts:
     - host.docker.internal:host-gateway
    # -e ELASTICSEARCH_HOSTS=http://172.17.0.2:9200
    environment:
      - ELASTICSEARCH_HOSTS=http://host.docker.internal:9200

docker compose -f learn/elasticsearch/docker-compose-es-grafana.yml up

PUT chengji
{
    "mappings": {
        "properties": {
      "name": {
        "type": "text"
      },
      "name_keyword": {
        "type": "keyword"
      },
      "sex": {
        "type": "keyword"
      },
      "course": {
        "type": "keyword"
      },
      "Score": {
        "type": "integer"
      },
      "ctime":{
        "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss"
      }
       }
    }
}

POST _bulk 
{"index":{"_index":"chengji"}}
{"name":"张三","name_keyword":"张三","sex":"男","course":"语文","Score":76,"ctime":"2022-10-11 12:12:00"}
{"index":{"_index":"chengji"}}
{"name":"张三","name_keyword":"张三","sex":"男","course":"数学","Score":95,"ctime":"2022-10-11 12:13:00"}
{"index":{"_index":"chengji"}}
{"name":"张三","name_keyword":"张三","sex":"男","course":"英语","Score":58,"ctime":"2022-10-11 12:14:00"}
{"index":{"_index":"chengji"}}
{"name":"李四","name_keyword":"李四","sex":"男","course":"语文","Score":68,"ctime":"2022-10-11 12:16:00"}
{"index":{"_index":"chengji"}}
{"name":"李四","name_keyword":"李四","sex":"男","course":"数学","Score":45,"ctime":"2022-10-11 12:18:00"}
{"index":{"_index":"chengji"}}
{"name":"李四","name_keyword":"李四","sex":"男","course":"英语","Score":37,"ctime":"2022-10-11 12:19:00"}
{"index":{"_index":"chengji"}}
{"name":"王五","name_keyword":"王五","sex":"男","course":"语文","Score":81,"ctime":"2022-10-11 12:11:00"}
{"index":{"_index":"chengji"}}
{"name":"王五","name_keyword":"王五","sex":"男","course":"数学","Score":74,"ctime":"2022-10-11 12:21:00"}
{"index":{"_index":"chengji"}}
{"name":"王五","name_keyword":"王五","sex":"男","course":"英语","Score":64,"ctime":"2022-10-11 12:22:00"}
{"index":{"_index":"chengji"}}
{"name":"马六","name_keyword":"马六","sex":"男","course":"语文","Score":69,"ctime":"2022-10-11 12:23:00"}
{"index":{"_index":"chengji"}}
{"name":"马六","name_keyword":"马六","sex":"男","course":"数学","Score":93,"ctime":"2022-10-11 12:24:00"}
{"index":{"_index":"chengji"}}
{"name":"马六","name_keyword":"马六","sex":"男","course":"英语","Score":77,"ctime":"2022-10-11 12:25:00"}
{"index":{"_index":"chengji"}}
{"name":"小丽","name_keyword":"小丽","sex":"女","course":"语文","Score":84,"ctime":"2022-10-11 13:12:00"}
{"index":{"_index":"chengji"}}
{"name":"小丽","name_keyword":"小丽","sex":"女","course":"数学","Score":61,"ctime":"2022-10-11 14:12:00"}
{"index":{"_index":"chengji"}}
{"name":"小丽","name_keyword":"小丽","sex":"女","course":"英语","Score":88,"ctime":"2022-10-11 15:12:00"}
{"index":{"_index":"chengji"}}
{"name":"小梅","name_keyword":"小梅","sex":"女","course":"语文","Score":85,"ctime":"2022-10-11 12:34:00"}
{"index":{"_index":"chengji"}}
{"name":"小梅","name_keyword":"小梅","sex":"女","course":"数学","Score":78,"ctime":"2022-10-11 12:35:00"}
{"index":{"_index":"chengji"}}
{"name":"小梅","name_keyword":"小梅","sex":"女","course":"英语","Score":92,"ctime":"2022-10-11 12:36:00"}
{"index":{"_index":"chengji"}}
{"name":"周美","name_keyword":"周美","sex":"男","course":"语文","Score":96,"ctime":"2022-10-11 12:38:00"}
{"index":{"_index":"chengji"}}
{"name":"周美","name_keyword":"周美","sex":"男","course":"数学","Score":97,"ctime":"2022-10-11 12:40:00"}
{"index":{"_index":"chengji"}}
{"name":"周美","name_keyword":"周美","sex":"男","course":"英语","Score":93,"ctime":"2022-10-11 12:42:00"}

Query error
Elasticsearch error: Bad Gateway