my.cnf

步骤

yum install -y mariadb-server mariadb mariadb-libs
mkdir -p /data/mysql/{data,tmp,logs,binlog} 
chown -R mysql.mysql /data/mysql/

vi /etc/my.cnf

[mysql]
socket=/data/mysql/mysql.sock

[mysqld]
datadir=/data/mysql/data
socket=/data/mysql/mysql.sock
tmpdir=/data/mysql/tmp

log-bin=/data/mysql/binlog/mysql-bin
max_binlog_size=40960000
binlog_format=MIXED
expire_logs_days=7

max_allowed_packet=500M
max_connections=1000

log-error=/data/mysql/logs/error.log
pid-file=/data/mysql/mysql.pid