List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:September 29 2011 6:43pm
Subject:Re: replication between two tables in same database
View as plain text  
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
> 
Thread
replication between two tables in same databaseTompkins Neil29 Sep
  • Re: replication between two tables in same databaseReindl Harald29 Sep
  • Re: replication between two tables in same databaseJim Moseby29 Sep
Re: replication between two tables in same databaseTompkins Neil29 Sep
  • Re: replication between two tables in same databaseReindl Harald29 Sep
    • Re: replication between two tables in same databaseTompkins Neil29 Sep
      • Re: replication between two tables in same databaseReindl Harald29 Sep
        • Re: replication between two tables in same databaseNeil Tompkins29 Sep
          • Re: replication between two tables in same databasemos29 Sep
  • Re: replication between two tables in same databaseDerek Downey29 Sep
    • Re: replication between two tables in same databaseAnupam Karmarkar3 Oct
Re: replication between two tables in same databaseNeil Tompkins29 Sep
Re: replication between two tables in same databaseNeil Tompkins29 Sep
Re: replication between two tables in same databaseTompkins Neil29 Sep
  • Re: replication between two tables in same databasePeter Boros30 Sep