I have done some testing and I cannot get it to work yet.
Master and Slave are 4.0.12 and there is currently no way to change that.
Master has "log-bin" and "server-id = 1" in /etc/my.cnf and is running with that conf for quite a while.
Now I set up a slave - also with 4.0.12. I followed the instructions on
http://dev.mysql.com/doc/refman/4.0/de/replication-howto.html
and I cannot get it to work.
I testet connection with the created replication user -> works fine
I started the Slave, created a Db just like the one on the master, entered the CHANGE MASTER TO command with appropriate options and executed SLAVE START;
SHOW SLAVE STATUS gives:
Slave_IO_Running: No
Slave_SQL_Running: Yes
SHOW PROCESSES gives:
| 5 | system user | localhost | NULL | Connect | 16 | Slave: waiting for binlog update | NULL
I cannot see any new processes on the Master.
So I did a
mysqldump --all-databases --master-data --single-transaction > /tmp/all.sql
This reset the bin-log numbers and deleted any previous bin-log files. I imported the all.sql on the slave (after dropping my previously created databases there) but the result is the same.
So:
Why does the IO Thread not start and why can I not see anything happen on the master?
Another question on the position "master_log_pos":
Does this have to be the value "SHOW MASTER STATUS" puts out on the master in the moment the slave starts or can it be a lower number?
Edited 1 time(s). Last edit at 11/30/2005 04:49AM by Dominik .