mysql主从复制-----1

2017-01-07 11:18:16来源:作者:人点击

在新装的两个数据库间做主从复制当然这也是最简单的主从复制:
在主上操作:
设置server_id = 11  (为唯一的值)
然后在主上为复制账号赋予权限:
mysql> grant replication slave, replication client on *.* to repl@"192.168.1.%" identified by '123123';Query OK, 0 rows affected (0.00 sec)
在从上操作:
只需设置server_id = 12 (为唯一)登录数据库mysql> change master to master_host="192.168.1.120", -> master_user="repl", -> master_password="123123", -> master_log_file="mysql-bin.000001", -> master_log_pos=106;Query OK, 0 rows affected (0.03 sec)mysql> slave start;Query OK, 0 rows affected (0.01 sec)mysql> show slave status/G;*************************** 1. row ***************************Slave_IO_State: Waiting for master to send eventMaster_Host: 192.168.1.120Master_User: replMaster_Port: 3306 Connect_Retry: 60  Master_Log_File: mysql-bin.000001  Read_Master_Log_Pos: 276Relay_Log_File: slave-relay-bin.000002 Relay_Log_Pos: 421Relay_Master_Log_File: mysql-bin.000001 Slave_IO_Running: YesSlave_SQL_Running: Yes  Replicate_Do_DB:Replicate_Ignore_DB:Replicate_Do_Table:Replicate_Ignore_Table: Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:Last_Errno: 0 Last_Error:Skip_Counter: 0  Exec_Master_Log_Pos: 276  Relay_Log_Space: 576  Until_Condition: NoneUntil_Log_File:  Until_Log_Pos: 0Master_SSL_Allowed: NoMaster_SSL_CA_File:Master_SSL_CA_Path:Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0Last_SQL_Error: 1 row in set (0.00 sec)ERROR: No query specified
以上为最简单的主从复制:
测试在主上创建数据库:
mysql> create database example;Query OK, 1 row affected (0.00 sec)
在从上检测:
mysql> show databases;+--------------------+| Database|+--------------------+| information_schema || example|| mysql  || test|+--------------------+4 rows in set (0.00 sec)mysql>


本文出自 “自定义” 博客,谢绝转载!

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台