Replicating FullText

Replicating FullText

am 10.06.2007 00:22:59 von Roger Felstree

Hi,

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!