← Back to team overview

maria-developers team mailing list archive

Re: Query on MDEC-7502


Hi Sergei,

The problem I refer to is in a scenario where we try to send table with no
primary key. Lets suppose there is table with x rows and no primary key. We
first cut till n rows(n<x)and put those n rows in second log as we don't
know till where we completed the transfer. It is said that we stop master
from implementing DDL commands. What should happen if there is a DML
command? Should we change the log dynamically or redump the table.

Thank you:)

On Mar 27, 2017 4:58 PM, "Sergei Golubchik" <serg@xxxxxxxxxxx> wrote:

> Hi, Vishwanath!
> On Mar 23, Vishwanath Bharadwaj wrote:
> > Hello Mr. Sergei,
> > What I propose is rather than dumping the table into a single bin log.
> > What your idea proposes is we slide through the table based on primary
> > key. This becomes a bit of a problem if there is some error on the
> > receiver side. So we create 2 logs. We cut the chunk from one log and
> > send it through the RB logging.
> > This way we need not have different replication for same data. If some
> > error occurs we can resend the file from the data that is dumped into
> > bin logger. I hope I'm able to clear you query. If there is even a
> > slightest doubt in my idea please feel free to contact me and suggest
> > changes as I am still in my learning stage.
> > Thank you:)
> I'm not sure I understand.
> "a bit of a problem if there is some error on the receiver side" - an
> error on the slave means a problem for the whole replication, there's
> nothing special for MDEV-7502, as far as I can see. So I don't really
> understand why would you need two logs.
> Regards,
> Sergei
> Chief Architect MariaDB
> and security@xxxxxxxxxxx