Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text



#1: Replicating FullText

Posted on 2007-06-10 00:22:59 by Roger Felstree


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!

Report this message