https://hub.docker.com/r/pingcap/tidb/
https://github.com/pingcap/tidb
https://github.com/pingcap/tidb-docker-compose
https://pingcap.com/docs-cn/
https://pingcap.com/docs-cn/op-guide/docker-deployment/
https://abc.htmltoo.com/thread-45001.htm
https://hub.docker.com/_/golang
# TiDB整体架构,介绍,特征
https://abc.htmltoo.com/thread-45945.htm
# Dockerfile
https://abc.htmltoo.com/thread-45944.htm # tidb - tidb - Dockerfile
https://abc.htmltoo.com/thread-45937.htm # tidb - pd - Dockerfile
https://abc.htmltoo.com/thread-45943.htm # tidb - tikv - Dockerfile
https://abc.htmltoo.com/thread-45947.htm # tidb - binlog - Dockerfile
# 部署一个多节点集群
https://abc.htmltoo.com/thread-45946.htm
假设我们打算在 7 台主机上部署一个 TiDB 集群:
主机名 IP 部署服务 数据盘挂载
host1 192.168.1.101 PD1 /data
host2 192.168.1.102 PD2 /data
host3 192.168.1.103 PD3 /data
host4 192.168.1.104 TiKV1 /data
host5 192.168.1.105 TiKV2 /data
host6 192.168.1.106 TiKV3 /data
host7 192.168.1.107 TiDB1 /data
host8 192.168.1.108 TiDB2 /data
host9 192.168.1.109 TiDB3 /data
host10 192.168.1.110 tispark-master /data
host11 192.168.1.111 tispark-slave /data
# tidb1,tidb2,tidb3
mysql -h 127.0.0.1 -P 4000 -u root -D test
show databases;
select tidb_version();
set @@tidb_general_log = 1; # 会记录所有 sql 语句
SET PASSWORD FOR 'root'@'%' = 'wdqdmm@r'; # 修改root密码
CREATE USER 'ihunter'@'%' IDENTIFIED BY 'wdqdmm@m'; # 增加用户
GRANT ALL PRIVILEGES ON *.* TO 'ihunter'@'%' WITH GRANT OPTION; # 给用户授权
SHOW GRANTS FOR 'ihunter'@'%'; # 显示授权情况
DROP USER 'ihunter'@'%'; # 删除用户
mysql -h 127.0.0.1 -P 4000 -uroot -pwdqdmm@r -D test
# 启动 CDN, Nuster 部署指南(CDN部署)
https://abc.htmltoo.com/thread-44996.htm
vi /data/docker/nginx/nuster/tidb.cfg
frontend tidb-lb bind *:4000 mode tcp default_backend tidb-cluster backend tidb-cluster balance roundrobin mode tcp server s1 tidb1:4000 server s2 tidb2:4000 server s3 tidb3:4000
# 新增节点
#当我们需要动态新增pd节点时候需要把docker的启动run 修改为如下 其中:--join 只需要配置任意集群其中一个节点即可, 删除--initial-cluster 配置
应用: tidb -> 添加服务: pd4
镜像: pingcap/pd:latest
环境变量:
name = "pd4"
data-dir = "/data/pd4"
client-urls = "http://0.0.0.0:2379"
advertise-client-urls = "http://pd4:2379"
peer-urls = "http://0.0.0.0:2380"
advertise-peer-urls = "http://pd4:2380"
--join="http://pd1:2379"
卷:
/etc/localtime:/etc/localtime:ro
/data/file:/home/file
/data/db/tidb:/data
# tispark-master
应用: tidb -> 添加服务: tispark-master
镜像: pingcap/tispark:latest
命令：
/opt/spark/sbin/start-master.sh
变量：
SPARK_MASTER_PORT = 7077
SPARK_MASTER_WEBUI_PORT = 8080
# tispark-slave
应用: tidb -> 添加服务: tispark-slave
/opt/spark/sbin/start-slave.sh spark://tispark-master:7077
SPARK_WORKER_WEBUI_PORT = 38081
# 通过 spark-shell 运行 # tispark-slave
cd /opt/spark-2.4.3-bin-hadoop2.7/bin
./spark-shell
./spark-sql
# TiDB 集群监控
https://pingcap.com/docs-cn/stable/how-to/monitor/monitor-a-cluster/
# 在 TiSpark 的基础上快速实现 TiDB 数据读取和 OLAP 分析
https://abc.htmltoo.com/thread-45922.htm
======
---tidb:
当 --store = tikv 时，必须指定 path；当 --store = mocktikv 时，如果不指定 path，会使用默认值。
默认："/tmp/tidb”
http://www.htmltoo.com/
