When all you have is a hammer

The biggest difference between 1.5.0 and 1.7.1 is that 1.7.1 uses two databases at once. In order to support fulltext matching, a new feature, we use a MyISAM database in MySQL with FULLTEXT keys (see http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html). However, InnoDB is still faster for JOIN's and offers referential integrity, so as a compromise we run two databases and keep them synchronized with MySQL replication (see http://dev.mysql.com/doc/refman/4.1/en/replication.html).

From the Connotea docs

Leave a Reply

Your email address will not be published. Required fields are marked *