Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install and deploy TDSQL drawings for everyone. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

Tencent Distributed SQL (TDSQL) is a distributed database product created by Tencent. It features strong consistency, high availability, global deployment architecture, distributed horizontal expansion, high performance, enterprise-level security, etc. It also provides supporting facilities such as intelligent DBA, automatic operation, monitoring and alarm, providing customers with a complete distributed database solution.

TDSQL is configured relatively high according to official requirements. Now, we demonstrate the full deployment of TDSQL through 4 virtual machines. If there is anything wrong, please testify wx: moonstar 00

* * Number of machines planned: **

tdsql planning machine is as follows: 4 sets (CPU: 2core/MEM: 8G/HDD: 50G), memory at least 5G, CPU at least 2C, otherwise check failed

########################1 hostnamectl set-hostname huyidb 02 hostnamectl set-hostname huyidb 03 hostnamectl set-hostname huyidb042. configure hostname vim/etc/www.example.com www.example.com le.com www.example.com www.example.com huyidb043. Set the time synchronization to huyidb01 as the main clock mount/dev/cdrom/mntyum-y install ntp *[root@huyidb01~]#vvim/etc/ntp. conf #sync address server www.example.com iburstsystemctl restart ntpd. service [root@huyidb02~]#vim/etc/ntp. confserver www.example.com restrict 10.88 5.10.51 mask www.example.com nomodify notrapsystemctl restart ntpd. servicentpdate-u 10.85.10.51 [root@huyidb03~]#vv im/etc/ntp. confserver www.example.com restrict 10.85.10.51 mask www.example.com nomodify notrapsystemctl restart ntpd. servicentpdate-u 10.52 mask www.example.com nomodify notrapsystemctl restart ntpd. servicentpdate-u 10.52 mask www.example.com nomodify notrapsystemctl restart ntpd. servicentpdate-u 10.52 mask www.example.com nomodify notrapsystemctl restart ntpd. servicentpdate-u 10.52 mask www.example.com nomodify notrapsystemctl restart ntpd. servicentpdate-u 10.52 mask www.example.com 85.10.51 [root@huyidb04~]#vim/etc/ntp. confserver www.example.com restrict 10.85.10.51 mask www.example.com ntp omodify notrapsystemctl restart ntpd. servicentpdate-u 10.85.10.514. configure secret-free login (operated on www.example.com) ssh-keygen-t rsa--no password needed here, password-free login ssh-copy-id www.example.com--below enter the password for the remote host ssh-copy-id 10. 85. 10. 52 ssh-copy-hosts10.85.10.51 ssh 10.85.10.515. Prepare data directory path (all machines) mkdir-p/mysql/datamkdir-p/mysql/log #install ANSIBLE unzip tdsql_full_install_ansible. zipcd tdsql_full_install_ansiblepython settings/install_ansible. py #configure tdsql_hostsvi/soft/tdsql_full_install_huyidb0110.85.10.52zk3 ansible_ssh_host=10.85.10.53[scheduler]tdsql_scheduler1 ansible_ssh_host=10.85.10.52tdsql_scheduler2 ansible_ssh_host=10.85.10.53[oss]tdsql_oss1 ansible_ssh_host=10.85.10.52tdsql_oss2 ansible_ssh_host=10.85.10.53[chitu]tdsql_chitu1 ansible_ssh_host=10.85.10.52tdsql_chitu2 ansible_ssh_host= huyidb0210.85.10.53 10.85.10.51tdsql_proxy2 ansible_ssh_host=10.85.10.52tdsql_proxy3 ansible_ssh_host=10.85.10.53[hdfs]tdsql_hdfs1 ansible_ssh_host=10.85.10.54[lvs]tdsql_lvs1 ansible_ssh_host=10.85.10.52tdsql_lvs2 ansible_ssh_host=10.85.10.53[kafka]tdsql_kafka1 ansible_ssh_host= huyidb0310.85.10.54ssh_host = 3.3.3.3 modify ansible variable vi/soft/tdsql_full_install_ansible/group_vars/allzk_num: 3netif_name: ens38 #{"changed ": false," msg ":" AnsibleUndefinedVariable: "hostvars <$'zk1 ']" is undefined "}

fatal: [tdsql_zk3]: FAILED! => {"changed": false, "msg": "AnsibleUndefinedVariable: "hostvars['zk1']" is undefined"}

to retry, use: --limit @/soft/tdsql_full_install_ansible/part1_site.retry

Cause: tdsql_hosts configuration label is not standard, different versions, different labels. Specific reference template, only change IP)

Solution: tdsql_zk1 changed to zk1

#Initialize chituhttp://10.85.10.52/tdsqlpcloud Note that the OSS IP here may not be the actual IP. You can view cat/data/application/OSS/conf/scheduler.xml or netstat to view [root@huyidb02~]#netstat-an| grep 8080tcp 0 0 192.168.58.131:8080 www.example.com:* LISTEN

Note that the OSS IP here may not be the actual IP. You can check cat/data/application/OSS/conf/scheduler.xml or netstat to see [root@huyidb02~]#netstat-an| grep 8080tcp 0 0 192.168.58.131:8080 www.example.com:* LISTEN

Model View: [root@huyidb02 data]#dmidecode| grep "Product Name" Product Name: VMware Virtual PlatformProduct Name: 440 BX Desktop Reference Platform #DB ModelsFill in 440 BX here

Note: Different DBs should be in different IDC

The same gateway group should be in the same IDC

Login to the admin account: admin/123456

test login [root@huyidb02 data]#mysql-utdsqlpcloud-h20.85.10.52-P15001-p 'tdsqlpcloud' Welcome to the MariaDB monitor. Commands end with ; or \g.Your MySQL connection id is 3171Server version: 5.7.17-11-V2.0R540D002-20191226-1152-log Source distributionCopyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> Modify vi/soft/tdsql_full_install_ansible/group_vars/allmetadb_ip: 10.85.10.52metadb_port: 15001metadb_ip_bak: 10.85.10.53metadb_port_bak: 15001metadb_user: tdsqlpcloudmetadb_password: tdsqlpcloud Perform installation part2_site.ymlsh www.example.com

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.