MySQL Forums
Forum List  »  Replication

Replication table vs database
Posted by: PER JØ'RGENSEN
Date: November 29, 2018 04:05AM

Hey Forum.
I'm testing at the moment a little test setup.

Ves01 - contains tt.12345_p
Ves02 - contains tt.98765_p

HQ1 - contains whole tt database - Replicate from ves01 & ves02 into one DB

HQ2 - contains whole tt database - Replicate from HQ1

My Replication works fine towards HQ1 - When trying to replicate from HQ1 to HQ2 - I'm getting OK and connection - reading the Master bin log.
But its not inserting any statement in HQ2

Starting the channel - gives me
Slave I/O thread for channel 'tt': connected to master 'mysql_replic@192.168.10.61:3306',replication started in log 'mysql-bin.000005' at position 4

Reads the whole bin log - but do not insert any rows.
In slave status I'm getting:
Slave_IO_State: Queueing master event to the relay log

Untill the binlog file have been read - no data is available. No errors getting.

Today I dump the whole DB from HQ1 - loaded into HQ2 - and startet replication again - but again the same result


What Am I doing wrong here

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication table vs database
737
November 29, 2018 04:05AM
391
November 29, 2018 12:59PM
475
November 30, 2018 02:01AM


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.