Ummm... since no one seems to have mentioned this, Use Postgres. Integrated FTS ...

		newt0311 on Oct 9, 2008 \| parent \| context \| favorite \| on: MySQL fulltext search: Ummm... since no one seems to have mentioned this, Use Postgres. Integrated FTS (with the new 8.2 i think versions). Complete transaction support, full ACID support, more obvious behavior and drastically better scaling.