tiredofcareer
Joined 13 years ago
Joined 13 years ago
Yeah, I spent this entire thread clueless about the issue you're running into, even though you spelled it out a few different times because you think I don't get it. Wordpress falls over under normal site load, film at eleven.
Since you want to switch to condescension, I'm assuming wise sir moved MySQL's tmpdir to a RAM disk and found that unsatisfactory for his mystical, MySQL-breaking SELECT/INSERT workload? Also, I'm far more expensive, and I know that WPEngine is multitenancy Wordpress on Linode in the backend. (That one's free.)
I completely understand how this could be a problem and how switching providers would fix it.
set beresp.ttl = 30s;
Varnish gives you your own throttle for how often you want invalidation. It's a tool specifically designed to make misbehaving apps -- i.e., that widget -- misbehave. You just have to slap the dog on the nose when it behaves. I'm just saying you could have made this work on Linode (and I have), but I do see your post-purchase rationalization at work, so I know anything I say will be fruitless anyway.There's also the possibility that you had shitty neighbors.
WP Supercache is a hack anyway, for folks running WP on shared hosts without root. If you have root, there's a plethora of better things for caching, even as ancient as Squid as a reverse. You can get your MySQL traffic down to <1 QPS fairly trivially, no matter what kind of traffic is hitting the frontend.
Don't forget wordpress.com is a huge MU installation, and they've existed since before SSDs became popular. The disk is not your issue here.
wp_supercache, nginx, varnish, etc. Rinse and repeat.
The answer is, very clearly, absolutely not on all accounts. Hacker News does not tolerate dissenting opinion and that should scare you. The continued existence of this community and any contribution is plainly pointless, and while I'd invest a little time demonstrating that to you, I know that nobody will listen, I'll turn light gray, and this community will go back to having a grand old time patting themselves on the back throwing money at a Florida teenager they have never, and will never, meet nor hear about ever again.
One of the (many) problems in our discourse today is that there is no middle. No compromise. Ever. Look at American politics for an example. Even in this discussion here, there was no possible suggestion that I might be a little right, no possible seeking of an understanding, no middle ground. You either think this girl deserves our showering of praise and affection or you suffer the consequences and get grayed to nonexistence.
No, nitrogen. I'm done. You guys can have your polarized, pointless discussion, and I will go back to keeping my opinions to myself. Just like I'm pretty much done with this industry, as well, because it seems like the number of intolerable people that I have to spend nine to five arguing with, over pointless shit like this, continues to multiply until I don't want to listen any more.
I started this account when a good guy, Jesse Noller, had has life threatened by the very people in this industry for daring to intervene in the PyCon situation. I hoped that maybe, just maybe, I could effect some change and get people to see that there is a middle, there is a compromise, there is an opportunity for discussion. When I follow the community, I am rewarded with heaps of karma -- including one comment with dozens of upvotes for saying what HN wants to hear. When I dare speak against the community, as I have here, I am reminded why I keep my distance and why those of us who think rationally consider this community a heaping pile of arrogant shit. You should hear what people outside HN say about it, based on discussions like this. Congratulations, HN. You're now Slashdot. You're now the community that in a single thread compared a teenager that built a bomb in a two-liter bottle to Alfred Nobel and Marie Curie.
In the hours since you left this question for me, I went to see a film and forgot about Hacker News for four hours, and it was four glorious, wonderful hours I intend to repeat. Continuously, for the rest of my days.
So, no, this is not an anti-science campaign by the government, regardless of how really hard we want to believe that she's aspiring to science. These things will blind you and take limbs off if you mishandle them. They have blown up on police officers after being left in an alley because they didn't detonate when kids make them. Then they just leave them for other people to clean up.
Even if you buy the science experiment angle, which she herself went back on, this is a safety issue from the completely reckless way in which she performed a "science experiment", similar to detonating a pipe bomb on school property just to see what happens. Oh, how the narrative would be different if she had built a pipe bomb instead.
Honestly, guys, we have this one wrong. Here's several other cases for your consideration, showing how big this problem is (the reason arrests are picking up is because LEOs are communicating about this, now that kids are starting to do it more):
http://www.mlive.com/news/detroit/index.ssf/2013/04/grosse_p...
http://abclocal.go.com/wpvi/story?section=news/local&id=... (from TODAY)
http://www.ktvb.com/news/crime/Five-more-plastic-bottle-expl...
http://www.kboi2.com/news/local/Police-warn-about-plastic-bo...
http://www.ktvu.com/news/news/bottle-bomb-warning-goes-out-t...
This is a serious problem, not an opportunity to "win another scientist," and the narrative around this case has been disgusting. Reckless behavior and endangering yourself and others intentionally is not the hallmark of a scientist, no matter how much you want the science angle to be true.
> But officers did arrest a group of teenagers at the end of January for making and setting off Drano bombs in an open space off Palmer Drive.
Let me be clear: mishandling one of these devices can blind you and remove limbs, and even if you buy the "I'm doing a science experiment" angle, she's doing it without training or safety considerations. This is a safety issue, not a science-hating issue, and there have been many charged and convicted before this young lady. I hate that we absolutely cannot have an objective conversation about this.
[1]: http://www.ktvu.com/news/news/bottle-bomb-warning-goes-out-t...
Or perhaps I could study the inhalant properties of anthrax powder at my desk at work, because I have no malicious intent and just want 'see what happens'?
There's a difference between science and doing something reckless that could, theoretically, endanger others without scientific safeguards in place. Public commentary on this issue is completely ignoring that.
How do you respond? "Let's ignore each other." So now I'm left wondering if you genuinely don't know how to scale MySQL, and you've tired yourself of appealing to your own authority in order to prove me wrong. What I'm telling you, is the notion that your blog network creating a workload for MySQL that it is incapable of operating on commodity disk is completely ridiculous, and I'd laugh you out of an interview if I pressed you like this. I think you gave up, but I wasn't saying it, but now that you've gone at me like this, I will. You're basically saying you couldn't make MySQL work with a <50QPS write load (I refuse to believe you're writing more than 50QPS to MySQL) because of some TEXT columns.
I'd have far more respect for you if you'd just say, yeah, I probably could make MySQL keep up with my blog workload, I just didn't put much effort into it and bought SSDs on a provider I don't prefer instead.
(But wait: I don't understand. Username oddly appropriate.)
[1]: http://dev.mysql.com/doc/refman/5.0/en/internal-temporary-ta...
[2]: http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html