List:General Discussion« Previous MessageNext Message »
From:mos Date:September 29 2011 7:10pm
Subject:Re: replication between two tables in same database
View as plain text  
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.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
> >
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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