ClickHouse 是一款开源的 OLAP 列存储数据库，下面是一些使用笔记，做个记录。 常用语句 -- 创建表 create table temp (`EventDate` DateTime, `UserId` UInt32) engine = MergeTree() partition by toYYYYMM(EventDate) order by EventDate; -- 创建分布式复制表 create table temp (`EventDate` DateTime, `UserId` UInt32) ...

最近在 CentOS 7 下使用 docker，出现 No route to host 这个问题，查了下，应该是由于 CentOS 7 默认使用 firewalld 造成的，解决方法添加白名单就行，做个记录。 # 主要命令 firewall-cmd --help ...

卸载安骑士 wget http://update.aegis.aliyun.com/download/uninstall.sh chmod +x uninstall.sh ./uninstall.sh wget http://update.aegis.aliyun.com/download/quartz_uninstall.sh chmod +x quartz_uninstall.sh ./quartz_uninstall.sh uninstall.sh #!/bin/bash #check linux Gentoo os var=`lsb_release -a | grep Gentoo` if [ -z "${var}" ]; then var=`cat /etc/issue | grep Gentoo` fi if [ -d "/etc/runlevels/default" -a -n "${var}" ]; then LINUX_RELEASE="GENTOO" else LINUX_RELEASE="OTHER" fi stop_aegis(){ killall -9 aegis_cli >/dev/null 2>&1 killall -9 aegis_update >/dev/null 2>&1 killall -9 aegis_cli >/dev/null 2>&1 killall ...

docker-compose.yml version: "3.3" services: elasticsearch: image: elasticsearch:6.4.3 environment: LOGSPOUT: ignore ES_JAVA_OPTS: "-Xmx256m -Xms256m" volumes: - ./elasticsearch.yml:/usr/share/elasticsearch/config/elasticsearch.yml:ro ports: - "9200:9200" logstash: image: logstash:6.4.3 environment: LOGSPOUT: ignore volumes: - ./temp.log:/var/log/temp.log - ./logstash.conf:/etc/logstash.conf ports: - "5000:5000" links: - elasticsearch command: -f /etc/logstash.conf kibana: image: kibana:6.4.3 environment: LOGSPOUT: ignore ELASTICSEARCH_URL: http://elasticsearch:9200 volumes: - ./elasticsearch.yml:/usr/share/elasticsearch/config/elasticsearch.yml:ro ports: - "5601:5601" links: - elasticsearch elasticsearch.yml http.port: 9200 network.host: 0.0.0.0 discovery.type: single-node logstash.conf input { file { path => ...

开发环境一直都是 Hyper-V 下虚拟机，但是最近不知道为什么，虚拟机无法访问宿主机，如虚拟机 IP 段为 237，在虚拟机内无法访问 128 或者 137 等 IP 段。 最后发现是某 ...