MySQL数据库在云主机上搭建主从配置

作者：袖梨 2022-11-14

1：已经事先购买了两台云主机

10.4.14.168 101.69.178.208 [联通] Master

10.4.5.9 101.69.178.219 [联通] Slave

2：分别安装MySQL

代码如下

复制代码

#yum install mysql-server –enablerepo=remi

#yum install mysql-devel

3：查看MySQL安装情况

代码如下

复制代码

[root@10-4-14-168 ~]# rpm -qa | grep mysql*

mysql-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-server-5.1.73-3.el6_5.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64

4：启动MySQL

代码如下	复制代码
service mysqld start

5：登陆MySQL并且修改密码并且删除空用户

代码如下

复制代码

mysql> UPDATE mysql.user SET password = PASSWORD('ge0513.mysql')
-> WHERE user = 'root';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> SELECT user,host,password FROM mysql.user;
+------+-------------+-------------------------------------------+
| user | host | password |
+------+-------------+-------------------------------------------+
| root | localhost | *7AE39BE5035D5C32361400FF7DEDD757AA76896A |
| root | 10-4-14-168 | *7AE39BE5035D5C32361400FF7DEDD757AA76896A |
| root | 127.0.0.1 | *7AE39BE5035D5C32361400FF7DEDD757AA76896A |
| | localhost | |
| | 10-4-14-168 | |
+------+-------------+-------------------------------------------+
5 rows in set (0.00 sec)
mysql> DROP user ''@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> DROP user ''@'10-4-14-168';
Query OK, 0 rows affected (0.00 sec)

6 需改配置文件

代码如下	复制代码
bind-address = 10.6.20.1 port = 3306 character_set_server = utf8 max_connect_errors = 1000000 max_connections = 500 datadir = /data/mysql log-error = /var/log/mysql/mysql-error.log-error skip_name_resolve back_log = 2000 log-bin = /data/mysql binlog-format = MIXED expire_logs_days = 2

7：主库上创建复制用户

代码如下	复制代码
GRANT REPLICATION SLAVE ON . TO [email protected] IDENTIFIED BY 'gechong';

8：在主库上执行

代码如下	复制代码
mysql> show master status; +---------------+----------+--------------+------------------+ \| File \| Position \| Binlog_Do_DB \| Binlog_Ignore_DB \| +---------------+----------+--------------+------------------+ \| binlog.000003 \| 412 \| \| \| +---------------+----------+--------------+------------------+ 1 row in set (0.00 sec)

9：在从库的配置文件中添加之后重启服务