We've succesfully used FULLTEXT searching on another application that does not need Innodb tables. In addition for the FULLTEXT searching we use things like "IN BOOLEAN MODE" as well - so for our project Like %% is not enough.
On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald <h.rei...@thelounge.net>wrote: > 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 > >
