Hi, MARK!
On Nov 09, MARK CALLAGHAN wrote:
>
> Is the infrastructure that keeps InnoDB and the binlog in sync after
> crash recovery also available to other storage engines? Without that
> support, I wouldn't consider using anything other than InnoDB on a
> master.
Yes.
If an engine supports XA it'll be part of two phase commit and will be
always in sync with binlog and other XA-capable engines involved in the
transaction.
But the part of XA that is only enabled *without* binlog is poorly
tested. That is if there's more than one XA-capable engine and binlog
is off - there will be dragons.
Regards / Mit vielen Grüßen,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server Architect
/_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München 161028
<___/ Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring
