clickhouse

1、部署clickhouse-server

docker run -d --name my-clickhouse-server --ulimit nofile=262144:262144 yandex/clickhouse-server

docker exec -it my-clickhouse-server /bin/sh 

mkdir -p /home/clickhouse-server/
mkdir -p /home/clickhouse-server/etc/

docker cp my-clickhouse-server:/var/log/clickhouse-server /home/clickhouse-server/
docker cp my-clickhouse-server:/var/lib/clickhouse /home/clickhouse-server/
docker cp my-clickhouse-server:/etc/clickhouse-server /home/clickhouse-server/etc/

docker stop my-clickhouse-server
docker rm my-clickhouse-server

docker run -d --restart=always --privileged=true -p 8123:8123 -p 9000:9000 --name my-clickhouse-server --ulimit nofile=262144:262144 \
-v /home/clickhouse-server/clickhouse-server:/var/log/clickhouse-server \
-v /home/clickhouse-server/clickhouse:/var/lib/clickhouse \
-v /home/clickhouse-server/etc/clickhouse-server:/etc/clickhouse-server \
 yandex/clickhouse-server 

# 获取最新版本
latest=$(curl -sL https://api.github.com/repos/clickvisual/clickvisual/releases/latest | grep  ".tag_name" | sed -E 's/.*"([^"]+)".*/\1/')

# Linux amd64系统
wget "https://github.com/clickvisual/clickvisual/releases/download/${latest}/clickvisual-${latest}-linux-amd64.tar.gz" -O clickvisual-${latest}.tar.gz

# 解压压缩包
mkdir -p ./clickvisual-${latest} && tar -zxvf clickvisual-${latest}.tar.gz -C ./clickvisual-${latest}

# 修改配置文件 config/default.toml，将 MySQL、Redis 等配置改成你自己的配置。
# 修改完配置文件后，使用如下指令运行 clickvisual
cd ./clickvisual-${latest} && ./clickvisual -config config/default.toml

# 访问 http://localhost:19001
# login username: clickvisual
# login password: clickvisual

mkdir -p /home/data/mysql
mkdir -p /home/data/mysql/conf
mkdir -p /home/data/mysql/logs

docker stop mysql
docker rm mysql
docker run --name mysql --restart=always --privileged=true -p 3306:3306 -e MYSQL_ROOT_PASSWORD=liebe -v /home/data/mysql/log:/var/log/mysql -v /home/data/mysql/lib:/var/lib/mysql -v /home/data/mysql/etc/data/conf.d:/etc/mysql/conf.d -v /home/data/mysql/etc/data/mysql.d:/etc/mysql/mysql.d -v /home/data/mysql/etc/my.cnf:/etc/my.cnf -d mysql:5.7

clickhouse://default:liebe@10.10.10.99:9000/default?dial_timeout=200ms&max_execution_time=60

PASSWORD=$(base64 < /dev/urandom | head -c8); echo "liebe"; echo -n "liebe" | sha1sum | tr -d '-' | xxd -r -p | sha1sum | tr -d '-'

<password_double_sha1_hex>455a73136e2895b71a1c53356bf76d8bdb92ae59</password_double_sha1_hex>

jdbc:mysql://10.10.10.99:3306/demo?useUnicode=true&characterEncoding=utf-8&relaxAutoCommit=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true

root:liebe@tcp(10.10.10.99:3306)/demo?charset=utf8mb4&collation=utf8mb4_general_ci&parseTime=True&loc=Local&readTimeout=1s&timeout=1s&writeTimeout=3s

clickhouse-client --user default --password liebe --format_csv_allow_single_quotes 0 --input_format_null_as_default 0 --query "INSERT INTO dish FORMAT CSVWithNames" < Dish.csv
clickhouse-client --user default --password liebe --format_csv_allow_single_quotes 0 --input_format_null_as_default 0 --query "INSERT INTO menu FORMAT CSVWithNames" < Menu.csv
clickhouse-client --user default --password liebe --format_csv_allow_single_quotes 0 --input_format_null_as_default 0 --query "INSERT INTO menu_page FORMAT CSVWithNames" < MenuPage.csv
clickhouse-client --user default --password liebe --format_csv_allow_single_quotes 0 --input_format_null_as_default 0 --date_time_input_format best_effort --query "INSERT INTO menu_item FORMAT CSVWithNames" < MenuItem.csv

CREATE TABLE demo
(
    id UInt32,
    name String,
    description String,
    type String,
    user String,
    message String,
    time DateTime
) ENGINE = MergeTree ORDER BY id;

docker pull ghcr.io/apache/skywalking-showcase/app:fd527ba

docker pull ghcr.io/apache/skywalking-showcase/songs-service:fd527ba

helm install dolphinscheduler . --set image.tag=3.0.0

helm install dolphinscheduler . -n test

helm uninstall dolphinscheduler

./kk create cluster --with-kubernetes v1.21.5 --with-kubesphere v3.2.1

https://dolphinscheduler.apache.org/zh-cn/docs/latest/user_doc/guide/installation/kubernetes.html

helm repo add radondb-clickhouse-kubernetes https://radondb.github.io/radondb-clickhouse-kubernetes/

helm install --generate-name -n default radondb-clickhouse-kubernetes/clickhouse-operator

helm install --generate-name radondb-clickhouse-kubernetes/clickhouse-cluster -n default

kubectl exec -it chi-clickhouse-cluster-1660370383-all-nodes-0-0-0 -n default -- clickhouse-client --user=clickhouse --password=c1ickh0use0perator

kubectl exec -it chi-clickhouse-cluster-1660370383-all-nodes-0-0-0 -- clickhouse-client -u clickhouse --password=c1ickh0use0perator --query='select hostName()'

docker run -d --restart=unless-stopped --privileged=true -p 80:80 -p 443:443 \
-v /docker_volume/rancher_home/rancher:/var/lib/rancher \
-v /docker_volume/rancher_home/auditlog:/var/log/auditlog \
-e CATTLE_AGENT_IMAGE="rancher/rancher-agent:stable" \
--name rancher rancher/rancher:stable

yyy

sudo docker run -d --restart=unless-stopped -p 80:80 -p 443:443 --privileged rancher/rancher

c7b91a35fe5b

HoHa8Wqou2fYKgLS

sudo yum install -y yum-utils
sudo yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo
sudo yum install -y clickhouse-server clickhouse-client

sudo /etc/init.d/clickhouse-server start
clickhouse-client # or "clickhouse-client --password" if you set up a password.

git clone https://github.com/tabixio/tabix.git
cd tabix
git checkout master

# Install JS libs 
yarn set version 3.1.1
yarn -v
echo "rm -Rf node_modules"
rm -Rf node_modules/
echo "yarn install"
yarn install

# Run on http://0.0.0.0:9000/  
yarn start

# Build html+js to dir 
yarn build:dev

删除error的pod
kubectl get pod | grep Error | awk '{print $1}' | xargs kubectl delete pod 
kubectl get pod | grep Pending | awk '{print $1}' | xargs kubectl delete pod
 
export KKZONE=cn
curl -sfL https://get-kk.kubesphere.io | VERSION=v2.2.1 sh -
./kk create cluster --with-kubernetes v1.22.10 --with-kubesphere v3.3.0
 

kubectl describe nodes node3 |grep Taints
kubectl taint node node3 node.kubernetes.io/unschedulable:NoSchedule-

export REPO=skywalking
export SKYWALKING_RELEASE_NAME=skywalking
export SKYWALKING_RELEASE_NAMESPACE=default

helm repo add elastic https://helm.elastic.co

helm repo add ${REPO} https://apache.jfrog.io/artifactory/skywalking-helm

helm install skywalking skywalking/skywalking -n component  --set oap.image.tag=8.8.1 --set oap.storageType=elasticsearch --set ui.image.tag=8.8.1  --set elasticsearch.imageTag=7.5.1

wget https://dlcdn.apache.org/skywalking/java-agent/8.10.0/apache-skywalking-java-agent-8.10.0.tgz --no-check-certificate

https://blog.csdn.net/weixin_42555971/article/details/125333024

helm install "${SKYWALKING_RELEASE_NAME}" ${REPO}/skywalking -n "${SKYWALKING_RELEASE_NAMESPACE}" \
  --set oap.image.tag=8.8.1 \
  --set oap.storageType=elasticsearch \
  --set ui.image.tag=8.8.1 \
  --set elasticsearch.imageTag=7.5.1 \
  --set oap.replicas=1 \
  --set oap.javaOpts=-Xms1g -Xmx1g \
  --set elasticsearch.minimumMasterNodes=1 \
  --set elasticsearch.esJavaOpts=-Xms1g -Xmx1g \
  --set elasticsearch.replicas=1
  
export REPO=skywalking
export SKYWALKING_RELEASE_NAME=skywalking
export SKYWALKING_RELEASE_NAMESPACE=default 
 
helm uninstall "${SKYWALKING_RELEASE_NAME}" ${REPO}/skywalking -n "${SKYWALKING_RELEASE_NAMESPACE}"

helm install "${SKYWALKING_RELEASE_NAME}" ${REPO}/skywalking -n "${SKYWALKING_RELEASE_NAMESPACE}" -f values.yaml
kubectl describe pod elasticsearch-master-0

  
  swapoff -a && sed -i '/ swap / s/^\(.*\)$/#\1/g' /etc/fstab
           setenforce 0 && sed -i 's/^SELINUX=.*/SELINUX=disabled/' /etc/selinux/config