469,599 Members | 2,857 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,599 developers. It's quick & easy.

Replicating FullText

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!

Jun 9 '07 #1
0 2000

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Phil Powell | last post: by
reply views Thread by Wesley Hobbie | last post: by
reply views Thread by Ralph Guzman | last post: by
reply views Thread by Matt W | last post: by
reply views Thread by Phil Powell | last post: by
reply views Thread by Alex Glass | last post: by
reply views Thread by Robert Oschler | last post: by
1 post views Thread by Robert Oschler | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.