List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:September 29 2011 7:21pm
Subject:Re: replication between two tables in same database
View as plain text  
I'm not sure it would work in my environment of IIS and MySQL ?

On 29 Sep 2011, at 20:10, mos <mos99@stripped> wrote:

> 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
> 
> 
> -- 
> 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