replication between two tables in same database

--20cf307ca576543ba804ae1765d3
Content-Type: text/plain; charset=ISO-8859-1

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 on
the MyISAM table. Is this possible ? If so how do I do it.

Thanks
Neil

--20cf307ca576543ba804ae1765d3--

Re: replication between two tables in same database

--------------enig110EE392C71C7BB16B152146
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 29.09.2011 18:56, schrieb Tompkins Neil:
> Hi
>=20
> I've a Innodb and MyISAM table in the SAME database that I wish to repl=
icate
> 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-sear=
ch?
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 and copy
the table-contents per cronjob


--------------enig110EE392C71C7BB16B152146
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/

iEYEARECAAYFAk6EpFsACgkQhmBjz394Ank7sQCfXnas9NcgAZBInhdMB878 JAJ1
quAAn3SWV6FIWP9ofZftZPV3ZkelcxNz
=P2Bg
-----END PGP SIGNATURE-----

--------------enig110EE392C71C7BB16B152146--

Re: replication between two tables in same database

--=__Part3B14FC3C.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable


Sounds like a job for CREATE TRIGGER to me. :)
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
=20
=20

>>> Tompkins Neil 9/29/2011 12:56 PM >>>
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 on
the MyISAM table. Is this possible ? If so how do I do it.

Thanks
Neil

CONFIDENTIALITY NOTICE: This message is directed to and is for the use of =
the above-noted addressee only, and its contents may be legally privileged =
or confidential. If the reader of this message is not the intended =
recipient, you are hereby notified that any distribution, dissemination, =
or copy of this message is strictly prohibited. If you have received this =
message in error, please delete it immediately and notify the sender. =
This message is not intended to be an electronic signature nor to =
constitute an agreement of any kind under applicable law unless otherwise =
expressly indicated herein.

--=__Part3B14FC3C.1__=--

Re: replication between two tables in same database

--20cf307d00d0e53afe04ae178969
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 wrot=
e:

> 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 searching whi=
ch Innodb
> does not support.
>
>
> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald wr=
ote:
>
>>
>>
>> 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 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 and copy
>> the table-contents per cronjob
>>
>>
>
> --
>
> Mit besten Grüßen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 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
>
>

--20cf307d00d0e53afe04ae178969--

Re: replication between two tables in same database

--------------enigFD6007D3A1074E0F81287897
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 table=
s.
>=20
> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald =
wrote:
>=20
>> 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 sh=
ort
>> however, we need a couple of the tables to support FULLTEXT searching =
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 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 and copy=

>>> the table-contents per cronjob
>>>
>>>
>>
>> --
>>
>> Mit besten Grüßen, Reindl Harald
>> the lounge interactive design GmbH
>> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 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


--------------enigFD6007D3A1074E0F81287897
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/

iEYEARECAAYFAk6EpyAACgkQhmBjz394AnmLZACdHxLCdxOrZdIPXcJRUJ6F akMn
e/AAoIuFopmp6GYiK+fLAddaYlRaVWum
=EGoi
-----END PGP SIGNATURE-----

--------------enigFD6007D3A1074E0F81287897--

Re: replication between two tables in same database

--20cf307d00d0a9248204ae17a668
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 wrot=
e:

> 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 table=
s.
> >
> > 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 searching
> 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 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 and copy
> >>> the table-contents per cronjob
> >>>
> >>>
> >>
> >> --
> >>
> >> Mit besten Grüßen, Reindl Harald
> >> the lounge interactive design GmbH
> >> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 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
>
>

--20cf307d00d0a9248204ae17a668--

Re: replication between two tables in same database

--------------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 e.net >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 ge.net >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üßen, Reindl Harald
> >> the lounge interactive design GmbH
> >> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 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/QACgkQhmBjz394AnkQSACeKp93ypqbM85N5eiyBUeL qaUi
ibMAoIjl9oUYkud4w4akDS40Y2mHc/R1
=1csA
-----END PGP SIGNATURE-----

--------------enig3C2A2A123BC7BB218597EF02--

Re: replication between two tables in same database

You could look into the sphinx engine =
http://sphinxsearch.com/about/sphinx/

No experience with this personally though

- Derek
On Sep 29, 2011, at 1:07 PM, Tompkins Neil wrote:

> Yes, unless I can set-up some sort of replication between the two =
tables.
>=20
> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald =
wrote:
>=20
>> please do NOT post off-list!
>>=20
>> so your only workaround is like '%whatever%' currently
>>=20
>> 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 searching =
which Innodb
>> does not support.
>>=20
>>=20
>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald =
wrote:
>>=20
>>>=20
>>>=20
>>> Am 29.09.2011 18:56, schrieb Tompkins Neil:
>>>> Hi
>>>>=20
>>>> 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 =
on
>>>> the MyISAM table. Is this possible ? If so how do I do it.
>>>=20
>>> in short: no
>>>=20
>>> 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
>>>=20
>>> 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 and =
copy
>>> the table-contents per cronjob
>>>=20
>>>=20
>>=20
>> --
>>=20
>> Mit besten Grüßen, Reindl Harald
>> the lounge interactive design GmbH
>> A-1060 Vienna, Hofmühlgasse 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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: replication between two tables in same database

But I could create an additional myisam table to overcome my problem providi=
ng 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
>=20
> Am 29.09.2011 19:15, schrieb Tompkins Neil:
>> We've succesfully used FULLTEXT searching on another application that doe=
s not need Innodb tables. In addition for
>> the FULLTEXT searching we use things like "IN BOOLEAN MODE" as well - so f=
or our project Like %% is not enough.
>>=20
>> On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald ailto:h.reindl@thelounge.net>> 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=
..
>>>=20
>>> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald mailto:h.reindl@thelounge.net>>wrote:
>>>=20
>>>> please do NOT post off-list!
>>>>=20
>>>> so your only workaround is like '%whatever%' currently
>>>>=20
>>>> Am 29.09.2011 19:04, schrieb Tompkins Neil:
>>>> The reason I'm using Innodb is because the usage of foreign keys in sho=
rt
>>>> however, we need a couple of the tables to support FULLTEXT searching w=
hich Innodb
>>>> does not support.
>>>>=20
>>>>=20
>>>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald mailto:h.reindl@thelounge.net>>wrote:
>>>>=20
>>>>>=20
>>>>>=20
>>>>> Am 29.09.2011 18:56, schrieb Tompkins Neil:
>>>>>> Hi
>>>>>>=20
>>>>>> 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 on
>>>>>> the MyISAM table. Is this possible ? If so how do I do it.
>>>>>=20
>>>>> in short: no
>>>>>=20
>>>>> 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
>>>>>=20
>>>>> replication is based on binlogs and contains database/table so there i=
s
>>>>> no dirty trick do this on one server except let run a script and copy
>>>>> the table-contents per cronjob
>>>>>=20
>>>>>=20
>>>>=20
>>>> --
>>>>=20
>>>> Mit besten Grüßen, Reindl Harald
>>>> the lounge interactive design GmbH
>>>> A-1060 Vienna, Hofmühlgasse 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
>>>=20
>>=20
>> --
>>=20
>> Mit besten Grüßen, Reindl Harald
>> the lounge interactive design GmbH
>> A-1060 Vienna, Hofmühlgasse 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
> --=20
>=20
> Mit besten Grüßen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: replication between two tables in same database

Derek is right. The Sphynx search engine is much=20
faster than MyISAM's full text search engine. It=20
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=20
>overcome my problem providing I can get the data=20
>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=20
> another application that does not need Innodb tables. In addition for
> >> the FULLTEXT searching we use things like=20
> "IN BOOLEAN MODE" as well - so for our project Like %% is not enough.
> >>
> >> On Thu, Sep 29, 2011 at 6:13 PM, Reindl=20
> 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=
tables.
> >>>
> >>> On Thu, Sep 29, 2011 at 6:05 PM, Reindl=20
> 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=20
> usage of foreign keys in short
> >>>> however, we need a couple of the tables to=20
> support FULLTEXT searching which Innodb
> >>>> does not support.
> >>>>
> >>>>
> >>>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl=20
> 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=
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 and=
copy
> >>>>> the table-contents per cronjob
> >>>>>
> >>>>>
> >>>>
> >>>> --
> >>>>
> >>>> Mit besten Grüßen, Reindl Harald
> >>>> the lounge interactive design GmbH
> >>>> A-1060 Vienna, Hofmühlgasse 17
> >>>> CTO / software-development / cms-solutions
> >>>> p: +43 (1) 595 3999 33=20
> , m: +43 (676) 40 221 40
> >>
> >>>> icq: 154546673, http://www.thelounge.net/
> >>>> http://www.thelounge.net/signature.asc.what.htm
> >>>>
> >>>>
> >>>
> >>
> >> --
> >>
> >> Mit besten Grüßen, Reindl Harald
> >> the lounge interactive design GmbH
> >> A-1060 Vienna, Hofmühlgasse 17
> >> CTO / software-development / cms-solutions
> >> p: +43 (1) 595 3999 33=20
> , m: +43 (676) 40 221 40
> >>
> >> icq: 154546673, http://www.thelounge.net/
> >>
> >> http://www.thelounge.net/signature.asc.what.htm
> >>
> >>
> >
> > --
> >
> > Mit besten Grüßen, Reindl Harald
> > the lounge interactive design GmbH
> > A-1060 Vienna, Hofmühlgasse 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: replication between two tables in same database

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 t >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 et >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üßen, Reindl Harald
>> >>>> the lounge interactive design GmbH
>> >>>> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
>> >> the lounge interactive design GmbH
>> >> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
>> > the lounge interactive design GmbH
>> > A-1060 Vienna, Hofmühlgasse 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@fastmail.fm=

>=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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: replication between two tables in same database

--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 om> 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--

Re: replication between two tables in same database

--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 t >> h.reindl@thelounge.net**>> 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@thelounge.net >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@thelounge.net >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üßen, Reindl Harald
>> >>>> the lounge interactive design GmbH
>> >>>> A-1060 Vienna, Hofmühlgasse 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 nge.net/signature.asc.what.htm>
>> >>>>
>> >>>>
>> >>>
>> >>
>> >> --
>> >>
>> >> Mit besten Grüßen, Reindl Harald
>> >> the lounge interactive design GmbH
>> >> A-1060 Vienna, Hofmühlgasse 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 unge.net/signature.asc.what.htm>
>> >>
>> >>
>> >
>> > --
>> >
>> > Mit besten Grüßen, Reindl Harald
>> > the lounge interactive design GmbH
>> > A-1060 Vienna, Hofmühlgasse 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 ..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 ail.com>
>
>

--20cf307c9f38ee773704ae1b9e9f--

Re: replication between two tables in same database

You can do this by initially copying the table and setting up triggers
to refresh new data. Looks like you are not looking for replication, but
you are calling it replication. Having 2 tables in a database with the
same content and different indexes/storage engines/partitioning is
totally possible. For the fulltext problem, sphinx is the better
solution.

Peter

On Thu, 2011-09-29 at 22:59 +0100, Tompkins Neil wrote:
> I've now just upgraded to MySQL 5.6 on our test server. Just trying to find
> 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 full
> > 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@thelounge.net**>> 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@thelounge.net >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 searching
> >> which Innodb
> >> >>>> does not support.
> >> >>>>
> >> >>>>
> >> >>>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald <
> >> h.reindl@thelounge.net >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
> >> 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 and
> >> copy
> >> >>>>> the table-contents per cronjob
> >> >>>>>
> >> >>>>>
> >> >>>>
> >> >>>> --
> >> >>>>
> >> >>>> Mit besten Grüßen, Reindl Harald
> >> >>>> the lounge interactive design GmbH
> >> >>>> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
> >> >> the lounge interactive design GmbH
> >> >> A-1060 Vienna, Hofmühlgasse 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üßen, Reindl Harald
> >> > the lounge interactive design GmbH
> >> > A-1060 Vienna, Hofmühlgasse 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=mos99@fastmail.fm
> >>
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?**unsub=neil.tompkins@**
> > googlemail.com
> >
> >



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: replication between two tables in same database

--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 =
________________________________=0AFrom: Derek Downey om>=0ATo: [MySQL] =0ASent: Thursday, 29 September 20=
11 10:46 PM=0ASubject: Re: replication between two tables in same database=
You could look into the sphinx engine http://sphinxsearch.com/about/s=
phinx/ No experience with this personally though - Derek=0AOn Sep=
29, 2011, at 1:07 PM, Tompkins Neil wrote: > 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üßen, Reindl Harald=0A>> the lounge interactive desi=
gn GmbH=0A>> A-1060 Vienna, Hofmühlgasse 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--=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@yahoo.com
--1396951373-268822932-1317622810=:21633--