RE: making a storage engine crash safe on a slave in MySQL 5.6

Rick James <[email protected]> Wed, 3 Oct 2012 08:42:09 -0700
Newsgroups gmane.comp.db.mysql.devel
Message-ID <2E7DD7ADE53B044C8C8BCD9C5829E1EB148CF92165@SP2-EX07VS01.ds.corp.yahoo.com>
As I understand it, it is not quite that...

The transaction must get into the Slave's relay log before returning from the COMMIT.  (That's not the same as "committing".)



> -----Original Message-----
> From: Zardosht Kasheff [mailto:[email protected]]
> Sent: Wednesday, October 03, 2012 8:16 AM
> To: [email protected]
> Subject: making a storage engine crash safe on a slave in MySQL 5.6
> 
> Hello all,
> 
> I read that InnoDB is now crash safe on slaves in MySQL 5.6. I
> understand that a way they do this is on committing a transaction on a
> slave, they store the binary log position in an InnoDB table (which
> makes that information transactionally maintained). I also understand
> that this position is stored for each database, as databases may apply
> the replication log in parallel.
> 
> Upon recovery of a slave, how does InnoDB report to MySQL where the
> replication log should resume?
> 
> Can another storage engine similarly make itself crash safe on a slave?
> Will there be any issues with multiple storage engines doing so?
> 
> Thanks
> -Zardosht
> 
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals


-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals