so mysql is currently the wrong database for your project sad but true, you can not have fulltext-search and innodb this time
Am 29.09.2011 19:15, schrieb Tompkins Neil: > 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 > <mailto: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 > <mailto: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 > <mailto: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 <tel:%2B43%20%281%29%20595%203999%2033>, m: +43 > (676) 40 221 40 > <tel:%2B43%20%28676%29%2040%20221%2040> > >> 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 <tel:%2B43%20%281%29%20595%203999%2033>, m: +43 > (676) 40 221 40 > <tel:%2B43%20%28676%29%2040%20221%2040> > 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
