Database Replication In MySQL just doesn't work.

Hello all,

After following the tutorial how to setup the MySQL replacation.(here)
For some reason it doesn't seem to replicate.
I can't find any logs (or offcourse i am not looking correctly).
Can somebody help me troubleshoot this issue and resolve it?

Many thanks in advance.

kind regards,

Jottie

 

Anyone? I just cant seem to find the issue.

 

Any errors in /var/log/syslog?

 

I've checked the logs on my master and on my slave.
I don't find any logs regarding the replication in my master servers log.
I do however see this in my slave servers log :

Sep 10 14:42:05 ns2 mysqld[2329]: 080910 14:42:05 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000246' at position 2012, relay log './ns2-relay-bin.000725' position: 4
Sep 10 14:42:05 ns2 mysqld[2329]: 080910 14:42:05 [Note] Slave I/O thread: connected to master '<replicateuser>@x.x.x.x:3306', replication started in log 'mysql-bin.000248' at position 98

This should make me believe its working as designed.

However, when i update the the master sql DB, it doesn't replicate to the slave.

Any other idea's where i could check ?

 

Never mind. For some reason all seems to work now. I guess i should open up topics just to resolve issues

Thanks anyway!

 

You wait when the dbs end up out of sync again then you'll be back here claiming it doesn't work properly

I gave up with the replication server, it's borderlines useless.

 

It's working for me without problems (on production systems).

 

Well, so far it still seems to work. I don't know why however.
I'm still happy.