使用 ansible 部署 TiDB 集群
架構(gòu)圖
節(jié)點(diǎn)規(guī)劃
120.52.146.213 Control Machine
120.52.146.214 PD1_TiDB1
120.52.146.215 PD2_TiDB2
120.52.146.216 PD3
120.52.146.217 TiKV1
120.52.146.218 TiKV2
120.52.146.219 TiKV3
軟件要求
CentOS 7.3 (64 bit) or later with Python 2.7 installed
1、在控制節(jié)點(diǎn)上安裝依賴軟件
# yum -y install epel-release git curl sshpass
# yum -y install python-pip
2、創(chuàng)建 tidb 用戶
# useradd tidb
# passwd tidb
3、配置sudo權(quán)限
# visudo
tidb ALL=(ALL) NOPASSWD: ALL
4、切換用戶，生成SSH-KEY
# su - tidb
$ ssh-keygen -t rsa
5、下載 tidb ansible 項(xiàng)目代碼
$ git clone -b v3.0.4 https://github.com/pingcap/tidb-ansible.git
6、安裝ansible和相關(guān)依賴
$ cd /home/tidb/tidb-ansible
$ sudo pip install -r requirements.txt
$ ansible --version
7、配置SSH互信
$ cd /home/tidb/tidb-ansible
$ vi hosts.ini
[servers]
120.52.146.214
120.52.146.215
120.52.146.216
120.52.146.217
120.52.146.218
120.52.146.219
[all:vars]
username = tidb
ntp_server = pool.ntp.org
$ ansible-playbook -i hosts.ini create_users.yml -u root -k
8、安裝NTP
$ cd /home/tidb/tidb-ansible
$ ansible-playbook -i hosts.ini deploy_ntp.yml -u tidb -b
9、掛載磁盤（這一步可以在裝系統(tǒng)的時(shí)候就準(zhǔn)備好）
# fdisk -l
# parted -s -a optimal /dev/sdb mklabel gpt -- mkpart primary ext4 1 -1
# mkfs.ext4 /dev/sdb
# lsblk -f
# vim /etc/fstab
UUID=c51eb23b-195c-4061-92a9-3fad812cc12f /data1 ext4 defaults,nodelalloc,noatime 0 0
# mkdir /data1
# mount -a
# mount -t ext4
/dev/sdb on /data1 type ext4 (rw,noatime,nodelalloc,data=ordered)
10、根據(jù)集群架構(gòu)修改 inventory.ini
## TiDB Cluster Part
[tidb_servers]
120.52.146.214
120.52.146.215
[tikv_servers]
120.52.146.217
120.52.146.218
120.52.146.219
[pd_servers]
120.52.146.214
120.52.146.215
120.52.146.216
[spark_master]
[spark_slaves]
[lightning_server]
[importer_server]
## Monitoring Part
# prometheus and pushgateway servers
[monitoring_servers]
120.52.146.214
[grafana_servers]
120.52.146.214
# node_exporter and blackbox_exporter servers
[monitored_servers]
120.52.146.214
120.52.146.215
120.52.146.216
120.52.146.217
120.52.146.218
120.52.146.219
[alertmanager_servers]
120.52.146.214
11、下載部署包到本地
$ ansible-playbook local_prepare.yml
12、初始化系統(tǒng)環(huán)境修改內(nèi)核參數(shù)
$ ansible-playbook bootstrap.yml
13、部署tidb集群
$ ansible-playbook deploy.yml
14、啟動(dòng)集群
$ ansible-playbook start.yml
15、訪問(wèn)集群，默認(rèn)可以不驗(yàn)證直接連接
$ mysql -uroot -h 120.52.146.214 -P 4000
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 182
Server version: 5.7.25-TiDB-v3.0.4 MySQL Community Server (Apache License 2.0)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| INFORMATION_SCHEMA |
| PERFORMANCE_SCHEMA |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)
16、設(shè)置密碼
TiDB 在數(shù)據(jù)庫(kù)初始化時(shí)會(huì)生成一個(gè) 'root'@'%' 的默認(rèn)賬戶。
TiDB 將密碼存在 mysql.user 系統(tǒng)數(shù)據(jù)庫(kù)里面。只有擁有 CREATE USER 權(quán)限，或者擁有 mysql 數(shù)據(jù)庫(kù)權(quán)限（INSERT 權(quán)限用于創(chuàng)建，UPDATE 權(quán)限用于更新）的用戶才能夠設(shè)置或修改密碼。
> SET PASSWORD FOR 'root'@'%' = 'xxx';
> FLUSH PRIVILEGES;
或者
> ALTER USER 'test'@'localhost' IDENTIFIED BY 'mypass';
> FLUSH PRIVILEGES;
參考：
浙公網(wǎng)安備 33010602011771號(hào)