Replication table vs database
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
Subject
Views
Written By
Posted
Replication table vs database
848
November 29, 2018 04:05AM
462
November 29, 2018 12:59PM
540
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.