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.reindl@stripped> 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.reindl@stripped
> <mailto:h.reindl@stripped>> 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.reindl@stripped
> <mailto:h.reindl@stripped>>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.reindl@stripped
> <mailto: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üß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
>
