Re: replication between two tables in same database

[mos]

Derek is right. The Sphynx search engine is much 
faster than MyISAM's full text search engine. It 
will work on InnoDb tables so you don't have to export the data to MyISAM.

Mike
At 01:43 PM 9/29/2011, you wrote:
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=mo...@fastmail.fm


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org