https://hub.docker.com/r/vitess/vttestserver
https://github.com/vitessio/vitess/releases
https://github.com/planetscale/vitess-releases
# docker
cd /opt
git clone https://github.com/vitessio/vitess.git
cd vitess
make docker_vttestserver
docker pull vitess/vttestserver:mysql57
docker pull vitess/vttestserver:mysql80
docker run -itd --name=vitess1 --restart=always -p 33571:33577 -p 81:33574 --privileged=true --pid=host -e PORT=33574 -e PLANNER_VERSION=gen4fallback -e KEYSPACES=test,unsharded -e NUM_SHARDS=2,1 -e MYSQL_MAX_CONNECTIONS=70000 -e MYSQL_BIND_HOST=0.0.0.0 -v /etc/localtime:/etc/localtime:ro vitess/vttestserver:mysql57
docker run -itd --name=vitess2 --restart=always -p 33572:33577 -p 82:33574 --privileged=true --pid=host -e PORT=33574 -e PLANNER_VERSION=gen4fallback -e KEYSPACES=test,unsharded -e NUM_SHARDS=2,1 -e MYSQL_MAX_CONNECTIONS=70000 -e MYSQL_BIND_HOST=0.0.0.0 -v /etc/localtime:/etc/localtime:ro vitess/vttestserver:mysql57
docker run -itd --name=vitess3 --restart=always -p 33573:33577 -p 83:33574 --privileged=true --pid=host -e PORT=33574 -e PLANNER_VERSION=gen4fallback -e KEYSPACES=test,unsharded -e NUM_SHARDS=2,1 -e MYSQL_MAX_CONNECTIONS=70000 -e MYSQL_BIND_HOST=0.0.0.0 -v /etc/localtime:/etc/localtime:ro vitess/vttestserver:mysql57
-v /data/docker/mysql/vitess/vt:/vt -v /data/docker/mysql/vitess/5.7.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf:ro -v /var/lib/mysql:/data/db/vitess/0 -v /data/file/logs/vitess:/var/log/mysql/
--health-cmd="mysqladmin ping -h127.0.0.1 -P33577" --health-interval=5s --health-timeout=2s --health-retries=5
-p 33577:33577
-mysqld: 33576
docker exec -it vitess1 /bin/bash
docker exec -it vitess2 /bin/bash
docker exec -it vitess3 /bin/bash
-connect:
mysql --host 127.0.0.1 --port 33571 --user "root"
mysql --host 127.0.0.1 --port 33572 --user "root"
mysql --host 127.0.0.1 --port 33573 --user "root"
-Control Panel
http://b.htmltoo.com:81/
-连接到集群：
mysql -h 127.0.0.1 -P 15306
/data/docker/mysql/vitess/5.7.cnf
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/log/mysql/error.log
# By default we only accept connections from localhost
bind-address = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#
skip-host-cache
skip-name-resolve
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 10
default-storage-engine = innodb
explicit_defaults_for_timestamp = true
#server-id = 1
max_allowed_packet = 800M
log-bin=mysql-bin
binlog_format=mixed
expire_logs_days = 5
max_binlog_size = 800M
# 本地安装
version=15.0.0
file=vitess-${version}-e8c7e27.tar.gz
wget https://github.com/vitessio/vitess/releases/download/v${version}/${file}
tar -xzf ${file}
cd ${file/.tar.gz/}
mkdir -p /usr/local/vitess
cp -r * /usr/local/vitess/
export PATH=/usr/local/vitess/bin:${PATH}
echo $PATH
---Start a Single Keyspace Cluster
cp -r /usr/local/vitess/examples/local /opt/vitess
cd /opt/vitess
sudo -u admin ./101_initial_cluster.sh
---删除
rm -rf /usr/local/vitess/ /opt/vitess /opt/${file/.tar.gz/} /opt/${file}.tar.gz
vtorc is running!
- UI: http://localhost:16000
vtadmin-api is running!
- API: http://localhost:14200
vtadmin-web is running!
- Browser: http://localhost:14201
---使用pgrep验证进程是否已经启动
pgrep -fl vitess
---您可以终止进程并重新开始
pkill -9 -f '(vtdataroot|VTDATAROOT|vitess|vtadmin)' # kill Vitess processes
rm -rf vtdataroot
---设置别名
source ./env.sh
---连接
mysql
show tables;
---vtctld console
http://localhost:15000
---VTOrc:
http://localhost:16000
---删除
./401_teardown.sh
rm -rf vtdataroot
https://blog.csdn.net/jimo_lonely/article/details/121726463
