But I could create an additional myisam table to overcome my problem providing I can get the data to synchronise between the two tables
On 29 Sep 2011, at 18:16, Reindl Harald <h.rei...@thelounge.net> wrote: > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org