From: Neil Tompkins Date: September 29 2011 6:43pm Subject: Re: replication between two tables in same database List-Archive: http://lists.mysql.com/mysql/225864 Message-Id: MIME-Version: 1.0 (iPhone Mail 8L1) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable But I could create an additional myisam table to overcome my problem providi= ng I can get the data to synchronise between the two tables On 29 Sep 2011, at 18:16, Reindl Harald wrote: > so mysql is currently the wrong database for your project > sad but true, you can not have fulltext-search and innodb this time >=20 > Am 29.09.2011 19:15, schrieb Tompkins Neil: >> We've succesfully used FULLTEXT searching on another application that doe= s not need Innodb tables. In addition for >> the FULLTEXT searching we use things like "IN BOOLEAN MODE" as well - so f= or our project Like %% is not enough. >>=20 >> On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald > wrote: >>=20 >> you do not need any replication or myisam for >> select * from table where field like '%input%'; >>=20 >> for most workloads this is enough and you have not the problem >> with stop-words, minimum input length and so on >>=20 >> Am 29.09.2011 19:07, schrieb Tompkins Neil: >>> Yes, unless I can set-up some sort of replication between the two tables= . >>>=20 >>> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald >wrote: >>>=20 >>>> please do NOT post off-list! >>>>=20 >>>> so your only workaround is like '%whatever%' currently >>>>=20 >>>> Am 29.09.2011 19:04, schrieb Tompkins Neil: >>>> The reason I'm using Innodb is because the usage of foreign keys in sho= rt >>>> however, we need a couple of the tables to support FULLTEXT searching w= hich Innodb >>>> does not support. >>>>=20 >>>>=20 >>>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald >wrote: >>>>=20 >>>>>=20 >>>>>=20 >>>>> Am 29.09.2011 18:56, schrieb Tompkins Neil: >>>>>> Hi >>>>>>=20 >>>>>> 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. >>>>>=20 >>>>> in short: no >>>>>=20 >>>>> 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 >>>>>=20 >>>>> replication is based on binlogs and contains database/table so there i= s >>>>> no dirty trick do this on one server except let run a script and copy >>>>> the table-contents per cronjob >>>>>=20 >>>>>=20 >>>>=20 >>>> -- >>>>=20 >>>> Mit besten Gr=C3=BC=C3=9Fen, Reindl Harald >>>> the lounge interactive design GmbH >>>> A-1060 Vienna, Hofm=C3=BChlgasse 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 >>>>=20 >>>>=20 >>>=20 >>=20 >> -- >>=20 >> Mit besten Gr=C3=BC=C3=9Fen, Reindl Harald >> the lounge interactive design GmbH >> A-1060 Vienna, Hofm=C3=BChlgasse 17 >> CTO / software-development / cms-solutions >> p: +43 (1) 595 3999 33 , m: +43= (676) 40 221 40 >> >> icq: 154546673, http://www.thelounge.net/ >>=20 >> http://www.thelounge.net/signature.asc.what.htm >>=20 >>=20 >=20 > --=20 >=20 > Mit besten Gr=C3=BC=C3=9Fen, Reindl Harald > the lounge interactive design GmbH > A-1060 Vienna, Hofm=C3=BChlgasse 17 > CTO / software-development / cms-solutions > p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 > icq: 154546673, http://www.thelounge.net/ >=20 > http://www.thelounge.net/signature.asc.what.htm >=20