From: Baron Schwartz Date: May 13 2009 6:56pm Subject: Re: MySQL Reengineering Project List-Archive: http://lists.mysql.com/internals/36674 Message-Id: <4cfa0b030905131156k32a5d701k46c31483ce854588@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Wed, May 13, 2009 at 10:49 AM, Stewart Smith wrote: > On Wed, May 13, 2009 at 08:31:09AM -0400, Baron Schwartz wrote: >> Or you might want the ability to open a connection to the server and >> join the same context (e.g. transaction) as an existing connection. > > (without having looked at the code) it's my guess that the parallel > slave thread work does this inside the server. > > If accessible outside the server, you could apply replication logs in > sep process - which does seem awfully like a nice idea. I think there are a lot of nice possibilities -- backups, for example. Connect and start a transaction, then connect a bunch more times and join the same transaction to get a consistent snapshot.