基于MySQL Master Slave同步配置的操作分析
2022-11-12 09:27:59
内容摘要
这篇文章主要为大家详细介绍了基于MySQL Master Slave同步配置的操作分析,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!环境:PC:ubuntu 10
文章正文
这篇文章主要为大家详细介绍了基于MySQL Master Slave同步配置的操作分析,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!
环境:PC:ubuntu 10.10 192.168.1.112(master) 192.168.10.245(slave)MySQL : 5.1.49-1ubuntu8.1-log在master中已经存在数据库test首先修改mysql配置文件:/etc/mysql/my.cnf[master]#author:zhxia代码如下:
1 2 3 4 5 6 7 | <code>#master 同步设置 server-id = 1 log_bin = / var /log/mysql/mysql-test-bin.log expire_logs_days = 10 max_binlog_size = 100M binlog_format =mixed </code> |
代码如下:
1 2 3 4 5 6 7 8 9 10 11 12 | <code>server-id = 2 replicate- do -db=test replicate- do -db=blog log_bin = / var /log/mysql/mysql-bin.log relay_log =/ var /log/mysql/mysql-relay-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = test #binlog_ignore_db = include_database_name binlog_format = mixed slave-net-timeout=6012 master-connect-retry=10 </code> |
代码如下:
1 2 | <code>grant replication slave,replication client on *.* to 'slave' @ '192.168.10.245' identified by '123456' ; </code> |
代码如下:
1 2 3 4 5 6 7 8 | <code>mysql> show master status; +-----------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +-----------------------+----------+--------------+------------------+ | mysql-test-bin.000022 | 624 | | | +-----------------------+----------+--------------+------------------+ 1 row in set (0.02 sec) </code> |
代码如下:
1 2 | <code>change master to master_host= '192.168.1.112' , master_user= 'slave' , master_password= '123456' , master_log_file= 'mysql-test-bin.000022' , master_log_pos=106; </code> |
代码如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 | <code>start slave; mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.1.112 Master_User: slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-test-bin.000022 Read_Master_Log_Pos: 624 Relay_Log_File: mysql-relay-bin.000005 Relay_Log_Pos: 533 Relay_Master_Log_File: mysql-test-bin.000022 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: test,blog 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: 624 Relay_Log_Space: 688 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.00 sec) ERROR: No query specified </code> |
注:关于基于MySQL Master Slave同步配置的操作分析的内容就先介绍到这里,更多相关文章的可以留意
代码注释