From: Tompkins Neil Date: September 29 2011 9:59pm Subject: Re: replication between two tables in same database List-Archive: http://lists.mysql.com/mysql/225869 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf307c9f38ee773704ae1b9e9f --20cf307c9f38ee773704ae1b9e9f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I've now just upgraded to MySQL 5.6 on our test server. Just trying to fin= d a date as to when it will go into production On Thu, Sep 29, 2011 at 8:10 PM, mos wrote: > Derek is right. The Sphynx search engine is much faster than MyISAM's ful= l > 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 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**>> 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 >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 searchi= ng >> which Innodb >> >>>> does not support. >> >>>> >> >>>> >> >>>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald < >> 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 t= o >> >>>>> 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 no= t >> >>>>> >> >>>>> replication is based on binlogs and contains database/table so the= re >> is >> >>>>> no dirty trick do this on one server except let run a script and >> copy >> >>>>> the table-contents per cronjob >> >>>>> >> >>>>> >> >>>> >> >>>> -- >> >>>> >> >>>> Mit besten Gr=C3=83=C2=BC=C3=83=C5=B8en, 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=C5=B8en, 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=C5=B8en, 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 >> > >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?**unsub=3Dmos99@fastmail= .fm >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?**unsub=3Dneil.tompkins@*= * > googlemail.com > > --20cf307c9f38ee773704ae1b9e9f--