Replicating FullText

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I'm using MySQL v5.0 and we currently have a database containing several
tables with Full Text indexes. Some of these tables contain ~800,000 records
of >500Kb text. While the majority of queries are selects - when we need to
do Inserts to these tables they are becoming horrendously slow.

If I set up an additional server - is it possible to set up a replication
partnership so that the fulltext index is only present on the slave? i.e.
updates are carried out on the master with no fulltext index - and then
replicated to the slave with the fulltext index for end users to query?

Any advice / pointers would be much appreciated!

Site Timeline