Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2004
    Posts
    62

    Unanswered: Replication did not work after first replication ?

    Greetings DBAs,
    I have setup a MySQL replication environment with 1 master and 1 slave. Both running on MySQL 4.1.7 on Windows XP and have the identical database structures.
    Below are the setting for my servers master and slave

    [Master] for [my.ini]
    server-id=1

    [Slave] for [my.ini]
    server-id = 2

    master-host = 10.10.10.1
    master-port = 3306
    master-user = repl
    master-password = password

    log-bin = d:/temp/logs/bin.log
    log-bin-index = d:/temp/logs/log-bin.index
    log-error = d:/temp/logs/error.log

    relay-log = d:/temp/logs/relay.log
    relay-log-info-file = d:/temp/logs/relay-log.info
    relay-log-index = d:/temp/logs/relay-log.index

    I followed the settings from this site
    http://www.onlamp.com/lpt/a/5949

    Yes it worked, for the first record i insert into a table. It was succesfully replicated to my slave, but then it suddenly didnot work.
    After i ran SHOW SLAVE STATUS; on the slave server this is the output
    Master_Host: my.ls.slave.fm
    Master_User: slave
    Master_Port: 3306
    Connect_Retry: 60
    Master_Log_File: mysql-bin.000002
    Read_Master_Log_Pos: 342
    Relay_Log_File: SLAVE-relay-bin.000005
    Relay_Log_Pos: 310
    Relay_Master_Log_File: mysql-bin.000002
    Slave_IO_Running: No
    Slave_SQL_Running: Yes
    Replicate_Do_DB: dis
    Replicate_Ignore_DB: mysql
    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: 342
    Relay_Log_Space: 310
    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: 783
    Thank you.
    Last edited by pakcik_kantin; 09-19-06 at 04:40.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •