Hi,
I'm using two Mysql 3.23.36 with Innobase tables on two machines running
Redhat 7.0.
I'm trying to use replication in a simple master/slave configuration,
but while it works
when I use MyIsam tables, if one of the two machines tries to use
Innobase tables
the replication doesn't work,
Nico,
does the table you are trying to replicate contain rows
with more than 8000 bytes of data?
InnoDB (= Innobase) cannot store longer rows. Arbitrary length BLOB and TEXT
fields are on the TODO list for June 2001.
Does the slave hang also for other queries you try to do
on the slave's
Nico,
it came to my mind that possibly 'load table from master' uses
LOCK TABLES to speed up processing in the slave. In 3.23.36
there was a bug with LOCK TABLES in connection with InnoDB
(named the Wisconsin bug).
It might help if you download and compile the new 3.23.37
from the MySQL
: [EMAIL PROTECTED]
Date: Thu, 19 Apr 2001 18:53:47 +
From: Nicola Sabbi [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
X-Accept-Language: en
To: Heikki Tuuri [EMAIL PROTECTED]
Subject: Re: [Fwd: Replication non working with Innobase]
References: 20010419143600.BZFW26396.fep06.tmt.tele.fi@omnibook
