MySQL数据库在云主机上搭建主从配置
1：已经事先购买了两台云主机
10.4.14.168 101.69.178.208 [联通] Master
10.4.5.9 101.69.178.219 [联通] Slave
2：分别安装MySQL
| 代码如下 | |
|
#yum install mysql-devel |
|
3：查看MySQL安装情况
| 代码如下 | |
|
[root@10-4-14-168 ~]# rpm -qa | grep mysql* mysql-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 gechong@10.4.14.168 IDENTIFIED BY 'gechong'; |
|
8：在主库上执行
| 代码如下 | |
|
mysql> show master status; |
|
9：在从库的配置文件中添加之后重启服务
| 代码如下 | |
| master-host = 10.4.14.168 master-user = gechong master-password = gechong binlog-do-db = test |
|
10：在从库上执行
| 代码如下 | |
|
mysql> start slave; |
|
11：尝试在主库上添加新表，看是否从库上也会出现
