安装 TIDB

安装 TIDB

fdisk -l

# 格式化
sudo mkfs.ext4 /dev/sdb 

# 挂载磁盘
DISK_UUID=$(blkid -s UUID -o value /dev/sdb)
sudo mkdir -p /mnt/$DISK_UUID
sudo mount -t ext4 /dev/sdb /mnt/$DISK_UUID

echo UUID=`sudo blkid -s UUID -o value /dev/sdb` /mnt/$DISK_UUID ext4 defaults 0 2 | sudo tee -a /etc/fstab

# 创建多个目录 并mount 到discovery directory
for i in $(seq 1 10); do
    sudo mkdir -p /mnt/${DISK_UUID}/vol${i} /mnt/disks/${DISK_UUID}_vol${i}
    sudo mount --bind /mnt/${DISK_UUID}/vol${i} /mnt/disks/${DISK_UUID}_vol${i}
done

# /etc/fstab 自动挂载
for i in $(seq 1 10); do
    echo /mnt/${DISK_UUID}/vol${i} /mnt/disks/${DISK_UUID}_vol${i} none bind 0 0 | sudo tee -a /etc/fstab
done


cd /mnt/disks

1. Helm 安装 TIDB

kubectl apply -f https://raw.githubusercontent.com/pingcap/tidb-operator/v1.1.11/manifests/crd.yaml
kubectl apply -f crd.yaml 

# 获取源，并更新helm库
helm repo add pingcap https://charts.pingcap.org/
helm repo update

# 创建k8s命名空间
kubectl create namespace tidb-admin

helm install --namespace tidb-admin tidb-operator pingcap/tidb-operator --version v1.1.11
# 国内镜像
helm install --namespace tidb-admin tidb-operator pingcap/tidb-operator --version v1.1.11 \
    --set operatorImage=registry.cn-beijing.aliyuncs.com/tidb/tidb-operator:v1.1.11 \
    --set tidbBackupManagerImage=registry.cn-beijing.aliyuncs.com/tidb/tidb-backup-manager:v1.1.11 \
    --set scheduler.kubeSchedulerImageName=registry.cn-hangzhou.aliyuncs.com/google_containers/kube-scheduler

# 查看是否运行TIDB
kubectl get pods --namespace tidb-admin -l app.kubernetes.io/instance=tidb-operator

2. 部署 TIDB 集群 官方文档

kubectl create namespace tidb-cluster && \
    kubectl -n tidb-cluster apply -f https://raw.githubusercontent.com/pingcap/tidb-operator/master/examples/basic/tidb-cluster.yaml

# 国内镜像
kubectl create namespace tidb-cluster && \
    kubectl -n tidb-cluster apply -f https://raw.githubusercontent.com/pingcap/tidb-operator/master/examples/basic-cn/tidb-cluster.yaml

# 输出
namespace/tidb-cluster created
tidbcluster.pingcap.com/basic created

# 集群和监控
kubectl create namespace tidb-cluster && \
    kubectl -n tidb-cluster apply -f https://raw.githubusercontent.com/pingcap/tidb-operator/master/examples/basic-cn/tidb-cluster.yaml

部署本地卷

# 修改azk8s.cn
- image: "quay.mirrors.ustc.edu.cn/external_storage/local-volume-provisioner:v2.3.4"

$ ~/tidb/tidb-operator/manifests/local-dind# kubectl apply -f local-volume-provisioner.yaml

kubectl get po -n kube-system -l app=local-volume-provisioner

# 查看本地卷
kubectl get pv | grep local-storage

# 创建一个命名空间
kubectl create namespace tidb 

helm install tidb-cluster  charts/tidb-cluster  --namespace=tidb --version=v1.11.1

# 输出
NAME: tidb-cluster
LAST DEPLOYED: Thu Apr  1 19:54:48 2021
NAMESPACE: tidb
STATUS: deployed
REVISION: 1
TEST SUITE: None
NOTES:
Cluster Startup
1. Watch tidb-cluster up and running
     watch kubectl get pods --namespace tidb -l app.kubernetes.io/instance=tidb-cluster -o wide
2. List services in the tidb-cluster
     kubectl get services --namespace tidb -l app.kubernetes.io/instance=tidb-cluster

Cluster access
* Access tidb-cluster using the MySQL client
    kubectl port-forward -n tidb svc/tidb-cluster-tidb 4000:4000 &
    mysql -h 127.0.0.1 -P 4000 -u root -D test
  Set a password for your user
    SET PASSWORD FOR 'root'@'%' = 'HVFlLJ0ly2'; FLUSH PRIVILEGES;
* View monitor dashboard for TiDB cluster
   kubectl port-forward -n tidb svc/tidb-cluster-grafana 3000:3000
   Open browser at http://localhost:3000. The default username and password is admin/admin.
   If you are running this from a remote machine, you must specify the server's external IP address.'

# 查看tidb-cluster是否运行成功
watch kubectl get pods --namespace tidb -l app.kubernetes.io/instance=tidb-cluster -o wide

如果 pd 超时了，就重新安装

helm uninstall tidb-cluster  charts/tidb-cluster  --namespace=tidb

kubectl delete namespace tidb

kubectl get svc -A

# 临时转发端口。真正的开发环境不允许对外网开放
kubectl port-forward svc/tidb-cluster-tidb 4000:4000 --namespace=tidb --address 0.0.0.0

# 监控台
kubectl port-forward svc/tidb-cluster-grafana 3000:3000 --namespace=tidb --address 0.0.0.0

连接数据库：
192.168.79.180
用户名: root
密码： 空
端口：4000

赏

谢谢你请我吃糖果

支付宝

微信

• 本文作者： MISAKIGA
• 本文链接： https://misakiga.github.io/2021/04/01/k8s/TIDB安装/
• 版权声明： 本博客所有文章除特别声明外，均采用 MIT 许可协议。转载请注明出处！