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:在从库的配置文件中添加之后重启服务

代码如下 复制代码
master-host = 10.4.14.168
master-user = gechong
master-password = gechong
binlog-do-db = test

10:在从库上执行

代码如下 复制代码

mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

11:尝试在主库上添加新表,看是否从库上也会出现

相关文章

精彩推荐