Quote:
Originally posted by Lensman
The GFY search saga continues. The issue is that allowing searches of 5 million posts on a live database basically kills the performance of the board. So we created a replication server to do it on, but the search table keeps getting corrupted.
Anyway, we're putting new hardware and software for it in next week. Let's hope this fixes the search issues.
|
If you are having replication problems, try upgrading you version of mysql. Versions < 4.0.20 in particular have a ton of bugs in the native replication features, especially in relation to large tables/data/load.