mysql部署
安装前准备
创建用户和目录
创建用户:
groupadd mysql
useradd -g mysql mysql
创建目录
mkdir /data/mysql
mkdir /log/mysql
添加环境变量
vim /etc/profile
内容如下:
export MYSQL_HOME=/opt/mysql
export PATH=$PATH:$MYSQL_HOME/bin
source /etc/profile
安装mysql依赖包
删除其他数据库
rpm -qa|grep mariadb
rpm -e mariadb-libs --nodeps
安装依赖
yum -y install numactl libaio
安装mysql
解压mysql安装包
tar -zxf mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz -C /opt/
创建软链接
ln -s /opt/mysql-5.7.44-linux-glibc2.12-x86_64 /opt/mysql
配置my.cnf
vi /etc/my.cnf
[client]
socket=/opt/mysql/mysql.sock
[mysql]
socket=/opt/mysql/mysql.sock
[mysqld]
log_error=/log/mysql/err.log
port = 3306
socket=/opt/mysql/mysql.sock
basedir=/opt/mysql
datadir=/data/mysql
server-id = 1
auto_increment_offset = 1
auto_increment_increment = 2
log-bin = mysql-bin
binlog-format=ROW
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=0
sync_binlog=0
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
expire_logs_days=7
max_binlog_size=1024M
修改权限
chown -R mysql:mysql /opt/mysql/
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /log/mysql
启动mysql
1. 设置开机自启:
cp -a /opt/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
2. 初始化:
su - mysql
cd /opt/mysql/bin
./mysqld --initialize --user=mysql --basedir=/data/mysql
3. 启动:
su - mysql
chmod +x /etc/rc.d/init.d/mysqld
/etc/init.d/mysqld start