«
»

SPHINX get recommended by MySQL Performance Blog

CS4 Production Premium

In an recent post famous MySQL Performance blog recommends use of SPHINX for full-text searching. Full-text indexing is one thing that stops most of the people to upgrade to InnoDB storage engine, and leaving MyISAM.
The post is focused on what to do with full-text when going to InnoDB. Several solutions are mentioned like

  • Use MyISAM Slaves: Keep all the tables with full-text on separate slave server and query that slave for full-text
  • Use “Shadow” MyISAM Table: Update myisam table on each update of innodb table by triggers
  • Leave Tables as MyISAM: leave the tables with full-text to myisam and update all other tables to Innodb.
  • Use Sphinx or other external full text search engine

This entry was posted on Sunday, November 1st, 2009 at 6:43 am and is filed under SPHINX. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply