TiDB の本番向けのデプロイを単一ホストで試してみます。 チュートリアルがあるので、基本はそれにそっていって見てみました。
環境
% cat /etc/os-release PRETTY_NAME="Debian GNU/Linux 12 (bookworm)" NAME="Debian GNU/Linux" VERSION_ID="12" VERSION="12 (bookworm)" VERSION_CODENAME=bookworm ID=debian HOME_URL="https://www.debian.org/" SUPPORT_URL="https://www.debian.org/support" BUG_REPORT_URL="https://bugs.debian.org/"
% uname -a Linux ip-172-26-15-65 6.1.0-21-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.90-1 (2024-05-03) x86_64 GNU/Linux
% cat /proc/cpuinfo| grep CPU model name : Intel(R) Xeon(R) Platinum 8259CL CPU @ 2.50GHz model name : Intel(R) Xeon(R) Platinum 8259CL CPU @ 2.50GHz
% free
total used free shared buff/cache available
Mem: 8044380 544740 7036712 13024 720524 7499640
Swap: 0 0 0
セットアップ
% tiup cluster
Deploy a TiDB cluster for production
Usage:
tiup cluster [command]
Available Commands:
check Perform preflight checks for the cluster.
deploy Deploy a cluster for production
start Start a TiDB cluster
stop Stop a TiDB cluster
restart Restart a TiDB cluster
scale-in Scale in a TiDB cluster
scale-out Scale out a TiDB cluster
destroy Destroy a specified cluster
clean (EXPERIMENTAL) Cleanup a specified cluster
upgrade Upgrade a specified TiDB cluster
display Display information of a TiDB cluster
prune Destroy and remove instances that is in tombstone state
list List all clusters
audit Show audit log of cluster operation
import Import an exist TiDB cluster from TiDB-Ansible
edit-config Edit TiDB cluster config
show-config Show TiDB cluster config
reload Reload a TiDB cluster's config and restart if needed
patch Replace the remote package with a specified package and restart the service
rename Rename the cluster
enable Enable a TiDB cluster automatically at boot
disable Disable automatic enabling of TiDB clusters at boot
replay Replay previous operation and skip successed steps
template Print topology template
tls Enable/Disable TLS between TiDB components
meta backup/restore meta information
rotatessh rotate ssh keys on all nodes
help Help about any command
completion Generate the autocompletion script for the specified shell
Flags:
-c, --concurrency int max number of parallel tasks allowed (default 5)
--format string (EXPERIMENTAL) The format of output, available values are [default, json] (default "default")
-h, --help help for tiup
--ssh string (EXPERIMENTAL) The executor type: 'builtin', 'system', 'none'.
--ssh-timeout uint Timeout in seconds to connect host via SSH, ignored for operations that don't need an SSH connection. (default 5)
-v, --version version for tiup
--wait-timeout uint Timeout in seconds to wait for an operation to complete, ignored for operations that don't fit. (default 120)
-y, --yes Skip all confirmations and assumes 'yes'
Use "tiup cluster help [command]" for more information about a command.
% tiup list tidb Available versions for tidb: Version Installed Release Platforms ------- --------- ------- --------- nightly -> v8.2.0-alpha-nightly 2024-06-12T02:13:37Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v3.0.0 2020-04-16T14:03:31+08:00 darwin/amd64,linux/amd64 v3.0 2020-04-16T16:58:06+08:00 darwin/amd64,linux/amd64 v3.0.1 2020-04-27T19:38:36+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.0.2 2020-04-16T23:55:11+08:00 darwin/amd64,linux/amd64 v3.0.3 2020-04-17T00:16:31+08:00 darwin/amd64,linux/amd64 v3.0.4 2020-04-17T00:22:46+08:00 darwin/amd64,linux/amd64 v3.0.5 2020-04-17T00:29:45+08:00 darwin/amd64,linux/amd64 v3.0.6 2020-04-17T00:39:33+08:00 darwin/amd64,linux/amd64 v3.0.7 2020-04-17T00:46:32+08:00 darwin/amd64,linux/amd64 v3.0.8 2020-04-17T00:54:19+08:00 darwin/amd64,linux/amd64 v3.0.9 2020-04-17T01:00:58+08:00 darwin/amd64,linux/amd64 v3.0.10 2020-03-13T14:11:53.774527401+08:00 darwin/amd64,linux/amd64 v3.0.11 2020-04-17T01:09:20+08:00 darwin/amd64,linux/amd64 v3.0.12 2020-04-17T01:16:04+08:00 darwin/amd64,linux/amd64 v3.0.13 2020-04-26T17:25:01+08:00 darwin/amd64,linux/amd64 v3.0.14 2020-05-09T21:11:49+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.0.15 2020-06-05T16:53:32+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.0.16 2020-07-03T20:07:45+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.0.17 2020-08-03T15:27:29+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.0.18 2020-08-21T20:02:59+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.0.19 2020-09-25T18:24:11+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.0.20 2020-12-25T15:20:36+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.1.0-beta 2020-05-22T14:35:59+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.1.0-beta.1 2020-05-22T15:22:30+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.1.0-beta.2 2020-05-22T15:28:20+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.1.0-rc 2020-05-22T15:56:23+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.1.0 2020-05-22T15:34:33+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.1.1 2020-04-30T21:02:32+08:00 darwin/amd64,linux/amd64,linux/arm64 v3.1.2 2020-06-04T17:55:40+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.0-beta 2020-05-26T11:18:05+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.0-beta.1 2020-05-26T11:42:48+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.0-beta.2 2020-05-26T11:56:51+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.0-rc 2020-05-26T14:56:06+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.0-rc.1 2020-04-29T01:03:31+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.0-rc.2 2020-05-15T21:54:51+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.0 2020-05-28T20:10:11+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.1 2020-06-12T21:21:12+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.2 2020-07-01T19:59:39+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.3 2020-07-25T01:03:31+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.4 2020-07-31T16:44:42+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.5 2020-08-31T23:53:35+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.6 2020-09-15T22:13:29+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.7 2020-09-29T20:15:07+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.8 2020-10-30T19:30:22+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.9 2020-12-21T17:25:20+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.10 2021-01-15T13:15:09+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.11 2021-02-26T17:39:23+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.12-20210427 2021-05-08T11:09:37+08:00 linux/amd64 v4.0.12 2021-04-02T16:55:00+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.13 2021-05-27T22:18:32+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.14 2021-07-27T18:08:31+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.15 2021-09-23T18:38:19+08:00 darwin/amd64,linux/amd64,linux/arm64 v4.0.16 2021-12-17T18:09:01+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.0-20210329 2021-03-29T19:45:19+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.0-20210403 2021-04-03T09:13:36+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.0-20210408 2021-04-08T17:02:41+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.0-rc 2021-01-12T23:40:27+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.0 2021-04-07T17:30:00+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.1 2021-04-24T21:31:28+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.2 2021-06-09T22:49:33+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.3 2021-07-02T16:13:22+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.4 2021-09-14T17:53:19+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.5 2021-12-03T11:26:56+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.0.6 2021-12-30T22:41:05+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.1.0 2021-06-24T16:23:50+08:00 darwin/amd64,linux/amd64,linux/arm64 v5.1.1 2021-07-30T15:59:38+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.1.2 2021-09-27T13:02:47+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.1.3 2021-12-03T17:46:16+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.1.4 2022-02-22T12:40:06+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.1.5 2022-12-28T12:18:53+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.2.0 2021-08-27T18:40:58+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.2.1 2021-09-09T18:50:00+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.2.2 2021-10-29T13:51:56+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.2.3 2021-12-02T18:42:12+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.2.4 2022-04-26T15:36:17+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.3.0 2021-11-29T17:05:42+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.3.1 2022-03-03T19:44:31+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.3.2 2022-06-29T11:05:04+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.3.3 2022-09-14T19:16:40+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.3.4 2022-11-24T12:36:22+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.4.0 2022-02-11T20:11:44+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.4.1 2022-05-13T13:48:10+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.4.2 2022-07-08T10:12:37+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v5.4.3 2022-10-13T22:13:21+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.0.0 2022-04-06T11:34:40+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.0 2022-06-13T12:30:16+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.1 2022-09-01T12:09:05+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.2 2022-10-24T15:16:17+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.3 2022-12-05T11:50:23+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.4 2023-02-08T11:34:10+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.5 2023-02-28T11:23:57+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.6 2023-04-12T11:05:35+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.1.7 2023-07-12T11:22:57+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.2.0 2022-08-23T09:14:36+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.3.0 2022-09-30T10:59:36+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.4.0 2022-11-17T11:26:23+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.0 2022-12-29T11:32:06+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.1 2023-03-10T13:36:50+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.2 2023-04-21T10:52:46+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.3 2023-06-14T14:36:43+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.4 2023-08-28T11:40:24+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.5 2023-09-21T11:51:14+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.6 2023-12-07T07:12:10Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.7 2024-01-08T04:14:09Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.8 2024-02-02T03:32:39Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.5.9 2024-04-12T03:42:39Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v6.6.0 2023-02-20T16:43:16+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.0.0 2023-03-30T10:33:19+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.1.0 2023-05-31T14:49:49+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.1.1 2023-07-24T11:39:38+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.1.2 2023-10-25T03:58:13Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.1.3 2023-12-21T03:47:53Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.1.4 2024-03-11T04:48:40Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.1.5 2024-04-26T03:08:42Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.2.0 2023-06-29T11:57:48+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.3.0 2023-08-14T12:41:31+08:00 darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.4.0 2023-10-12T04:07:12Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.5.0 2023-12-01T03:55:55Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.5.1 2024-02-29T03:44:23Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v7.6.0 2024-01-25T04:29:14Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v8.0.0 2024-03-29T04:28:29Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v8.1.0 YES 2024-05-24T09:02:17Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64 v8.2.0-alpha-nightly 2024-06-12T02:13:37Z darwin/amd64,darwin/arm64,linux/amd64,linux/arm64
% ssh-keygen -t ed25519 -C "tidb sandbox" Generating public/private ed25519 key pair. Enter file in which to save the key (/home/dshimizu/.ssh/id_ed25519): tidb-sandbox.pem Enter passphrase (empty for no passphrase): Enter same passphrase again: :
% vim topo-local.yml
# # Global variables are applied to all deployments and used as the default value of # # the deployments if a specific deployment value is missing. global: user: "tidb" ssh_port: 22 deploy_dir: "/tidb-deploy" data_dir: "/tidb-data" # # Monitored variables are applied to all the machines. monitored: node_exporter_port: 9100 blackbox_exporter_port: 9115 server_configs: tidb: instance.tidb_slow_log_threshold: 300 tikv: readpool.storage.use-unified-pool: false readpool.coprocessor.use-unified-pool: true pd: replication.enable-placement-rules: true replication.location-labels: ["host"] tiflash: logger.level: "info" pd_servers: - host: 127.0.0.1 tidb_servers: - host: 127.0.0.1 tikv_servers: - host: 127.0.0.1 port: 20160 status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 127.0.0.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } - host: 127.0.0.1 port: 20162 status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 127.0.0.1 monitoring_servers: - host: 127.0.0.1 grafana_servers: - host: 127.0.0.1
% tiup cluster deploy sandbox-tidb-cluster v8.1.0 ./topo-local.yml --user root -i tidb-sandbox.pem
+ Detect CPU Arch Name
- Detecting node 127.0.0.1 Arch info ... Done
+ Detect CPU OS Name
- Detecting node 127.0.0.1 OS info ... Done
Please confirm your topology:
Cluster type: tidb
Cluster name: sandbox-tidb-cluster
Cluster version: v8.1.0
Role Host Ports OS/Arch Directories
---- ---- ----- ------- -----------
pd 127.0.0.1 2379/2380 linux/x86_64 /tidb-deploy/pd-2379,/tidb-data/pd-2379
tikv 127.0.0.1 20160/20180 linux/x86_64 /tidb-deploy/tikv-20160,/tidb-data/tikv-20160
tikv 127.0.0.1 20161/20181 linux/x86_64 /tidb-deploy/tikv-20161,/tidb-data/tikv-20161
tikv 127.0.0.1 20162/20182 linux/x86_64 /tidb-deploy/tikv-20162,/tidb-data/tikv-20162
tidb 127.0.0.1 4000/10080 linux/x86_64 /tidb-deploy/tidb-4000
tiflash 127.0.0.1 9000/8123/3930/20170/20292/8234 linux/x86_64 /tidb-deploy/tiflash-9000,/tidb-data/tiflash-9000
prometheus 127.0.0.1 9090/12020 linux/x86_64 /tidb-deploy/prometheus-9090,/tidb-data/prometheus-9090
grafana 127.0.0.1 3000 linux/x86_64 /tidb-deploy/grafana-3000
Attention:
1. If the topology is not what you expected, check your yaml file.
2. Please confirm there is no port/directory conflicts in same host.
Do you want to continue? [y/N]: (default=N) y
+ Generate SSH keys ... Done
+ Download TiDB components
- Download pd:v8.1.0 (linux/amd64) ... Done
- Download tikv:v8.1.0 (linux/amd64) ... Done
- Download tidb:v8.1.0 (linux/amd64) ... Done
- Download tiflash:v8.1.0 (linux/amd64) ... Done
- Download prometheus:v8.1.0 (linux/amd64) ... Done
- Download grafana:v8.1.0 (linux/amd64) ... Done
- Download node_exporter: (linux/amd64) ... Done
- Download blackbox_exporter: (linux/amd64) ... Done
+ Initialize target host environments
- Prepare 127.0.0.1:22 ... Done
+ Deploy TiDB instance
- Copy pd -> 127.0.0.1 ... Done
- Copy tikv -> 127.0.0.1 ... Done
- Copy tikv -> 127.0.0.1 ... Done
- Copy tikv -> 127.0.0.1 ... Done
- Copy tidb -> 127.0.0.1 ... Done
- Copy tiflash -> 127.0.0.1 ... Done
- Copy prometheus -> 127.0.0.1 ... Done
- Copy grafana -> 127.0.0.1 ... Done
- Deploy node_exporter -> 127.0.0.1 ... Done
- Deploy blackbox_exporter -> 127.0.0.1 ... Done
+ Copy certificate to remote host
+ Init instance configs
- Generate config pd -> 127.0.0.1:2379 ... Done
- Generate config tikv -> 127.0.0.1:20160 ... Done
- Generate config tikv -> 127.0.0.1:20161 ... Done
- Generate config tikv -> 127.0.0.1:20162 ... Done
- Generate config tidb -> 127.0.0.1:4000 ... Done
- Generate config tiflash -> 127.0.0.1:9000 ... Done
- Generate config prometheus -> 127.0.0.1:9090 ... Done
- Generate config grafana -> 127.0.0.1:3000 ... Done
+ Init monitor configs
- Generate config node_exporter -> 127.0.0.1 ... Done
- Generate config blackbox_exporter -> 127.0.0.1 ... Done
Enabling component pd
Enabling instance 127.0.0.1:2379
Enable instance 127.0.0.1:2379 success
Enabling component tikv
Enabling instance 127.0.0.1:20162
Enabling instance 127.0.0.1:20160
Enabling instance 127.0.0.1:20161
Enable instance 127.0.0.1:20160 success
Enable instance 127.0.0.1:20162 success
Enable instance 127.0.0.1:20161 success
Enabling component tidb
Enabling instance 127.0.0.1:4000
Enable instance 127.0.0.1:4000 success
Enabling component tiflash
Enabling instance 127.0.0.1:9000
Enable instance 127.0.0.1:9000 success
Enabling component prometheus
Enabling instance 127.0.0.1:9090
Enable instance 127.0.0.1:9090 success
Enabling component grafana
Enabling instance 127.0.0.1:3000
Enable instance 127.0.0.1:3000 success
Enabling component node_exporter
Enabling instance 127.0.0.1
Enable 127.0.0.1 success
Enabling component blackbox_exporter
Enabling instance 127.0.0.1
Enable 127.0.0.1 success
Cluster `sandbox-tidb-cluster` deployed successfully, you can start it with command: `tiup cluster start sandbox-tidb-cluster --init`
% tiup cluster start sandbox-tidb-cluster --init
Starting cluster sandbox-tidb-cluster...
+ [ Serial ] - SSHKeySet: privateKey=/home/dshimizu/.tiup/storage/cluster/clusters/sandbox-tidb-cluster/ssh/id_rsa, publicKey=/home/dshimizu/.tiup/storage/cluster/clusters/sandbox-tidb-cluster/ssh/id_rsa.pub
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [Parallel] - UserSSH: user=tidb, host=127.0.0.1
+ [ Serial ] - StartCluster
Starting component pd
Starting instance 127.0.0.1:2379
Start instance 127.0.0.1:2379 success
Starting component tikv
Starting instance 127.0.0.1:20162
Starting instance 127.0.0.1:20160
Starting instance 127.0.0.1:20161
Start instance 127.0.0.1:20161 success
Start instance 127.0.0.1:20162 success
Start instance 127.0.0.1:20160 success
Starting component tidb
Starting instance 127.0.0.1:4000
Start instance 127.0.0.1:4000 success
Starting component tiflash
Starting instance 127.0.0.1:9000
Start instance 127.0.0.1:9000 success
Starting component prometheus
Starting instance 127.0.0.1:9090
Start instance 127.0.0.1:9090 success
Starting component grafana
Starting instance 127.0.0.1:3000
Start instance 127.0.0.1:3000 success
Starting component node_exporter
Starting instance 127.0.0.1
Start 127.0.0.1 success
Starting component blackbox_exporter
Starting instance 127.0.0.1
Start 127.0.0.1 success
+ [ Serial ] - UpdateTopology: cluster=sandbox-tidb-cluster
Started cluster `sandbox-tidb-cluster` successfully
The root password of TiDB database has been changed.
The new password is: '********'.
Copy and record it to somewhere safe, it is only displayed once, and will not be stored.
The generated password can NOT be get and shown again.
この時点で結構メモリを使っています。
% free
total used free shared buff/cache available
Mem: 8044380 7575696 126408 13060 600520 468684
Swap: 0 0 0
データベースへ接続します。パスワードは The new password is: '********'. の値になっているのでこれを入力します。
% sudo mysql -h 127.0.0.1 -P 4000 -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 2462056466 Server version: 8.0.11-TiDB-v8.1.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 8.0 compatible 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)]>
