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 tables. > > On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald <h.rei...@thelounge.net>wrote: > >> 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 short >> 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.rei...@thelounge.net>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üßen, Reindl Harald >> the lounge interactive design GmbH >> A-1060 Vienna, Hofmühlgasse 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 >> >> > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 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
signature.asc
Description: OpenPGP digital signature