From: Neil Tompkins Date: September 29 2011 7:21pm Subject: Re: replication between two tables in same database List-Archive: http://lists.mysql.com/mysql/225866 Message-Id: <1C6B5120-58B2-4ED7-9EF3-676119551ADF@googlemail.com> MIME-Version: 1.0 (iPhone Mail 8L1) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I'm not sure it would work in my environment of IIS and MySQL ? On 29 Sep 2011, at 20:10, mos 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 expo= rt the data to MyISAM. >=20 > Mike >=20 > At 01:43 PM 9/29/2011, you wrote: >> But I could create an additional myisam table to overcome my problem prov= iding I can get the data to synchronise between the two tables >>=20 >> On 29 Sep 2011, at 18:16, Reindl Harald wrote: >>=20 >> > 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 d= oes not need Innodb tables. In addition for >> >> the FULLTEXT searching we use things like "IN BOOLEAN MODE" as well - s= o for our project Like %% is not enough. >> >> >> >> On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald > 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 tab= les. >> >>> >> >>> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald >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 s= hort >> >>>> however, we need a couple of the tables to support FULLTEXT searchin= g which Innodb >> >>>> does not support. >> >>>> >> >>>> >> >>>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald >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 o= n >> >>>>>> 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 ther= e is >> >>>>> no dirty trick do this on one server except let run a script and co= py >> >>>>> the table-contents per cronjob >> >>>>> >> >>>>> >> >>>> >> >>>> -- >> >>>> >> >>>> Mit besten Gr=C3=83=C2=BC=C3=83=C2=9Fen, Reindl Harald >> >>>> the lounge interactive design GmbH >> >>>> A-1060 Vienna, Hofm=C3=83=C2=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 >> >>>> >> >>>> >> >>> >> >> >> >> -- >> >> >> >> Mit besten Gr=C3=83=C2=BC=C3=83=C2=9Fen, Reindl Harald >> >> the lounge interactive design GmbH >> >> A-1060 Vienna, Hofm=C3=83=C2=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 >> >> >> >> >> > >> > -- >> > >> > Mit besten Gr=C3=83=C2=BC=C3=83=C2=9Fen, Reindl Harald >> > the lounge interactive design GmbH >> > A-1060 Vienna, Hofm=C3=83=C2=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 >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmos99@stripped= >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dneil.tompkins@goog= lemail.com >=20