mysql分库分表备份脚本
#!/bin/bash USERNAME=root PASSWD='rewrfefsadSa56' PORT=30306 HOST=$1 MYSQLCMD="mysql -h $HOST -P$PORT -u$USERNAME -p$PASSWD" DB_DUMP="mysqldump -h $H
#!/bin/bash USERNAME=root PASSWD='rewrfefsadSa56' PORT=30306 HOST=$1 MYSQLCMD="mysql -h $HOST -P$PORT -u$USERNAME -p$PASSWD" DB_DUMP="mysqldump -h $H
架构 授予以普通执行命令,每台执行 1、groupadd docker 2、将用户加入docker组 gpasswd -a mysql docker 3、重启docker(脚本已经创建组,这里不需要重启) systemctl restart docker 修改主机名,注意主机名要不一样与上面对应 n
修改服务器主机名并写入/etc/host,每台执行,如果有多台依次往后加 hostnamectl set-hostname s1 hostnamectl set-hostname s2 hostnamectl set-hostname s3 echo'192.168.2.233 s1 192.16
创建目录和授权 mkdir /data/mysql/{data,conf} -p cd /data chown -R 999.999 mysql compose配置 services: openresty: image: mysql:8.0.40 container_name: