初始化小于等于2 TiB数据盘(Linux)_云服务器 ECS-阿里云帮助中心
先挂好磁盘 分好区
1.环境准备 一台centos7.9系统主机
2.mysql-8.0.25-1.el7.x86_64.rpm-bundle.tar
开始安装:
1. 查询mariadb 并卸载 查询Mysql并删除 解压tar包
rpm -qa|grep mariadb rpm -e --nodeps 查询出来的包 rpm -pa | grep mysql find / -name mysql rm -rf 查出来的mysql目录 yum -y install mysql-community-*
2. 打开 /etc/my.cnf 编辑以下信息
[mysqld] user = mysql pid-file = /data/mysql_data/mysql/mysqld.pid datadir = /data/mysql_data/mysql socket=/data/mysql_data/mysql/mysql.sock log-error=/data/mysql_data/mysql/mysqld.log max_connections=5000 max_connect_errors=100 default-storage-engine=INNODB bind-address=0.0.0.0 server_id=10 log_bin=mysql-bin binlog_format=ROW sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION mysqlx-bind-address = 0.0.0.0 table_open_cache = 65535 open_files_limit = 65535 key_buffer_size = 16M myisam-recover-options = BACKUP max_binlog_size = 100M
3.创建好数据目录
mkdir -p /data/mysql_data/mysql systemctl daemon-reload systemctl enable mysqld --now netstat -nutlp | grep :3306 cat /data/mysql_data/mysql/mysqld.log | grep localhost ln -sv /data/mysql_data/mysql/mysql.sock /var/lib/mysql/mysql.sock mysql -uroot -p ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'; flush privileges; update mysql.user set host='%' where user='root'; flush privileges; set global binlog_expire_logs_seconds=259200; flush logs; show variables like '%expire%';