Try out functionality you desire with trigger to replicate data
From: Derek Downey de...@orange-pants.com
To: [MySQL] mysql@lists.mysql.com
Sent: Thursday, 29 September 2011 10:46 PM
Subject: Re: replication between two tables in same database
You could look
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
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
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
Sounds like a job for CREATE TRIGGER to me. :)
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
Tompkins Neil neil.tompk...@googlemail.com 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
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.netwrote:
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
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
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
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
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 h.rei...@thelounge.net wrote:
so mysql is currently the wrong database for your project
sad but true, you can not
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
I'm not sure it would work in my environment of IIS and MySQL ?
On 29 Sep 2011, at 20:10, mos mo...@fastmail.fm 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.
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 eroomy...@gmail.com wrote:
Hey Neil, I read your question too quickly and jumped to the conclusion
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 mo...@fastmail.fm wrote:
Derek is right. The Sphynx search engine is much faster than MyISAM's full
text search engine. It will work on
14 matches
Mail list logo