List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:September 29 2011 9:59pm
Subject:Re: replication between two tables in same database
View as plain text  
I've now just upgraded to MySQL 5.6 on our test server.  Just trying to find
a date as to when it will go into production

On Thu, Sep 29, 2011 at 8:10 PM, 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<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<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<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=mos99@ style="color:#666">stripped<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=neil.tompkins@**
> googlemail.com<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