Wednesday, February 1, 2006
The Developer Search Continues...
I thought I had the perfect candidate to take on development responsibilities here, but he backed out at the last second...ugh.
I shall keep searching. In the meantime I'm in the process of hiring a freelance server guru to fix our speed issues. For reference, here's a quick run-down of what's wrong:
We have two database servers, one server that reads from our database and one server that writes to that database.
To keep in-synch, our read database automatically replicates the content from our write database. However, for some reason, this replication can be delayed for up to five minutes.
Because of this delay, we've been reading a lot of our pages from our write server instead of our read server. Otherwise, when you'd post a comment, for example, it wouldn't appear instantaneously. And that's unacceptable.
As you can guess, because we're doing both read and write queries on our write server, this is putting it under too much strain, slowing things down dramatically (especially on myOtaku, where we read exclusively from the write server).
Thankfully the fix should be easy: Once we get rid of the replication delay, we can allocate more queries to the read server and voila. Everything is golden.