From: Derek Downey
Date: September 29 2011 5:16pm
Subject: Re: replication between two tables in same database
List-Archive: http://lists.mysql.com/mysql/225863
Message-Id: <098F0DC5-720C-496F-9759-E8C1C6F75EEB@orange-pants.com>
MIME-Version: 1.0 (Apple Message framework v1244.3)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

You could look into the sphinx engine =
http://sphinxsearch.com/about/sphinx/

No experience with this personally though

- Derek
On Sep 29, 2011, at 1:07 PM, Tompkins Neil wrote:

> Yes, unless I can set-up some sort of replication between the two =
tables.
>=20
> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald =
<h.reindl@stripped>wrote:
>=20
>> please do NOT post off-list!
>>=20
>> so your only workaround is like '%whatever%' currently
>>=20
>> Am 29.09.2011 19:04, schrieb Tompkins Neil:
>> The reason I'm using Innodb is because the usage of foreign keys in =
short
>> however, we need a couple of the tables to support FULLTEXT searching =
which Innodb
>> does not support.
>>=20
>>=20
>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald =
<h.reindl@stripped>wrote:
>>=20
>>>=20
>>>=20
>>> Am 29.09.2011 18:56, schrieb Tompkins Neil:
>>>> Hi
>>>>=20
>>>> I've a Innodb and MyISAM table in the SAME database that I wish to
>>> replicate
>>>> the data between the two because I need to use FULLTEXT searching =
on
>>>> the MyISAM table.  Is this possible ? If so how do I do it.
>>>=20
>>> in short: no
>>>=20
>>> in longer:
>>> why in the world are you using the wrong engine if you need
>>> fulltext-search?
>>> mysql 5.6 semmes to start support this in innodb, but currently not
>>>=20
>>> replication is based on binlogs and contains database/table so there =
is
>>> no dirty trick do this on one server except let run a script and =
copy
>>> the table-contents per cronjob
>>>=20
>>>=20
>>=20
>> --
>>=20
>> Mit besten Gr=FC=DFen, Reindl Harald
>> the lounge interactive design GmbH
>> A-1060 Vienna, Hofm=FChlgasse 17
>> CTO / software-development / cms-solutions
>> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
>> icq: 154546673, http://www.thelounge.net/
>> http://www.thelounge.net/signature.asc.what.htm
>>=20
>>=20