From: Reindl Harald
Date: September 29 2011 5:13pm
Subject: Re: replication between two tables in same database
List-Archive: http://lists.mysql.com/mysql/225860
Message-Id: <4E84A720.1030403@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigFD6007D3A1074E0F81287897"

--------------enigFD6007D3A1074E0F81287897
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

you do not need any replication or myisam for
select * from table where field like '%input%';

for most workloads this is enough and you have not the problem
with stop-words, minimum input length and so on

Am 29.09.2011 19:07, schrieb Tompkins Neil:
> Yes, unless I can set-up some sort of replication between the two table=
s.
>=20
> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald <h.reindl@stripped>=
wrote:
>=20
>>  please do NOT post off-list!
>>
>> so your only workaround is like '%whatever%' currently
>>
>> Am 29.09.2011 19:04, schrieb Tompkins Neil:
>> The reason I'm using Innodb is because the usage of foreign keys in sh=
ort
>> however, we need a couple of the tables to support FULLTEXT searching =
which Innodb
>> does not support.
>>
>>
>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald <h.reindl@stripped=
>wrote:
>>
>>>
>>>
>>> Am 29.09.2011 18:56, schrieb Tompkins Neil:
>>>> Hi
>>>>
>>>> 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.
>>>
>>> in short: no
>>>
>>> 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
>>>
>>> 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
>>>
>>>
>>
>> --
>>
>> 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

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


--------------enigFD6007D3A1074E0F81287897
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6EpyAACgkQhmBjz394AnmLZACdHxLCdxOrZdIPXcJRUJ6FakMn
e/AAoIuFopmp6GYiK+fLAddaYlRaVWum
=EGoi
-----END PGP SIGNATURE-----

--------------enigFD6007D3A1074E0F81287897--