当前位置:网站首页>Tidb二进制集群搭建
Tidb二进制集群搭建
2022-08-11 05:59:00 【JACK-JIE】
机器准备
IP | 主机名 | 用户 | 组件 |
---|---|---|---|
192.168.10.61 | tidb-1 | tidb | pd,tikv,tidb |
192.168.10.62 | tidb-2 | tidb | pd,tikv,tidb |
192.168.10.63 | tidb-3 | tidb | pd,tikv,tidb |
关闭防火墙及selinux
[[email protected] software]# systemctl stop firewalld && systemctl disable firewalld
[[email protected] software]# sed -i 's#SELINUX=enforcing#SELINUX=disabled#g' /etc/selinux/config
安装用到的工具
yum -y install wget lrzsz curl vim net-tools screen
安装包准备
- 下载安装包
[[email protected] software]# wget http://download.pingcap.org/tidb-latest-linux-amd64.tar.gz
[[email protected] software]# wget http://download.pingcap.org/tidb-latest-linux-amd64.sha256
- 检查安装包完整性,返回 ok 则正确
[[email protected] software]# sha256sum -c tidb-latest-linux-amd64.sha256
tidb-latest-linux-amd64.tar.gz: 确定
解压软件包到指定目录
[[email protected] software]# tar -zxf tidb-latest-linux-amd64.tar.gz -C /data/
[[email protected] software]# cd /data/
[[email protected] data]# mv tidb-v5.0.1-linux-amd64/ tidb
添加tidb用户并配置属主属组
[[email protected] data]# useradd tidb
[[email protected] data]# chown -R tidb.tidb /data/tidb/
创建所需目录
[[email protected] tidb]# su tidb
[[email protected] tidb]$ mkdir /data/tidb/{
data,logs} -p
[[email protected] tidb]$ mkdir /data/tidb/data/{
pd,tikv} -p
部署pd-server
- tidb-1
[[email protected] tidb]$ ./bin/pd-server --name=pd1 --data-dir=/data/tidb/data/pd --client-urls="http://192.168.10.61:2379" --peer-urls="http://192.168.10.61:2380" --initial-cluster="pd1=http://192.168.10.61:2380,pd2=http://192.168.10.62:2380,pd3=http://192.168.10.63:2380" -L "info" --log-file=/data/tidb/logs/pd.log &
- tidb-2
[[email protected] tidb]$ ./bin/pd-server --name=pd2 --data-dir=/data/tidb/data/pd --client-urls="http://192.168.10.62:2379" --peer-urls="http://192.168.10.62:2380" --initial-cluster="pd1=http://192.168.10.61:2380,pd2=http://192.168.10.62:2380,pd3=http://192.168.10.63:2380" -L "info" --log-file=/data/tidb/logs/pd.log &
- tidb-3
[[email protected] tidb]$ ./bin/pd-server --name=pd3 --data-dir=/data/tidb/data/pd --client-urls="http://192.168.10.63:2379" --peer-urls="http://192.168.10.63:2380" --initial-cluster="pd1=http://192.168.10.61:2380,pd2=http://192.168.10.62:2380,pd3=http://192.168.10.63:2380" -L "info" --log-file=/data/tidb/logs/pd.log &
- 验证
[[email protected] tidb]$ netstat -lntp | grep pd
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 192.168.10.61:2379 0.0.0.0:* LISTEN 17187/./bin/pd-serv
tcp 0 0 192.168.10.61:2380 0.0.0.0:* LISTEN 17187/./bin/pd-serv
部署tikv
- tidb-1
[[email protected] tidb]$ ./bin/tikv-server --pd="192.168.10.61:2379,192.168.10.62:2379,192.168.10.63:2379" --addr="192.168.10.61:20160" --data-dir=/data/tidb/data/tikv --log-file=/data/tidb/logs/tikv.log &
- tidb-2
[[email protected] tidb]$ ./bin/tikv-server --pd="192.168.10.61:2379,192.168.10.62:2379,192.168.10.63:2379" --addr="192.168.10.62:20160" --data-dir=/data/tidb/data/tikv --log-file=/data/tidb/logs/tikv.log &
- tidb-3
[[email protected] tidb]$ ./bin/tikv-server --pd="192.168.10.61:2379,192.168.10.62:2379,192.168.10.63:2379" --addr="192.168.10.63:20160" --data-dir=/data/tidb/data/tikv --log-file=/data/tidb/logs/tikv.log &
- 验证
[[email protected] tidb]$ netstat -lntp | grep kv
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:20180 0.0.0.0:* LISTEN 17342/./bin/tikv-se
tcp6 0 0 192.168.10.61:20160 :::* LISTEN 17342/./bin/tikv-se
部署tidb
- tidb-1
[[email protected] tidb]$ ./bin/tidb-server --store=tikv --path="192.168.10.61:2379,192.168.10.62:2379,192.168.10.63:2379" --log-file=/data/tidb/logs/tidb.log &
- tidb-2
[[email protected] tidb]$ ./bin/tidb-server --store=tikv --path="192.168.10.61:2379,192.168.10.62:2379,192.168.10.63:2379" --log-file=/data/tidb/logs/tidb.log &
- tidb-3
[[email protected] tidb]$ ./bin/tidb-server --store=tikv --path="192.168.10.61:2379,192.168.10.62:2379,192.168.10.63:2379" --log-file=/data/tidb/logs/tidb.log &
- 验证
[[email protected] tidb]$ netstat -lntp | grep db
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp6 0 0 :::10080 :::* LISTEN 17462/./bin/tidb-se
tcp6 0 0 :::4000 :::* LISTEN 17462/./bin/tidb-se
链接测试
[[email protected] ~]# mysql -h 192.168.10.61 -P 4000 -uroot -D test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.25-TiDB-v5.0.1 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| INFORMATION_SCHEMA |
| METRICS_SCHEMA |
| PERFORMANCE_SCHEMA |
| mysql |
| test |
+--------------------+
5 rows in set (0.00 sec)
边栏推荐
- How to choose professional, safe and high-performance remote control software
- 使用Keras构建GAN,以Mnist为例
- 联想集团:2022/23财年第一季度业绩
- Redis源码:Redis源码怎么查看、Redis源码查看顺序、Redis外部数据结构到Redis内部数据结构查看源码顺序
- Eight-legged text of mysql
- 拼多多API接口(附上我的可用API)
- MySQL 版本升级心得
- 姿态解算-陀螺仪+欧拉法
- Douyin API interface
- Pinduoduo API interface (attach my available API)
猜你喜欢
Redis源码:Redis源码怎么查看、Redis源码查看顺序、Redis外部数据结构到Redis内部数据结构查看源码顺序
HCIP OSPF dynamic routing protocol
mmdetection的安装和训练、测试didi数据集的步骤(含结果)
JD.com product details API call example explanation
A used in the study of EEG ultra scanning analysis process
Shell:三剑客之awk
拼多多API接口(附上我的可用API)
亚马逊API接口大全
每日sql:求好友申请通过率
抖音API接口
随机推荐
ROS 话题通信理论模型
如何选择专业、安全、高性能的远程控制软件
concept noun
淘宝API接口参考
Especially the redis
强烈推荐一款好用的API接口
Find the shops that have sold more than 1,000 yuan per day for more than 30 consecutive days in the past six months
《Generative Adversarial Networks》
拼多多api接口应用示例
ssh服务攻防与加固
知识蒸馏Knownledge Distillation
技能在赛题解析:交换机防环路设置
技术分享 | 实战演练接口自动化如何处理 Form 请求?
抖音API接口大全
【推荐系统】:协同过滤和基于内容过滤概述
Discourse 的关闭主题(Close Topic )和重新开放主题
Attitude solution - gyroscope + Euler method
Coordinate system in navigation and positioning
每日sql:求好友申请通过率
淘宝API常用接口与获取方式