Re: replication between two tables in same database

[Anupam Karmarkar]

Try out functionality you desire with trigger to replicate data




From: Derek Downey 
To: [MySQL] 
Sent: Thursday, 29 September 2011 10:46 PM
Subject: 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.
> 
> 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
>> 
>> 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=sb_akarmar...@yahoo.com

Re: replication between two tables in same database

[Peter Boros]

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.rei...@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.rei...@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.rei...@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
> >> >
> >>
> >> --
> >> MyS

Re: replication between two tables in same database

[Tompkins Neil]

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.rei...@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.rei...@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.rei...@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=mo...@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
>
>

Re: replication between two tables in same database

[Neil Tompkins]

Am thinking now that it might be best to use MySQL 5.6 as this is a new project 
still in development and we will have the new FullText Search with Innodb

On 29 Sep 2011, at 18:43, Andrew Moore  wrote:

> Hey Neil, I read your question too quickly and jumped to the conclusion you 
> weren't sure MyISAM replicates in a mixed storage engine environment. 
> However, you could still potentially replicate the data using standard 
> replication and even on the same server (different instances). 
> 
> InstanceA ---> InstanceB
> MyISAM   InnoDB
> 
> You could use Triggers but be careful if you decide to do that because 
> triggers and replication don't play well together in some circumstances.
> 
> As a side note and something that was already mentioned to you, MySQL are 
> working on 5.6 and as part of that release InnoDB will have it's own 
> implementation of FT indexing.
> 
> HTH 
> 
> Andy
> 
> On Thu, Sep 29, 2011 at 6:00 PM, Tompkins Neil  
> wrote:
> Can you give me any pointers ?
> 
> 
> On Thu, Sep 29, 2011 at 5:59 PM, Andrew Moore  wrote:
> Hey Neil, it sure is possible through standard replication configuration.
> 
> Hth Andy
> 
> On Sep 29, 2011 5:57 PM, "Tompkins Neil"  wrote:
> > 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
> 
> 

Re: replication between two tables in same database

[Neil Tompkins]

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 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 > >> > 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 > >>> >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
>> >>
>> >>
>> >
>> > --
>> >
>> > 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=mo...@fastmail.fm
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: replication between two tables in same database

[mos]

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 mailto:h.rei...@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 mailto:h.rei...@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 mailto:h.rei...@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=mo...@fastmail.fm



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: replication between two tables in same database

[Neil Tompkins]

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 > > 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 >> >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
>> 
>> 
> 
> -- 
> 
> 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=arch...@jab.org

Re: replication between two tables in same database

[Derek Downey]

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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: replication between two tables in same database

[Reindl Harald]

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

-- 

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



signature.asc
Description: OpenPGP digital signature

Re: replication between two tables in same database

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

Re: replication between two tables in same database

[Reindl Harald]

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



signature.asc
Description: OpenPGP digital signature

Re: replication between two tables in same database

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

Re: replication between two tables in same database

[Jim Moseby]

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

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

Re: replication between two tables in same database

[Reindl Harald]

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



signature.asc
Description: OpenPGP digital signature