数据库的主从复制配置(在一个系统启动两个数据库)
mkdir -p /data/{3307,3308}/{etc,socket,pid,log,data,binlog,relay-bin}
chown -R mysql.mysql /data/
mysql_install_db --datadir=/data/3307/data --user=mysql --basedir=/usr
mysql_install_db --datadir=/data/3308/data --user=mysql --basedir=/usr
#编写第一个数据库的配置文件
vi /data/3307/etc/my.cnf
[mysqld]
port=3307
log-bin=/data/3307/binlog/mysql-bin
datadir=/data/3307/data
socket=/data/3307/socket/mysql.sock
symbolic-links=0
server-id=1
collation-server=utf8_general_ci
character-set-server=utf8
[mysqld_safe]
log-error=/data/3307/log/mariadb.log
pid-file=/data/3307/pid/mariadb.pid
#编写第二个数据库的配置文件
vi /data/3308/etc/my.cnf
[mysqld]
port=3308
log-bin=/data/3308/binlog/mysql-bin
datadir=/data/3308/data
socket=/data/3308/socket/mysql.sock
symbolic-links=0
server-id=2
collation-server=utf8_general_ci
character-set-server=utf8
[mysqld_safe]
log-error=/data/3308/log/mariadb.log
pid-file=/data/3308/pid/mariadb.pid
mysqld_safe --defaults-file=/data/3307/etc/my.cnf & #放到后端执行,不然会占一个终端
mysqld_safe --defaults-file=/data/3308/etc/my.cnf &a