shopxxb2b2c-Mysql安装脚本

1-上传installMysql.sh到服务器root目录

2-上传mysql初始化数据文件到服务器root目录

上传init.sql文件

3-运行命令

sh /root/installMysql.sh

installMysql.sh

#!/bin/bash -e

mysqlRootPaasword='Shopxx1234'
ecsUrl=$(curl ifconfig.co)

if [[ -z $ecsUrl ]];then
    echo "ECS URL is empty"
    exit 8
fi

sleep="30s"
yum install lsof -y
lsof -i :3306
if [ $? -eq 0 ]; then
   echo "3306 has been used"
   exit 8
fi

docker -v
if [ $? -eq  0 ]; then
    echo "docker has been installed"
else
    COUNTRY="CN"
    STATE="shanghai"
    CITY="shanghai"
    ORGANIZATION="shanghai"
    ORGANIZATIONAL_UNIT="Dev"
    EMAIL="service@shopxx.net"
    TIMEOUT=3

    ECSURL=$ecsUrl
    ECSPassword=Shopxx1234~

    yum update -y
    yum install -y yum-utils device-mapper-persistent-data lvm2
    yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
    yum install -y docker-ce
    systemctl start docker
    systemctl enable docker
    echo '{
      "registry-mirrors": [
        "https://reg-mirror.qiniu.com/",
        "http://hub-mirror.c.163.com",
        "https://docker.mirrors.ustc.edu.cn"
      ],
      "live-restore": true
    }' >> /etc/docker/daemon.json
    systemctl daemon-reload
    systemctl restart docker

    rm -rf /docker/ca
    mkdir -p /docker/ca
    cd /docker/ca
    openssl genrsa -aes256 -passout "pass:$ECSPassword"  -out ca-key.pem 2048
    openssl req -new -x509 -passin "pass:$ECSPassword" -days 3650 -key ca-key.pem -sha256 -out ca.pem -subj "/C=$COUNTRY/ST=$STATE/L=$CITY/O=$ORGANIZATION/OU=$ORGANIZATIONAL_UNIT/CN=$ECSURL/emailAddress=$EMAIL"
    openssl genrsa -out server-key.pem 2048
    openssl req -subj "/CN=$ECSURL" -new -key server-key.pem -out server.csr
    echo "subjectAltName=IP:${ECSURL},IP:0.0.0.0" >> extfile.cnf
    echo "extendedKeyUsage=serverAuth" >> extfile.cnf
    openssl x509 -req -days 3650 -in server.csr -CA ca.pem -CAkey ca-key.pem -passin "pass:$ECSPassword" -CAcreateserial  -out server-cert.pem -extfile extfile.cnf
    openssl genrsa -out key.pem 2048
    openssl req -subj '/CN=client' -new -key key.pem -out client.csr
    sh -c 'echo "extendedKeyUsage=clientAuth" > extfile.cnf'
    openssl x509 -req -days 3650 -in client.csr -CA ca.pem -CAkey ca-key.pem  -passin "pass:$ECSPassword" -CAcreateserial -out cert.pem  -extfile extfile.cnf
    chmod 0400 ca-key.pem key.pem server-key.pem
    chmod 0444 ca.pem server-cert.pem cert.pem
    rm -v client.csr server.csr
    sed -i "s|\(ExecStart=/usr/bin/dockerd\).*\(-H fd:// --containerd=/run/containerd/containerd.sock\)|\1 --tlsverify --tlscacert=/docker/ca/ca.pem --tlscert=/docker/ca/server-cert.pem --tlskey=/docker/ca/server-key.pem -H tcp://0.0.0.0:2375 -H unix:///var/run/docker.sock \2|" /usr/lib/systemd/system/docker.service
    sed -i "s|\(ExecStart=/usr/bin/dockerd-current\).*\(\\)|\1 --tlsverify --tlscacert=/docker/ca/ca.pem --tlscert=/docker/ca/server-cert.pem --tlskey=/docker/ca/server-key.pem -H tcp://0.0.0.0:2375 -H unix:///var/run/docker.sock \2|" /usr/lib/systemd/system/docker.service
    ln -s /usr/libexec/docker/docker-runc-current /usr/bin/docker-runc
    systemctl daemon-reload
    systemctl restart docker.service
fi

MYSQL_CONTAINER_NAME="shopxx-b2b2c-mysql"
DATABASE="shopxxb2b2c"

docker inspect $MYSQL_CONTAINER_NAME -f '{{.Name}}' > /dev/null
if [ $? -eq 0 ] ;then
    docker start $MYSQL_CONTAINER_NAME
    echo "$MYSQL_CONTAINER_NAME container exist"
    exit 0
fi

docker run \
-p 3306:3306 \
--name $MYSQL_CONTAINER_NAME \
-v /data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=$mysqlRootPaasword \
-d mysql:8.0.27 \
--lower_case_table_names=1 \

echo "mysqlRootPaasword:$mysqlRootPaasword"
sleep $sleep

INIT_SQL_PATH="/root/init.sql"

if [ -f $INIT_SQL_PATH ]; then

docker cp $INIT_SQL_PATH $MYSQL_CONTAINER_NAME:/tmp/
docker exec -i $MYSQL_CONTAINER_NAME bash << EOF
mysql -uroot -p$mysqlRootPaasword
CREATE DATABASE $DATABASE DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE $DATABASE;
source /tmp/init.sql
EOF
rm -rf $INIT_SQL_PATH

fi

echo "Database installation is complete!"

cd /
rm $0