【免责声明】本号文章仅代表个人观点，与任何公司无关。
来源公众号|SQL和数据库技术(ID:SQLplusDB)
Windows 环境通过Virtual Box快速体验TiDB 5.0
- 安装虚拟机Virtual Box
- 安装Oracle Linux 7
- 配置虚拟机联网
- 通过TiUP Playground搭建基础测试集群
- 执行例
- 通过yum安装mysql 或者客户端
安装虚拟机Virtual Box
通过官网下载Virtual Box并安装。
https://www.virtualbox.org/wiki/Downloads
安装Oracle Linux 7
可以通过如下网址下载Oracle Linux 7。
代码语言：javascript复制下载Oracle Linux 7
https://www.oracle.com/linux/
文档：
https://docs.oracle.com/en/operating-systems/oracle-linux/7/
https://docs.oracle.com/en/operating-systems/oracle-linux/7/install/配置虚拟机联网
使用桥接网卡的方式使虚拟机Virtual Box联网
1.配置虚拟机网络设置
2. 根据本机的IP设置虚拟机的Linux的IP
代码语言：javascript复制C:UsersAdministrator>ipconfig无线局域网适配器 WLAN:
连接特定的 DNS 后缀 . . . . . . . :
本地链接 IPv6 地址. . . . . . . . : ff80::aa11:2470:41e8:8a50
IPv4 地址 . . . . . . . . . . . . : 192.168.31.16 **
子网掩码 . . . . . . . . . . . . : 255.255.255.0
默认网关. . . . . . . . . . . . . : 192.168.31.1 **修改网络配置ifcfg-enp0s3
代码语言：javascript复制[root@db12201 ~]# nmcli connection show
名前 UUID タイプ デバイス
enp0s3 4924bacd-1a6b-412c-9392-29ad24b5fcaa 802-3-ethernet enp0s3
virbr0 c04be18e-add6-4fd2-ac25-47f45f936a4f bridge virbr0
[root@db12201 ~]# cd /etc/sysconfig/network-scripts/
[root@db12201 network-scripts]# ls
ifcfg-enp0s3 ...[root@db12201 network-scripts]# vi ifcfg-enp0s3
TYPE="Ethernet"
BOOTPROTO=dhcp ***
DEFROUTE="yes"
IPV4_FAILURE_FATAL="no"
IPV6INIT="no"
IPV6_AUTOCONF="yes"
IPV6_DEFROUTE="yes"
IPV6_PEERDNS="yes"
IPV6_PEERROUTES="yes"
IPV6_FAILURE_FATAL="no"
IPV6_ADDR_GEN_MODE="stable-privacy"
NAME="enp0s3"
UUID="4924bacd-1a6b-412c-9392-29ad24b5fcaa"
DEVICE="enp0s3"
ONBOOT="yes"
IPADDR="192.168.31.221" ***
PREFIX="24"
GATEWAY="192.168.31.1" ***
DNS1=19.168.31.1 ***重启网络
代码语言：javascript复制$ service network restart测试连接外网成功
代码语言：javascript复制[root@db12201 ~]# ping www.baidu.com
PING www.a.shifen.com (110.242.68.4) 56(84) bytes of data.
64 bytes from 110.242.68.4 (110.242.68.4): icmp_seq=1 ttl=53 time=20.3 ms
64 bytes from 110.242.68.4 (110.242.68.4): icmp_seq=2 ttl=53 time=23.5 ms
64 bytes from 110.242.68.4 (110.242.68.4): icmp_seq=3 ttl=53 time=24.6 ms
64 bytes from 110.242.68.4 (110.242.68.4): icmp_seq=4 ttl=53 time=27.3 ms
64 bytes from 110.242.68.4 (110.242.68.4): icmp_seq=5 ttl=53 time=20.5 ms
^C
--- www.a.shifen.com ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4006ms
rtt min/avg/max/mdev = 20.356/23.285/27.326/2.612 ms通过TiUP Playground搭建基础测试集群
1.下载并安装 TiUP。
代码语言：javascript复制# curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh2. 声明全局环境变量。
代码语言：javascript复制# source .bash_profile3. 当前会话启动集群
代码语言：javascript复制# tiup playground4. 新开会话访问 TiDB 数据库
代码语言：javascript复制tiup client
或者
mysql --host 127.0.0.1 --port 4000 -u root执行例
代码语言：javascript复制[root@db12201 ~]# curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 6064k 100 6064k 0 0 3727k 0 0:00:01 0:00:01 --:--:-- 3727k
WARN: adding root certificate via internet: https://tiup-mirrors.pingcap.com/roo t.json
You can revoke this by remove /root/.tiup/bin/7b8e153f2e2d0928.root.json
Successfully set mirror to https://tiup-mirrors.pingcap.com
Detected shell: bash
Shell profile: /root/.bash_profile
/root/.bash_profile has been modified to add tiup to PATH
open a new terminal or source /root/.bash_profile to use it
Installed path: /root/.tiup/bin/tiup
===============================================
Have a try: tiup playground
===============================================
[root@db12201 ~]# cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export PATH=/root/.tiup/bin:$PATH
[root@db12201 ~]# source .bash_profile
[root@db12201 ~]# tiup playground
The component `playground` version is not installed; downloading from repository.
download https://tiup-mirrors.pingcap.com/playground-v1.7.0-linux-amd64.tar.gz 6.46 MiB / 6.46 MiB 100.00% 7.17 MiB/s
Starting component `playground`: /root/.tiup/components/playground/v1.7.0/tiup-playground
Using the version v5.2.2 for version constraint "".
If you'd like to use a TiDB version other than v5.2.2, cancel and retry with the following arguments:
Specify version manually: tiup playground <version>
Specify version range: tiup playground ^5
The nightly version: tiup playground nightly
Playground Bootstrapping...
The component `prometheus` version v5.2.2 is not installed; downloading from repository.
download https://tiup-mirrors.pingcap.com/prometheus-v5.2.2-linux-amd64.tar.gz 39.84 MiB / 39.84 MiB 100.00% 5.41 MiB/s
download https://tiup-mirrors.pingcap.com/grafana-v5.2.2-linux-amd64.tar.gz 50.00 MiB / 50.00 MiB 100.00% 3.66 MiB/s
Start pd instance
The component `pd` version v5.2.2 is not installed; downloading from repository.
download https://tiup-mirrors.pingcap.com/pd-v5.2.2-linux-amd64.tar.gz 40.10 MiB / 40.10 MiB 100.00% 4.62 MiB/s
Start tikv instance
The component `tikv` version v5.2.2 is not installed; downloading from repository.
download https://tiup-mirrors.pingcap.com/tikv-v5.2.2-linux-amd64.tar.gz 165.15 MiB / 165.15 MiB 100.00% 7.82 MiB/s
Start tidb instance
The component `tidb` version v5.2.2 is not installed; downloading from repository.
download https://tiup-mirrors.pingcap.com/tidb-v5.2.2-linux-amd64.tar.gz 45.55 MiB / 45.55 MiB 100.00% 9.42 MiB/s
Waiting for tidb instances ready
127.0.0.1:4000 ... Done
Start tiflash instance
The component `tiflash` version v5.2.2 is not installed; downloading from repository.
download https://tiup-mirrors.pingcap.com/tiflash-v5.2.2-linux-amd64.tar.gz 401.44 MiB / 401.44 MiB 100.00% 1.86 MiB/s
failed to download /tiflash-v5.2.2-linux-amd64.tar.gz(download from https://tiup-mirrors.pingcap.com/tiflash-v5.2.2-linux-amd64.tar.gz failed: stream error: stream ID 1; INTERNAL_ERROR; received from peer), retrying...
download https://tiup-mirrors.pingcap.com/tiflash-v5.2.2-linux-amd64.tar.gz 401.44 MiB / 401.44 MiB 100.00% 137.28 MiB/s
Waiting for tiflash instances ready
127.0.0.1:3930 ... Done
CLUSTER START SUCCESSFULLY, Enjoy it ^-^
To connect TiDB: mysql --comments --host 127.0.0.1 --port 4000 -u root -p (no password)
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参考：
代码语言：javascript复制https://docs.pingcap.com/zh/tidb/stable/quick-start-with-tidb#Linux
TiDB 数据库快速上手指南通过yum安装mysql 或者客户端
代码语言：javascript复制# yum list installed mysql*
# yum list | grep mysql
# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
# rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum install mysql-server
# service mysqld start
# ssystemctl status mysqld.service参考：
centos7下yum安装mysql
https://blog.csdn.net/wz1226864411/article/details/76146180
https://www.cnblogs.com/brianzhu/p/8575243.html
