maria-developers team mailing list archive
Mailing list archive
Re: Ideas for improving MariaDB/MySQL replication
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).