From: Neil Tompkins Date: September 29 2011 7:27pm Subject: Re: replication between two tables in same database List-Archive: http://lists.mysql.com/mysql/225867 Message-Id: <58096B8A-7F3F-4D42-8278-C3E1D1243947@googlemail.com> MIME-Version: 1.0 (iPhone Mail 8L1) Content-Type: multipart/alternative; boundary=Apple-Mail-1--285166072 Content-Transfer-Encoding: 7bit --Apple-Mail-1--285166072 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Am thinking now that it might be best to use MySQL 5.6 as this is a new proj= ect still in development and we will have the new FullText Search with Innod= b On 29 Sep 2011, at 18:43, Andrew Moore wrote: > Hey Neil, I read your question too quickly and jumped to the conclusion yo= u weren't sure MyISAM replicates in a mixed storage engine environment. Howe= ver, you could still potentially replicate the data using standard replicati= on and even on the same server (different instances).=20 >=20 > InstanceA ---------------------------> InstanceB > MyISAM InnoDB >=20 > You could use Triggers but be careful if you decide to do that because tri= ggers and replication don't play well together in some circumstances. >=20 > As a side note and something that was already mentioned to you, MySQL are w= orking on 5.6 and as part of that release InnoDB will have it's own implemen= tation of FT indexing. >=20 > HTH=20 >=20 > Andy >=20 > On Thu, Sep 29, 2011 at 6:00 PM, Tompkins Neil wrote: > Can you give me any pointers ? >=20 >=20 > On Thu, Sep 29, 2011 at 5:59 PM, Andrew Moore wrote:= > Hey Neil, it sure is possible through standard replication configuration. >=20 > Hth Andy >=20 > On Sep 29, 2011 5:57 PM, "Tompkins Neil" wr= ote: > > Hi > >=20 > > I've a Innodb and MyISAM table in the SAME database that I wish to repli= cate > > 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 > > Thanks > > Neil >=20 >=20 --Apple-Mail-1--285166072--