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
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.
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 s
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 M
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
>
>
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
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
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
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 F
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 ne
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 replicat
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
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 searchi
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
14 matches
Mail list logo
