0096.T 查看TiDB各个节点的数据文件_日志文件_配置文件

rundba 2021-11-16

2021

1. 登录到部署了TiUP 的节点，执行tiup cluster edit-config tidb-test, 查看集群配置文件

[root@tidb1 ~]# tiup cluster edit-config tidb-test
Starting component `cluster`: /root/.tiup/components/cluster/v1.6.0/tiup-cluster edit-config tidb-test




global:
  user: tidb
  ssh_port: 22
  ssh_type: builtin
  deploy_dir: /tidb-deploy
  data_dir: /tidb-data
  os: linux
  arch: amd64
monitored:
  node_exporter_port: 9100
  blackbox_exporter_port: 9115
  deploy_dir: /tidb-deploy/monitor-9100
  data_dir: /tidb-data/monitor-9100
  log_dir: /tidb-deploy/monitor-9100/log
server_configs:
  tidb: {}
  tikv:
    log-level: warning
  pd: {}
  tiflash: {}
  tiflash-learner: {}
  pump: {}
  drainer: {}
  cdc: {}
tidb_servers:
- host: 192.168.80.141
  ssh_port: 22
  port: 4000
  status_port: 10080
  deploy_dir: /tidb-deploy/tidb-4000
  log_dir: /tidb-deploy/tidb-4000/log
  arch: amd64
  os: linux
tikv_servers:
- host: 192.168.80.138
  ssh_port: 22
  port: 20160
  status_port: 20180
  deploy_dir: /tidb-deploy/tikv-20160
  data_dir: /tidb-data/tikv-20160
  log_dir: /tidb-deploy/tikv-20160/log
  arch: amd64
  os: linux
- host: 192.168.80.139
  ssh_port: 22
  port: 20160
  status_port: 20180
  deploy_dir: /tidb-deploy/tikv-20160
  data_dir: /tidb-data/tikv-20160
  log_dir: /tidb-deploy/tikv-20160/log
  arch: amd64
  os: linux
- host: 192.168.80.140
  ssh_port: 22
  port: 20160
  status_port: 20180
  deploy_dir: /tidb-deploy/tikv-20160
  data_dir: /tidb-data/tikv-20160
  log_dir: /tidb-deploy/tikv-20160/log
  arch: amd64
  os: linux
tiflash_servers: []
pd_servers:
- host: 192.168.80.135
  ssh_port: 22
  name: pd-192.168.80.135-2379
  client_port: 2379
  peer_port: 2380
  deploy_dir: /tidb-deploy/pd-2379
  data_dir: /tidb-data/pd-2379
  log_dir: /tidb-deploy/pd-2379/log
  arch: amd64
  os: linux
- host: 192.168.80.136
  ssh_port: 22
  name: pd-192.168.80.136-2379
  client_port: 2379
  peer_port: 2380
  deploy_dir: /tidb-deploy/pd-2379
  data_dir: /tidb-data/pd-2379
  log_dir: /tidb-deploy/pd-2379/log
  arch: amd64
  os: linux
- host: 192.168.80.137
  ssh_port: 22
  name: pd-192.168.80.137-2379
  client_port: 2379
  peer_port: 2380
  deploy_dir: /tidb-deploy/pd-2379
  data_dir: /tidb-data/pd-2379
  log_dir: /tidb-deploy/pd-2379/log
  arch: amd64
  os: linux
monitoring_servers:
- host: 192.168.80.135
  ssh_port: 22
  port: 9090
  deploy_dir: /tidb-deploy/prometheus-9090
  data_dir: /tidb-data/prometheus-9090
  log_dir: /tidb-deploy/prometheus-9090/log
  external_alertmanagers: []
  arch: amd64
  os: linux
grafana_servers:
- host: 192.168.80.135
  ssh_port: 22
  port: 3000
  deploy_dir: /tidb-deploy/grafana-3000
  arch: amd64
  os: linux
  username: admin
  password: admin
  anonymous_enable: false
  root_url: ""
  domain: ""
alertmanager_servers:
- host: 192.168.80.135
  ssh_port: 22
  web_port: 9093
  cluster_port: 9094
  deploy_dir: /tidb-deploy/alertmanager-9093
  data_dir: /tidb-data/alertmanager-9093
  log_dir: /tidb-deploy/alertmanager-9093/log
  arch: amd64
  os: linux

在结果中找到：tidb_servers， tikv_servers 和pd_servers 三个选项，我们可以看到每个选项下面有文件夹deploy_dir 和data_dir。其中文件夹deploy_dir表示节点的软件目录，data_dir表示节点的数据目录。

2. 参考tidb_servers 的目录，连接入其中一个tidb 节点，查看里面的软件目录和数据目录:

1) 查看tidb 节点的软件目录:

[root@tidb1 ~]# cd /tidb-deploy/
[root@tidb1 tidb-deploy]# ls
monitor-9100  tidb-4000
[root@tidb1 tidb-deploy]# cd tidb-4000/
[root@tidb1 tidb-4000]# ls
bin  conf  log  scripts

其中，/tidb-deploy/tidb-4000/conf 目录下的文件tidb.toml 为配置文件;

/tidb-deploy/tidb-4000/log 目录下的文件为日志文件。

2) 查看配置文件

[root@tidb1 tidb-4000]# cat conf/tidb.toml 
# WARNING: This file is auto-generated. Do not edit! All your modification will be overwritten!
# You can use 'tiup cluster edit-config' and 'tiup cluster reload' to update the configuration
# All configuration items you want to change can be added to:
# server_configs:
#   tidb:
#     aa.b1.c3: value
#     aa.b2.c4: value

3) 查看日志文件

[root@tidb1 tidb-4000]# ls log/
tidb.log  tidb_slow_query.log  tidb_stderr.log

4) 查看tidb节点的数据目录

[root@tidb1 tidb-4000]# cd /tidb-data/
[root@tidb1 tidb-data]# ls
monitor-9100

发现只有监控数据，数据库数据不存储在tidb节点上。

3. 参考tikv_servers 的目录，连接入其中一个tikv 节点，查看里面的软件目录和数据目录:

1) 查看tidb部署目录

[root@tikv1 ~]# cd /tidb-deploy/
[root@tikv1 tidb-deploy]# ls
monitor-9100  tikv-20160
[root@tikv1 tidb-deploy]# cd tikv-20160/
[root@tikv1 tikv-20160]# ls
bin  conf  log  scripts

其中，/tidb-deploy/tikv-20160/conf 目录下的文件tikv.toml 为配置文件;

/tidb-deploy/tikv-20160/log 目录下的文件为日志文件。

[root@tikv1 tikv-20160]# ls scripts/
run_tikv.sh
[root@tikv1 tikv-20160]# ls bin
tikv-server
[root@tikv1 tikv-20160]# cat conf/tikv.toml 
# WARNING: This file is auto-generated. Do not edit! All your modification will be overwritten!
# You can use 'tiup cluster edit-config' and 'tiup cluster reload' to update the configuration
# All configuration items you want to change can be added to:
# server_configs:
#   tikv:
#     aa.b1.c3: value
#     aa.b2.c4: value
log-level = "warning"
[root@tikv1 tikv-20160]# ls log
tikv.log  tikv.log.2021-10-21-15:52:31.072196009  tikv.log.2021-10-23-13:47:47.135244951  tikv.log.2021-10-25-17:04:14.049807684  tikv.log.2021-10-26-17:24:11.049786844  tikv_stderr.log

2) 查看tikv 节点的数据目录

[root@tikv1 tikv-20160]# cd /tidb-data/
[root@tikv1 tidb-data]# ls
monitor-9100  tikv-20160
[root@tikv1 tidb-data]# cd tikv-20160/
[root@tikv1 tikv-20160]# ls
db  import  last_tikv.toml  LOCK  raft  raftdb.info  raftdb.info.2021-10-21-15:52:31.032246794  rocksdb.info  rocksdb.info.2021-10-21-15:52:31.124725043  snap  space_placeholder_file

其中db 目录下为数据文件:

[root@tikv1 tikv-20160]# ls db/
000014.sst  000017.sst  000026.sst  000033.sst  000036.sst  000038.log  000041.sst  CURRENT  IDENTITY  LOCK  MANIFEST-000034  OPTIONS-000030  OPTIONS-000040

4. 参考pd_servers 的目录，连接入其中一个pd 节点，查看里面的软件目录和数据目录：

1) 查看pd 节点的软件目录：

[root@pd1 ~]# cd /tidb-deploy/
[root@pd1 tidb-deploy]# ls
alertmanager-9093  grafana-3000  monitor-9100  pd-2379  prometheus-9090
[root@pd1 tidb-deploy]# cd pd-2379/
[root@pd1 pd-2379]# ls
bin  conf  log  scripts
[root@pd1 pd-2379]# cat conf/pd.toml 
# WARNING: This file is auto-generated. Do not edit! All your modification will be overwritten!
# You can use 'tiup cluster edit-config' and 'tiup cluster reload' to update the configuration
# All configuration items you want to change can be added to:
# server_configs:
#   pd:
#     aa.b1.c3: value
#     aa.b2.c4: value
[root@pd1 pd-2379]# ls bin
pd-server
[root@pd1 pd-2379]# ls log/
pd.log  pd_stderr.log
[root@pd1 pd-2379]# ls scripts/
run_pd.sh

其中，/tidb-deploy/pd-2379/conf 目录下的文件pd.toml 为配置文件;

/tidb-deploy/pd-2379/log 目录下的文件为日志文件。

2) 查看pd 节点的数据目录：

[root@pd1 pd-2379]# cd /tidb-data/
[root@pd1 tidb-data]# ls
alertmanager-9093  monitor-9100  pd-2379  prometheus-9090
[root@pd1 tidb-data]# cd pd-2379/
[root@pd1 pd-2379]# ls
dashboard.sqlite.db  member  region-meta
[root@pd1 pd-2379]# ls region-meta/
000002.ldb  000005.ldb  000008.ldb  000009.log  CURRENT  CURRENT.bak  LOCK  LOG  MANIFEST-000010
[root@pd1 pd-2379]# ls member/
snap  wa

长按二维码

加入>>国产DB学习交流群

请注明:来自rundba，申请加入国产DB学习交流群

tidb

文章转载自rundba，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

0096.T 查看TiDB各个节点的数据文件_日志文件_配置文件

评论