Skip to content

Latest commit

 

History

History
468 lines (311 loc) · 15.4 KB

quick-start-with-tidb.md

File metadata and controls

468 lines (311 loc) · 15.4 KB
Raw
title summary aliases
Quick Start Guide for the TiDB Database Platform
Learn how to quickly get started with the TiDB platform and see if TiDB is the right choice for you.
/docs/dev/quick-start-with-tidb/
/docs/dev/test-deployment-using-docker/

Quick Start Guide for the TiDB Database Platform

This guide walks you through the quickest way to get started with TiDB. You will be using TiUP, a package manager in the TiDB ecosystem, to help you run any TiDB cluster component with only a single line of command.

Note:

The deployment method provided in this guide is ONLY FOR quick start, NOT FOR production.

Deploy a local test environment on Mac OS

As a distributed system, a basic TiDB test cluster usually consists of 2 TiDB instances, 3 TiKV instances, 3 PD instances, and optional TiFlash instances. With TiUP Playground, you can quickly build the test cluster by taking the following steps:

  1. Download and install TiUP:

    {{< copyable "shell-regular" >}}

    curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

  2. Declare the global environment variable:

    Note:

    After the installation, TiUP displays the absolute path of the corresponding profile file. You need to modify the following source command according to the path.

    {{< copyable "shell-regular" >}}

    source .bash_profile

  3. Start the cluster in the current session:

    • If you want to start a TiDB cluster of the latest version with 1 TiDB instance, 1 TiKV instance, 1 PD instance, and 1 TiFlash instance, run the following command:

      {{< copyable "shell-regular" >}}

      tiup playground

    • If you want to specify the TiDB version and the number of the instances of each component, run a command like this:

      {{< copyable "shell-regular" >}}

      tiup playground v5.2.2 --db 2 --pd 3 --kv 3 --monitor

      The command downloads a version cluster to the local machine and starts it, such as v5.2.2. --monitor means that the monitoring component is also deployed.

      To view the latest version, run tiup list tidb.

      This command returns the access methods of the cluster:

      CLUSTER START SUCCESSFULLY, Enjoy it ^-^
To connect TiDB: mysql --host 127.0.0.1 --port 4000 -u root
To connect TiDB: mysql --host 127.0.0.1 --port 4001 -u root
To view the dashboard: http://127.0.0.1:2379/dashboard
To view the monitor: http://127.0.0.1:9090

      Note:

      • Since v5.2.0, TiDB supports running tiup playground on the machine that uses the Apple M1 chip.
      • For the playground operated in this way, after the test deployment is finished, TiUP will clean up the original cluster data. You will get a new cluster after re-running the command.
      • If you want the data to be persisted on storage，run tiup --tag <your-tag> playground .... For details, refer to TiUP Reference Guide.

  4. Start a new session to access TiDB:

    • Use the TiUP client to connect to TiDB.

      {{< copyable "shell-regular" >}}

      tiup client

    • You can also use the MySQL client to connect to TiDB.

      {{< copyable "shell-regular" >}}

      mysql --host 127.0.0.1 --port 4000 -u root

  5. Access the Prometheus dashboard of TiDB at http://127.0.0.1:9090.

  6. Access the TiDB Dashboard at http://127.0.0.1:2379/dashboard. The default username is root, with an empty password.

  7. (Optional) Load data to TiFlash for analysis.

  8. Clean up the cluster after the test deployment:

    1. Stop the process by pressing ctrl-c.

    2. Run the following command:

      {{< copyable "shell-regular" >}}

      tiup clean --all

Note:

TiUP Playground listens on 127.0.0.1 by default, and the service is only locally accessible. If you want the service to be externally accessible, specify the listening address using the --host parameter to bind the network interface card (NIC) to an externally accessible IP address.

Deploy a local test environment on Linux OS

As a distributed system, a basic TiDB test cluster usually consists of 2 TiDB instances, 3 TiKV instances, 3 PD instances, and optional TiFlash instances. With TiUP Playground, you can quickly build the test cluster by taking the following steps:

  1. Download and install TiUP:

    {{< copyable "shell-regular" >}}

    curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

  2. Declare the global environment variable:

    Note:

    After the installation, TiUP displays the absolute path of the corresponding profile file. You need to modify the following source command according to the path.

    {{< copyable "shell-regular" >}}

    source .bash_profile

  3. Start the cluster in the current session:

    • If you want to start a TiDB cluster of the latest version with 1 TiDB instance, 1 TiKV instance, 1 PD instance, and 1 TiFlash instance, run the following command:

      {{< copyable "shell-regular" >}}

      tiup playground

    • If you want to specify the TiDB version and the number of the instances of each component, run a command like this:

      {{< copyable "shell-regular" >}}

      tiup playground v5.2.2 --db 2 --pd 3 --kv 3 --monitor

      The command downloads a version cluster to the local machine and starts it, such as v5.2.2. --monitor means that the monitoring component is also deployed.

      To view the latest version, run tiup list tidb.

      This command returns the access methods of the cluster:

      CLUSTER START SUCCESSFULLY, Enjoy it ^-^
To connect TiDB: mysql --host 127.0.0.1 --port 4000 -u root -p (no password) --comments
To view the dashboard: http://127.0.0.1:2379/dashboard
PD client endpoints: [127.0.0.1:2379]
To view the Prometheus: http://127.0.0.1:9090
To view the Grafana: http://127.0.0.1:3000

      Note:

      For the playground operated in this way, after the test deployment is finished, TiUP will clean up the original cluster data. You will get a new cluster after re-running the command. If you want the data to be persisted on storage，run tiup --tag <your-tag> playground .... For details, refer to TiUP Reference Guide.

  4. Start a new session to access TiDB:

    • Use the TiUP client to connect to TiDB.

      {{< copyable "shell-regular" >}}

      tiup client

    • You can also use the MySQL client to connect to TiDB.

      {{< copyable "shell-regular" >}}

      mysql --host 127.0.0.1 --port 4000 -u root

  5. Access the Prometheus dashboard of TiDB at http://127.0.0.1:9090.

  6. Access the TiDB Dashboard at http://127.0.0.1:2379/dashboard. The default username is root, with an empty password.

  7. Access the Grafana dashboard of TiDB through http://127.0.0.1:3000. Both the default username and password are admin.

  8. (Optional) Load data to TiFlash for analysis.

  9. Clean up the cluster after the test deployment:

    1. Stop the process by pressing ctrl-c.

    2. Run the following command:

      {{< copyable "shell-regular" >}}

      tiup clean --all

Note:

TiUP Playground listens on 127.0.0.1 by default, and the service is only locally accessible. If you want the service to be externally accessible, specify the listening address using the --host parameter to bind the network interface card (NIC) to an externally accessible IP address.

Set up a test environment on a single machine using TiUP cluster

  • Scenario: Experience a smallest TiDB cluster with the complete topology and simulate the production deployment steps on a single Linux server.
  • Time required: 10 minutes

This section describes how to deploy a TiDB cluster using a YAML file of the smallest topology in TiUP.

Prepare

Prepare a target machine that meets the following requirements:

  • CentOS 7.3 or a later version is installed
  • The Linux OS has access to the Internet, which is required to download TiDB and related software installation packages

The smallest TiDB cluster topology is as follows:

Note:

The IP address of the following instances only serves as an example IP. In your actual deployment, you need to replace the IP with your actual IP.

Instance Count IP Configuration
TiKV 3 10.0.1.1
10.0.1.1
10.0.1.1		 Avoid conflict between the port and the directory
TiDB 1 10.0.1.1 The default port
Global directory configuration
PD 1 10.0.1.1 The default port
Global directory configuration
TiFlash 1 10.0.1.1 The default port
Global directory configuration
Monitor 1 10.0.1.1 The default port
Global directory configuration

Other requirements for the target machine:

  • The root user and its password is required

  • Stop the firewall service of the target machine, or open the port needed by the TiDB cluster nodes

  • Currently, TiUP supports deploying TiDB on the x86_64 (AMD64 and ARM) architectures:

    • It is recommended to use CentOS 7.3 or later versions on AMD64
    • It is recommended to use CentOS 7.6 1810 on ARM

Deploy

Note:

You can log in to the target machine as a regular user or the root user. The following steps use the root user as an example.

  1. Download and install TiUP:

    {{< copyable "shell-regular" >}}

    curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

  2. Install the cluster component of TiUP:

    {{< copyable "shell-regular" >}}

    tiup cluster

  3. If the TiUP cluster is already installed on the machine, update the software version:

    {{< copyable "shell-regular" >}}

    tiup update --self && tiup update cluster

  4. Use the root user privilege to increase the connection limit of the sshd service. This is because TiUP needs to simulate deployment on multiple machines.

    1. Modify /etc/ssh/sshd_config, and set MaxSessions to 20.

    2. Restart the sshd service:

      {{< copyable "shell-regular" >}}

      service sshd restart

  5. Create and start the cluster:

    Edit the configuration file according to the following template, and name it as topo.yaml:

    {{< copyable "shell-regular" >}}

    # # 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:
   log.slow-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: 10.0.1.1

tidb_servers:
 - host: 10.0.1.1

tikv_servers:
 - host: 10.0.1.1
   port: 20160
   status_port: 20180
   config:
     server.labels: { host: "logic-host-1" }

 - host: 10.0.1.1
   port: 20161
   status_port: 20181
   config:
     server.labels: { host: "logic-host-2" }

 - host: 10.0.1.1
   port: 20162
   status_port: 20182
   config:
     server.labels: { host: "logic-host-3" }

tiflash_servers:
 - host: 10.0.1.1

monitoring_servers:
 - host: 10.0.1.1

grafana_servers:
 - host: 10.0.1.1
    • user: "tidb": Use the tidb system user (automatically created during deployment) to perform the internal management of the cluster. By default, use port 22 to log in to the target machine via SSH.
    • replication.enable-placement-rules: This PD parameter is set to ensure that TiFlash runs normally.
    • host: The IP of the target machine.

  6. Execute the cluster deployment command:

    {{< copyable "shell-regular" >}}

    tiup cluster deploy <cluster-name> <tidb-version> ./topo.yaml --user root -p
    • <cluster-name>: Set the cluster name
    • <tidb-version>: Set the TiDB cluster version. You can see all the supported TiDB versions by running the tiup list tidb command

    Enter "y" and the root user's password to complete the deployment:

    Do you want to continue? [y/N]:  y
Input SSH password:

  7. Start the cluster:

    {{< copyable "shell-regular" >}}

    tiup cluster start <cluster-name>

  8. Access the cluster:

    • Install the MySQL client. If it is already installed, skip this step.

      {{< copyable "shell-regular" >}}

      yum -y install mysql

    • Access TiDB. The password is empty:

      {{< copyable "shell-regular" >}}

      mysql -h 10.0.1.1 -P 4000 -u root

    • Access the Grafana monitoring dashboard at http://{grafana-ip}:3000. The default username and password are both admin.

    • Access the TiDB Dashboard at http://{pd-ip}:2379/dashboard. The default username is root, and the password is empty.

    • To view the currently deployed cluster list:

      {{< copyable "shell-regular" >}}

      tiup cluster list

    • To view the cluster topology and status:

      {{< copyable "shell-regular" >}}

      tiup cluster display <cluster-name>

What's next

Note:

By default, TiDB, TiUP and TiDB Dashboard share usage details with PingCAP to help understand how to improve the product. For details about what is shared and how to disable the sharing, see Telemetry.