[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: mysqlsnapshot and InnoDB tables

On Fri, Oct 25, 2002 at 02:33:54PM +0200, Amaya wrote:
> Dear friends,
> I have successfully setup MySQL replication enviroment in several
> clusters at work. The thing is that it is a little cumbersome
> proccess as I have to make a snapshot of the databases in the master
> server everytime and I have to stop the service in order to do it.
> I have just come across mysqlsnapshot [1] and it claims [2] that it can
> generate an initial snapshot and consistent bin-log for MySQL
> replication (on the master server) without taking the master off-line.
> The only catch is that the binary log must already be enabled.

So far, so good.

> The problem is that I use InnoDB and it is supposed only to work for
> the MyISAM kind.


> Questions come to my mind:
> Would it be very hard to support both kind of databases?

That depends.  I don't know if it's "safe" to backup the InnoDB
tablespaces without shutting the server down.  I suspect that it's not
because there is no way to force InnoDB to commit all logged
transactions.  In practice it may not be a problem, but it could be.

I'll have to ask the InnoDB developer about that.

If the answer is "yes", then adding support to mysqlsnapshot should be
quite easy.

Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@Zawodny.com>  |  http://jeremy.zawodny.com/

Reply to: