From: Anupam Karmarkar Date: October 3 2011 6:20am Subject: Re: replication between two tables in same database List-Archive: http://lists.mysql.com/mysql/225898 Message-Id: <1317622810.21633.YahooMailNeo@web94706.mail.in2.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1396951373-268822932-1317622810=:21633" --1396951373-268822932-1317622810=:21633 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Try out functionality you desire with trigger to replicate data=0A=0A=0A=0A= ________________________________=0AFrom: Derek Downey =0ATo: [MySQL] =0ASent: Thursday, 29 September 20= 11 10:46 PM=0ASubject: Re: replication between two tables in same database= =0A=0AYou could look into the sphinx engine http://sphinxsearch.com/about/s= phinx/=0A=0ANo experience with this personally though=0A=0A- Derek=0AOn Sep= 29, 2011, at 1:07 PM, Tompkins Neil wrote:=0A=0A> Yes, unless I can set-up= some sort of replication between the two tables.=0A> =0A> On Thu, Sep 29, = 2011 at 6:05 PM, Reindl Harald wrote:=0A> =0A>> ple= ase do NOT post off-list!=0A>> =0A>> so your only workaround is like '%what= ever%' currently=0A>> =0A>> Am 29.09.2011 19:04, schrieb Tompkins Neil:=0A>= > The reason I'm using Innodb is because the usage of foreign keys in short= =0A>> however, we need a couple of the tables to support FULLTEXT searching= which Innodb=0A>> does not support.=0A>> =0A>> =0A>> On Thu, Sep 29, 2011 = at 6:01 PM, Reindl Harald wrote:=0A>> =0A>>> =0A>>>= =0A>>> Am 29.09.2011 18:56, schrieb Tompkins Neil:=0A>>>> Hi=0A>>>> =0A>>>= > I've a Innodb and MyISAM table in the SAME database that I wish to=0A>>> = replicate=0A>>>> the data between the two because I need to use FULLTEXT se= arching on=0A>>>> the MyISAM table.=A0 Is this possible ? If so how do I do= it.=0A>>> =0A>>> in short: no=0A>>> =0A>>> in longer:=0A>>> why in the wor= ld are you using the wrong engine if you need=0A>>> fulltext-search?=0A>>> = mysql 5.6 semmes to start support this in innodb, but currently not=0A>>> = =0A>>> replication is based on binlogs and contains database/table so there= is=0A>>> no dirty trick do this on one server except let run a script and = copy=0A>>> the table-contents per cronjob=0A>>> =0A>>> =0A>> =0A>> --=0A>> = =0A>> Mit besten Gr=FC=DFen, Reindl Harald=0A>> the lounge interactive desi= gn GmbH=0A>> A-1060 Vienna, Hofm=FChlgasse 17=0A>> CTO / software-developme= nt / cms-solutions=0A>> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40=0A>>= icq: 154546673, http://www.thelounge.net/=0A>> http://www.thelounge.net/si= gnature.asc.what.htm=0A>> =0A>> =0A=0A=0A--=0AMySQL General Mailing List=0A= For list archives: http://lists.mysql.com/mysql=0ATo unsubscribe:=A0 =A0 ht= tp://lists.mysql.com/mysql?unsub=3Dsb_akarmarkar@stripped --1396951373-268822932-1317622810=:21633--