MySQL Tech-Feed (en)
MySQL storage engines
One of the big advantages of MySQL is its concept of pluggable Storage Engines (SE). This means you can choose the most optimal storage engine for your needs. This also has a disadvantage: You have to know what you are doing…
More details you can find here: MySQL pluggable Storage Engines (SE).
Full-Text Search Engines
MySQL has also a Full-Text Search Engine built in. But this Search Engine is not as fast a you probably want to. Thus there are some alternative Full-Text Search Engines which might be working together with MySQL.
- MySQL/MyISAM Full-Text Search
- Sphinx Search
- Lucene
- MnogoSearch
- Solr (based on Lucene)
- Omikron Fact-Finder
- Ioda
- Kneobase (based on Lucene)
- Egothor
- Xapian
More information
Who uses what Full-Text Search Engine …
Stealthy migrating MySQL tables and MySQL data access interfaces using enlarged updateable VIEW functionality
Applications occasionally require redesign. However, redesigning an application cannot be done in one step because the application is distributed or several versions of applications must be supported. MySQL 5.0 provides the necessary means to stealthy migrate your data. In a short overview let’s look at what we plan to do: Stealthy Migration (PDF 98.7 kByte).
Pages
