From: MARK CALLAGHAN Date: November 9 2009 6:49pm Subject: Re: how does one know if their storage engine supports replication? List-Archive: http://lists.mysql.com/internals/37473 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Mon, Nov 9, 2009 at 10:36 AM, Sergei Golubchik wrote: > 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. =A0That is if there's more than one XA-capable engine and binlog > is off - there will be dragons. > What about the interface by which MySQL gives InnoDB the list of XIDs from the current binlog so InnoDB cannot rollback transactions that were prepared before the crash but not committed. Is that available to other storage engines? --=20 Mark Callaghan mdcallag@stripped