Why not just use two tables -- one InnoDB and one MyISAM -- and write/update/delete both tables simultaneously? Twice the performance hit, but it seems like a viable solution.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rob Marscher Sent: Thursday, November 30, 2006 12:07 PM To: MySQL SIG Subject: Re: [mysql] InnoDB and FULLTEXT I remember reading something about where you have two copies of a table... one is InnoDB where you do all of your write operations and stuff like that and then the other is MyISAM so that you can do fulltext searches to it. I can't remember how they got that to work... It may have been by having two database servers and using replication to get the data from the InnoDB master table into the MyISAM table. I don't know much about this... but it looks interesting... says that it supports InnoDB tables: <http://www.sphinxsearch.com/features.html> Also in my Google searching, I saw some rumors of FULLTEXT coming for other storage engines in a future version of mysql: <http://dev.mysql.com/doc/refman/5.0/en/faqs-mysql-cluster.html#qandaite m-26-10-17> -Rob Brian Dailey wrote: > Hey guys... let me start by describing what I need to do; maybe one of > you guys have been confronted with this before and have already come > up with an equitable solution. > > I need to be able to do a 'fuzzy search' on names to check for > existing records on a name, accounting for mispelled names, etc. > > The FULLTEXT index would work, probably, but it won't with an InnoDB > setup. Is there an alternative to this that I can use, or am I SOL? > > Thanks, > - b. > _______________________________________________ > New York PHP Community MySQL SIG > http://lists.nyphp.org/mailman/listinfo/mysql > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php > _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
