腾讯TDSQL数据库集群环境安装文档.pdf

王燕辉

811

20页

35次

2021-02-23

25墨值下载

笔记本：数据库-TDSQL

创建时间： 2021-02-23 10:43 更新时间： 2021-02-23 10:46

作者：王燕辉

腾讯TDSQL数据库集群环境安装文档

一、环境介绍

在4台服务器上的/etc/hosts上配置上相应的ip地址和主机名的映射

IP地址主机名操作系统资源配置角色

90.90.90.221 tdsql1 centos 7.6 16G MEM/16CPU tdsql1:zk1,kafka1,proxy1,db1

90.90.90.222 tdsql2 centos 7.6 16G MEM/16CPU tdsql2:zk2,kafka2,proxy2,db2,oss1,scheduler1,chitu1,monitor1,lvs

90.90.90.223 tdsql3 centos 7.6 16G MEM/16CPU tdsql3:zk3,kafka3,proxy3,db3,oss2,scheduler2,chitu2,monitor2,lvs

90.90.90.224 tdsql4 centos 7.6 16G MEM/16CPU tdsql4:ansible,hdfs,es,consumer

配置互信

配置互信，保证tdsql4可以将安装包无密码推送到其它服务器上

[root@tdsql4 ~]# ssh-keygen -t rsa

[root@tdsql4 ~]# ssh-copy-id tdsql1

[root@tdsql4 ~]# ssh-copy-id tdsql2

[root@tdsql4 ~]# ssh-copy-id tdsql3

[root@tdsql4 ~]# ssh-copy-id tdsql4

规划磁盘

在每个服务器上配置/data,/data1两个磁盘，每个磁盘至少100G

[root@tdsql4 ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/centos-root 20G 6.9G 14G 35% /

devtmpfs 7.9G 0 7.9G 0% /dev

tmpfs 7.9G 0 7.9G 0% /dev/shm

tmpfs 7.9G 8.9M 7.9G 1% /run

tmpfs 7.9G 0 7.9G 0% /sys/fs/cgroup

/dev/sr0 4.3G 4.3G 0 100% /mnt/cdrom

/dev/sda1 5.0G 132M 4.9G 3% /boot

/dev/mapper/vg-data1 100G 33M 100G 1% /data1

/dev/mapper/vg-data 100G 586M 100G 1% /data

tmpfs 1.6G 0 1.6G 0% /run/user/0

安装TDSQL数据库集群环境，主要用到以下3个安装包

[root@tdsql4 ~]# ls

ansible_install tdsql_install tdsql_packet

二、配置安装前的环境

[root@tdsql4 script]# ls -l ansible_install/script/

total 20

-rw-r--r--. 1 root root 2390 Jun 10 2020 init_os_for_apt_install.sh

-rw-r--r--. 1 root root 1513 Jun 10 2020 init_os_for_yum_install.sh

-rw-r--r--. 1 root root 1058 Jun 10 2020 install_ansible.sh

-rw-r--r--. 1 root root 266 Jun 10 2020 install_python3_for_arm.sh

-rw-r--r--. 1 root root 253 Jun 10 2020 install_python3_for_x86.sh

安装必要的系统依赖包

将系统盘挂载到挂载点后，配置好yum环境，执行以下脚本来安装TDSQL环境必要的系统包

[root@tdsql4 script]# sh init_os_for_yum_install.sh

安装python3工具，并使其生效

[root@tdsql4 script]# sh install_python3_for_x86.sh

[root@tdsql4 script]# source /etc/profile

[root@tdsql4 script]# python3 --version

Python 3.8.2

安装ansible工具

[root@tdsql4 script]# sh install_ansible.sh

三、开始TDSQL的安装

TDSQL的主要配置文件

[root@tdsql4 ~]# ls /root/tdsql_install

group_files group_vars playbooks roles tdsql_hosts tdsql_update_hosts

TDSQL的主要配置文件只有2个，一个是tdsql_hosts，另一个是group_vars/all文件。

配置tdsql_hosts文件

备注：此文件为安装TDSQL环境的主要文件之一

[root@tdsql4 tdsql_install]# cat /root/tdsql_install/tdsql_hosts

[tdsql_allmacforcheck]

tdsql_tdsql1 ansible_ssh_host=90.90.90.221

tdsql_tdsql2 ansible_ssh_host=90.90.90.222

tdsql_tdsql3 ansible_ssh_host=90.90.90.223

tdsql_tdsql4 ansible_ssh_host=90.90.90.224

[tdsql_zk]

tdsql_zk1 ansible_ssh_host=90.90.90.221

tdsql_zk2 ansible_ssh_host=90.90.90.222

tdsql_zk3 ansible_ssh_host=90.90.90.223

[tdsql_scheduler]

tdsql_scheduler1 ansible_ssh_host=90.90.90.222

tdsql_scheduler2 ansible_ssh_host=90.90.90.223

[tdsql_oss]

tdsql_oss1 ansible_ssh_host=90.90.90.222

tdsql_oss2 ansible_ssh_host=90.90.90.223

[tdsql_chitu]

tdsql_chitu1 ansible_ssh_host=90.90.90.222

tdsql_chitu2 ansible_ssh_host=90.90.90.223

[tdsql_monitor]

tdsql_monitor1 ansible_ssh_host=90.90.90.222

tdsql_monitor2 ansible_ssh_host=90.90.90.223

[tdsql_db]

tdsql_db1 ansible_ssh_host=90.90.90.221

tdsql_db2 ansible_ssh_host=90.90.90.222

tdsql_db3 ansible_ssh_host=90.90.90.223

[tdsql_proxy]

tdsql_proxy1 ansible_ssh_host=90.90.90.221

tdsql_proxy2 ansible_ssh_host=90.90.90.222

tdsql_proxy3 ansible_ssh_host=90.90.90.223

[tdsql_hdfs]

tdsql_hdfs1 ansible_ssh_host=90.90.90.224

[tdsql_lvs]

tdsql_lvs1 ansible_ssh_host=90.90.90.222

tdsql_lvs2 ansible_ssh_host=90.90.90.223

[tdsql_kafka]

tdsql_kafka1 ansible_ssh_host=90.90.90.221

tdsql_kafka2 ansible_ssh_host=90.90.90.222

tdsql_kafka3 ansible_ssh_host=90.90.90.223

[tdsql_consumer]

tdsql_consumer1 ansible_ssh_host=90.90.90.224

[tdsql_es]

tdsql_es1 ansible_ssh_host=90.90.90.224

[tdsql_intercity]

tdsql_intercity1 ansible_ssh_host=90.90.90.224

[tdsql_newdb]

tdsql_newdb1 ansible_ssh_host=1.1.1.1

tdsql_newdb2 ansible_ssh_host=2.2.2.2

tdsql_newdb3 ansible_ssh_host=3.3.3.3

[tdsql_ansible_test]

tdsql_ansible_test1 ansible_ssh_host=1.1.1.1

of 20

25墨值下载

mysql tdsql

关注

评论