Bug #30702 | Unable to setup master-slave replication | ||
---|---|---|---|
Submitted: | 29 Aug 2007 17:19 | Modified: | 29 Aug 2007 17:52 |
Reporter: | Howard Finer | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
Version: | 5.0.46 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[29 Aug 2007 17:19]
Howard Finer
[29 Aug 2007 17:52]
Howard Finer
The issue had something to do with the log-bin, log-bin-index, relay-log, and relay-log-index settings. When I set all 4 in the my.cnf file, everything works properly. Prior to setting the values, there was a file called "--server_id=1.index" being created on the master, backed up to the slave, and confusing the server. Once the 4 values were set (just the 2 log-bin ones on the master), everything works properly. this can be closed.