This post originated from an RSS feed registered with Java Buzz
by Nick Lothian.
Original Post: When all you have is a hammer
Feed Title: BadMagicNumber
Feed URL: http://feeds.feedburner.com/Badmagicnumber
Feed Description: Java, Development and Me
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).