假设已经安装MySQL服务端,以下是配置过程:
1. 安装数据文件目录
mysql_install_db /data/mysqldb/3306
mysql_install_db /data/mysqldb/3307
2. 设置目录组权限
chown -R mysql:mysql /data/mysqldb/3306 /data/mysqldb/3307
3. 编辑配置文件(/etc/mysql/my.cnf)
[mysqld3306]
user=mysql
socket=/data/mysqldb/3306/3306.sock
pid-file=/data/mysqldb/3306/3306.pid
port=3306
datadir=/data/mysqldb/3306
server-id=3306 #此ID必须唯一
log_bin=/data/mysqldb/3306/mysql-bin.log #主从同步依赖此日志
[mysqld3307]
...
#配置链接主库信息
server-id=3307
master-host=127.0.0.1
master-port=3306
master-user=slave
master-password=123
master-connect-retry=1
4. 启动数据库
mysqld_multi start
5. 在主库中创建从库帐号
create user 'slave'@'127.0.0.1' identified by '123';
grant replication slave on *.* to 'slave'@'127.0.0.1';
6. 启动从库
mysql> start slave
7. 查看主从库状态
show master status
show slave status
1. 安装数据文件目录
mysql_install_db /data/mysqldb/3306
mysql_install_db /data/mysqldb/3307
2. 设置目录组权限
chown -R mysql:mysql /data/mysqldb/3306 /data/mysqldb/3307
3. 编辑配置文件(/etc/mysql/my.cnf)
[mysqld3306]
user=mysql
socket=/data/mysqldb/3306/3306.sock
pid-file=/data/mysqldb/3306/3306.pid
port=3306
datadir=/data/mysqldb/3306
server-id=3306 #此ID必须唯一
log_bin=/data/mysqldb/3306/mysql-bin.log #主从同步依赖此日志
[mysqld3307]
...
#配置链接主库信息
server-id=3307
master-host=127.0.0.1
master-port=3306
master-user=slave
master-password=123
master-connect-retry=1
4. 启动数据库
mysqld_multi start
5. 在主库中创建从库帐号
create user 'slave'@'127.0.0.1' identified by '123';
grant replication slave on *.* to 'slave'@'127.0.0.1';
6. 启动从库
mysql> start slave
7. 查看主从库状态
show master status
show slave status