List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:September 29 2011 5:16pm
Subject:Re: replication between two tables in same database
View as plain text  
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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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