← Back to team overview

maria-developers team mailing list archive

Re: Ideas for improving MariaDB/MySQL replication


Hi, Stewart!

On May 14, Stewart Smith wrote:
> On Thu, 13 May 2010 16:36:41 +0200, Sergei Golubchik <serg@xxxxxxxxxxxx> wrote:
> >  * not everything can be replicated at every level, for example table
> >    creation cannot be replicated row-based, InnoDB changes cannot be
> >    replicated with "MyISAM pwrite()" events
> We're doing it as kinda row based ("structure based" ?) with using the
> table protobuf message as a standard interchange format for it.

Right, I know.

What I described does not specify that it should be row based or should
use protobuf - but it can do that too, probably could replicate to
and from drizzle using native drizzle replication protocol, row based
with protobufs. With an appropriate plugin, of course.

> This enables some really nice things - like replicating to non-SQL
> systems. Or even just sanely replicating to a SQL system that doesn't
> share your exact syntax and defaults for DDL (i.e. anybody that isn't
> you, at the same version).