mysql批量自动化部署

#!/bin/bash

# 安装MySQL
sudo apt-get update
sudo apt-get install -y mysql-server

# 配置MySQL
sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
sudo sed -i 's/innodb_buffer_pool_size = 128M/innodb_buffer_pool_size = 256M/' /etc/mysql/my.cnf

# 启动MySQL
sudo systemctl start mysql
sudo systemctl enable mysql

#!/bin/bash

# 安装MySQL
sudo apt-get update
sudo apt install -y mysql-server

# 配置第一个实例
sudo mkdir -p /var/lib/mysql1
sudo cp /etc/mysql/my.cnf /etc/mysql/my1.cnf
sudo sed -i 's/datadir = \/var\/lib\/mysql/datadir = \/var\/lib\/mysql1/' /etc/mysql/my1.cnf
sudo sed -i 's/port = 3306/port = 3307/' /etc/mysql/my1.cnf
sudo mysqld --initialize-insecure --user=mysql --datadir=/var/lib/mysql1 --port=3307
sudo systemctl start mysql@my1
sudo systemctl enable mysql@my1

# 配置第二个实例
sudo mkdir -p /var/lib/mysql2
sudo cp /etc/mysql/my.cnf /etc/mysql/my2.cnf
sudo sed -i 's/datadir = \/var\/lib\/mysql/datadir = \/var\/lib\/mysql2/' /etc/mysql/my2.cnf
sudo sed -i 's/port = 3306/port = 3308/' /etc/mysql/my2.cnf
sudo mysqld --initialize-insecure --user=mysql --datadir=/var/lib/mysql2 --port=3308
sudo systemctl start mysql@my2
sudo systemctl enable mysql@my2