From: Reindl Harald Date: September 29 2011 5:16pm Subject: Re: replication between two tables in same database List-Archive: http://lists.mysql.com/mysql/225862 Message-Id: <4E84A7F4.4000103@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig3C2A2A123BC7BB218597EF02" --------------enig3C2A2A123BC7BB218597EF02 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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. >=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. > > > > 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 short > >> however, we need a couple of the tables to support FULLTEXT sear= ching 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 wis= h to > >>> replicate > >>>> the data between the two because I need to use FULLTEXT search= ing 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= not > >>> > >>> replication is based on binlogs and contains database/table so = there is > >>> no dirty trick do this on one server except let run a script an= d copy > >>> the table-contents per cronjob > >>> > >>> > >> > >> -- > >> > >> Mit besten Gr=FC=DFen, Reindl Harald > >> the lounge interactive design GmbH > >> A-1060 Vienna, Hofm=FChlgasse 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 > Mit besten Gr=FC=DFen, Reindl Harald > the lounge interactive design GmbH > A-1060 Vienna, Hofm=FChlgasse 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 Mit besten Gr=FC=DFen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofm=FChlgasse 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 --------------enig3C2A2A123BC7BB218597EF02 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk6Ep/QACgkQhmBjz394AnkQSACeKp93ypqbM85N5eiyBUeLqaUi ibMAoIjl9oUYkud4w4akDS40Y2mHc/R1 =1csA -----END PGP SIGNATURE----- --------------enig3C2A2A123BC7BB218597EF02--