Search replication failing - disheartened

[WotC_Mel]

Hi,

I'm an admin for a large forum running 3.06 (patched for 3.07 security) and we have had to disable search. The vbulletin search grinds us to a halt and the full text is not cutting it either.

We have attempted to replicate the post table on a second server and have search run there to avoid the performance hit to the rest of the boards. The issue is that after two days of reasonable results, the post table corrupts and replication fails. This has now happened four different times. We had hoped this last time might work since MySQLs last release addressed some replication issues. (which is also why I am posting this here.)

So, is there anyone out there who is able to get replication running smoothly? Or is there another answer for search? At this point I am dispairing that we should attempt to move to Lithium forums which seems to be the only enterprise level solution that has workable search.

I will try to answer any questions about the set up, but may need to drag in my tech who can get specific.

-Mel