Dear Missus Bin, what have you done to your friends?3.89 / 5.00 1,933 Views
It’s Gideon and Reed’s first escape room and it’s gonna be a blast!3.81 / 5.00 6,706 Views
Old-school parody RPG with an epic plot.3.79 / 5.00 2,195 Views
At 7/31/12 04:42 PM, cryptacet wrote: If you can run an insert query, it's rather obviously NOT a read only database.
It was a hypothetical question, he wasn't talking about a read-only.
Though I did forget about database mirroring somehow; probably because I haven't actually used it.
At 7/31/12 05:31 PM, Chdonga wrote: I've noticed a bug. My inbox says I have one unread message, but there's nothing new there when I look.
That's been around for a while. I've never experienced it myself, but I think the solution is to send or receive a message. As it's an inbox, my money's on receive.
Everything works fine on the site, except the front page.
I still get the message that the site is being maintained, or that's just me?
At 7/31/12 11:37 AM, MikeyS9607 wrote: I don't understand from a programming point of view, like when you use an insert query in MySQL, does the server not pick it up till later?
They're using a cluster of servers for their database, several of them are read-only to speed up random views on "static" content. Normally changes made are replicated immediately however a fault has caused them to lag behind a bit.
Basically the way it works is we have a master database server and a batch of slave servers. The idea is on pages where you only need to read data (especially slower lookups like keyword searches), we use the slave server. These servers are load balanced so if one is busy, it uses a different one, thus keeping page loads nice and efficient.
When we need to add any information, like posting a message, or submitting content, it writes to the primary database. We never directly write data to the slave servers, rather, they use a sort of query queue. When the master database gets a new item added, it adds that query to the slave queue and those all get run in order.
The problems we have been experiencing come from an issue where this queue on the slave servers is falling radically far behind the master. Typically they run immediately, but some of our big automated jobs take a little longer and the slaves fall behind. The site still runs fact because everything is doing what it's supposed to, but new data (such as a newly submitted movie) doesn't exist on the slave server yet, so the submission page throws an error. After a few minutes, the slave catches up and the submission magically works.
Anyway, this latency was something that obviously should not have been happening, so that's why we had the downtime yesterday.
Arch-Angel likes this sig!
At 8/2/12 02:10 PM, PsychoGoldfish wrote: Anyway, this latency was something that obviously should not have been happening, so that's why we had the downtime yesterday.
so the big problem was a few larger things getting moved into the slaves?
hm. What was the fix, simply not allowing people to do anything until the servers caught up, or did you wait and then reboot the machines the DBs were on?
At 8/3/12 12:03 PM, Ectohelix wrote: Crud, I was hoping it was maintenance so projects (I've made a couple I'd like to remove) could be deleted. Ah well...
Well, there was another update recently, so that might count as maintenance.
You know the world's gone crazy when the best rapper's a white guy and the best golfer's a black guy - Chris Rock