求救:windows下mysql双机同步备份问题

yingong

我想做的备份模式是A->B同步复制
这是我主服务器A的my.ini的配置

#2008-09-05 星期五  
#11:44
#Uncomment or Add only the keys that you know how works.  
#Read the MySQL Manual for instructions  
[mysqldump]  
quick  
max_allowed_packet=32M  
[mysql]  
no-auto-rehash  
# Remove the next comment character if you are not familiar with SQL  
#safe-updates  
[isamchk]  
key_buffer=8M  
sort_buffer_size=8M  
[myisamchk]  
key_buffer=8M  
sort_buffer_size=8M  
[mysqlhotcopy]  
interactive-timeout  
[WinMySQLadmin]  
Server=D:/usr/local/mysql4/bin/mysqld-max-nt.exe   
user=root  
password=123456
[mysqld]  
basedir=D:/usr/local/mysql4   
datadir=D:/usr/local/mysql4/data   
port=3306  
skip-locking  
key_buffer=16K  
max_allowed_packet=1M  
table_cache=4  
sort_buffer_size=64K  
net_buffer_length=2K  
thread_stack=64K  
default-character-set=gbk  
default-character-set=gbk   
set-variable = back_log=50   
interactive_timeout =120   
set-variable = connect_timeout=3   
set-variable = max_connections=500   
set-variable = wait_timeout=120     
#master 配置
server-id=1
log-bin=c:/masterlog
binlog-do-db=db5







这是我从服务器B的my.ini的配置

# Remove the next comment character if you are not familiar with SQL  
#safe-updates  
[isamchk]  
key_buffer=8M  
sort_buffer_size=8M  
[myisamchk]  
key_buffer=8M  
sort_buffer_size=8M  
[mysqlhotcopy]  
interactive-timeout  
[WinMySQLadmin]  
Server=D:/usr/local/mysql4/bin/mysqld-max-nt.exe   
user=root  
password=123456
[mysqld]  
basedir=D:/usr/local/mysql4   
datadir=D:/usr/local/mysql4/data   
port=3306  
skip-locking  
key_buffer=16K  
max_allowed_packet=1M  
table_cache=4  
sort_buffer_size=64K  
net_buffer_length=2K  
thread_stack=64K  
default-character-set=gbk  
default-character-set=gbk   
set-variable = back_log=50   
interactive_timeout =120   
set-variable = connect_timeout=3   
set-variable = max_connections=500   
set-variable = wait_timeout=120   
server-id=2  
master-host=192.168.1.101  
master-user=backup  
master-password=backup  
master-port=3306  
master-connect-retry=60  
replicate-do-db=db5  


这主从服务器my.ini保存好后..
我进mysql/bin/目录启动了mysqld-max-nt

我在A服务器插入一条数据...B服务器还是没有反应

我照网上的教程反复又反复重复又重复的做了好多次都没成功..求救啊.我到底那里搞错了...

yueliangdao0608

惯例：

贴show processlist\G
show slave status\G

yingong

这是从服务器的show slave status\G

mysql> show slave status \G;
*************************** 1. row ********************
          Master_Host: 192.168.1.101
          Master_User: backup
          Master_Port: 3327
        Connect_retry: 60
      Master_Log_File:
  Read_Master_Log_Pos: 4
       Relay_Log_File: WWW-414D91DF1CE-relay-bin.011
        Relay_Log_Pos: 4
Relay_Master_Log_File:
     Slave_IO_Running: No
    Slave_SQL_Running: No
      Replicate_do_db:
  Replicate_ignore_db:
           Last_errno: 0
           Last_error:
         Skip_counter: 0
  Exec_master_log_pos: 0
      Relay_log_space: 8
1 row in set (0.00 sec)

ERROR:
No query specified

yingong

还有.我从服务器MY.INI设master-port=3306  怎么show slave status\G命令里看到的是3327....

yingong

这是主服务器
mysql> show slave status \G;
Empty set (0.00 sec)

ERROR:
No query specified

yingong

哦..下面那个贴子是主从服务器的

show processlist\G
show slave status\G

yingong

主服务器

mysql> show processlist\g
+----+------+----------------+------+---------+------+-------+------------------
+
| Id | User | Host           | db   | Command | Time | State | Info
|
+----+------+----------------+------+---------+------+-------+------------------
+
|  2 | root | localhost:1095 | NULL | Query   | 0    | NULL  | show processlist
|
+----+------+----------------+------+---------+------+-------+------------------
+
1 row in set (0.00 sec)

mysql> show slave status\g
Empty set (0.00 sec)

mysql>

yingong

从服务器

mysql> show slave status\g
+---------------+-------------+-------------+---------------+-----------------+-
--------------------+-------------------------------+---------------+-----------
------------+------------------+-------------------+-----------------+----------
-----------+------------+------------+--------------+---------------------+-----
------------+
| Master_Host   | Master_User | Master_Port | Connect_retry | Master_Log_File |
Read_Master_Log_Pos | Relay_Log_File                | Relay_Log_Pos | Relay_Mast
er_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate
_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Rela
y_log_space |
+---------------+-------------+-------------+---------------+-----------------+-
--------------------+-------------------------------+---------------+-----------
------------+------------------+-------------------+-----------------+----------
-----------+------------+------------+--------------+---------------------+-----
------------+
| 192.168.0.101 | test        | 3306        | 5             |                 |
4                   | WWW-414D91DF1CE-relay-bin.002 | 4             |
            | No               | No                |                 |
           | 0          |            | 0            | 0                   | 4
            |
+---------------+-------------+-------------+---------------+-----------------+-
--------------------+-------------------------------+---------------+-----------
------------+------------------+-------------------+-----------------+----------
-----------+------------+------------+--------------+---------------------+-----
------------+
1 row in set (0.00 sec)

mysql> show processlist\g
+----+------+----------------+------+---------+------+-------+------------------
+
| Id | User | Host           | db   | Command | Time | State | Info
|
+----+------+----------------+------+---------+------+-------+------------------
+
| 13 | root | localhost:1111 | NULL | Query   | 0    | NULL  | show processlist
|
+----+------+----------------+------+---------+------+-------+------------------
+
1 row in set (0.00 sec)

mysql>

yingong

有没有办法解决

yueliangdao0608

不知道你是怎么配置的？


     Slave_IO_Running: No
    Slave_SQL_Running: No

都是NO。仔细检查一下ERROR LOG.