Single-Machine boot TIDB

Deployment directory:

TREE-FL 3

.|--pd/|   |--bin/|   |   |--pd-ctl*|   |   |--pd-recover*|   |   |--pd-server*|   |   '--pd-tso-bench*| `--default. pd/| '--member/|--Readme|--tidb/|       '--bin/|       |--goyacc*|   '--tidb-server*|--tikv1/|   |--bin/|   |   |--bench-tikv*|   |   |--build/|   |   |--deps/|   |   |--examples/|   |   |--incremental/|   | |--Libtikv.rlib|   |   |--native/|   |   |--raft/|   |   |--tikv-ctl*|   |   |--tikv-fail*|   |   '--tikv-server*|   |--db/|   | |--LOCK|   |   |--backup/|   |   |--db/|   |   |--raft/|   |   '--snap/|   '--raft/|--tikv2/|   |--bin/|   |   |--bench-tikv*|   |   |--build/|   |   |--deps/|   |   |--examples/|   |   |--incremental/|   | |--Libtikv.rlib|   |   |--native/|   |   |--raft/|   |   |--tikv-ctl*|   |   |--tikv-fail*|   |   '--tikv-server*|   |--db/|   | |--LOCK|   |   |--backup/|   |   |--db/|   |   |--raft/|   |   '--snap/| '--raft/`--tikv3/|--bin/|   |--bench-tikv* |   |--build/|   |--deps/|   |--examples/|   |--incremental/| |--Libtikv.rlib|   |--native/|   |--raft/|   |--tikv-ctl* |   |--tikv-fail* |   '--tikv-server* |--db/| |--LOCK|   |--backup/|   |--db/|   |--raft/| '--snap/    `--raft/

• (repaired with root) change the maximum number of open files:

echo ' Fs.file-max = 82920 ' >>/etc/sysctl.conf
Echo ' *-nofile 82920 ' >>/etc/security/limits.conf
Sysctl-p
Log back in to a terminal session

• Start PD

Pd/bin/pd-server

• Start TIKV

Enter Tikv[1-3]/bin execution:

Tikv-server-a 127.0.0.1:9000-s. /db--pd-endpoints 127.0.0.1:2379

Tikv-server-a 127.0.0.1:9001-s. /db--pd-endpoints 127.0.0.1:2379

Tikv-server-a 127.0.0.1:9002-s. /db--pd-endpoints 127.0.0.1:2379

• Start TIDB

Tidb/bin/bin/tidb-server-store Tikv-path ' 127.0.0.1:2379/pd?cluster=1 '-P 3306

• Connect with MySQL Client

mysql-uroot-h127.0.0.1

Welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connection ID is 1Server Version:5.7.1-tidb-v1.1.0-alpha-424-gcc808a5 MySQL Community Server (Apache License2.0) Copyright (c) -, -, Oracle and/or its affiliates. All rights reserved. Oracle isA registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h'  forHelp. Type'\c'To clear the current input statement.mysql>show databases;+--------------------+| Database |+--------------------+| Information_schema | | Performance_schema | | MySQL | | Test |+--------------------+4Rowsinch Set(0.01Sec

Single-Machine boot TIDB