Question EarlierPost query for slave?

[janslu]

I'm still working on the sphinxsearch issue (and it doesn't look good). But I've spent a lot of time looking at mytop and one thing caught my attention - there's a lot of

					SELECT COUNT(*) AS earlierPosts FROM post AS post WHERE post.threadid = xxx AND post.visible = 1 AND post.dateline = yyy;

queries being done on the primary database server. Is it possible to direct them towards the slave server in master & slave configurations?

 

[Fillip H.]

I've made relevant changes to make all DBSEO queries run on the slave server instead. That being said, there are a few modify queries, so you will need to make sure your slave server isn't set to read-only.

 

[janslu]

Cool. I suppose all modify queries are of temporal type? I make backups of the master server and in case of a crash I would only restore master database.

 

[Fillip H.]

The modify queries all deal with the Spider Log, so if that feature is unimportant then nothing of relevance will be lost if you restore the master DB before the slave has had a chance to propagate the changes.