MySQL Forums
Forum List  »  Replication

Re: InnoDB Replication - do I need a copy of ibdata* or will a dump do?
Posted by: Dominik
Date: November 30, 2005 04:48AM

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 .

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB Replication - do I need a copy of ibdata* or will a dump do?
2038
November 30, 2005 04:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.