…words "James" and " Peterson", and we should expect the record from Arizona to be towards the top of the list.
With 5.5, this is exactly what happens: mysql: SELECT id, full_name, MATCH(full_name, details) AGAINST ('+james +peterson arizona' IN BOOLEAN MODE) AS score FROM dir_test_myisam ORDER BY 3 DESC LIMIT 5; +--------+------------------------------+--------------------+ | id | full_name | score | +--------+------------------------------+--------------------+ …
@ rbranson : we've got memcache instances in an AZ with no app instances and they can push 100K across fine.
Orders of magnitude : I find framing things in orders of magnitude is a really useful way to measure progress and think about the future. Not much changes structurally if you grow by a factor of two; usually your technical and non-technical infrastructure can handle that kind of growth pretty easily. But when you …of on
…database master is in US-East-1 A, you should not have the corresponding slave in that AZ, but instead have it in B, C, D, or E.
Engine Yard currently provides logic that attempts to spread masters and slaves across availability zones programmatically, but we also allow customers to choose AZ's, and we have found that some customers are investing a single cluster too heavily in the same AZ.
Is your database a single point of failure because you do not currently have a database …
…They are designed to operate independently, but there have been examples where issues in a single AZ impacted resources in different AZs. Data transfer within a single AZ is free while data transfer across AZs (but within the same region) is charged at a discounted Regional transfer rate. Having instances in multiple AZs is a minimal level of availability, but can't be trusted alone.
Looking at the history of AWS outages, they have been isolated to a single …
In the wake of the recent Ryan Lackey offers some practical first responder cloud survival advice: If you're a large site (particularly a ) on and care about availability, you need to have spare capacity in your region (using , like does) to cover when a single AZ disappears, and your own external to AWS load balancing (not based), with your own per-AZ subsidiary load balancers (nginx or whatever) running within …problems
Principles of . Design
Knowledge Fighting diabetis with data .
QotD William Vambenepe :
Thisis so undocumented, it wouldn't last a day in Arizona.
Among all the different technologies in our stack, we also use MySQL. While we still run MySQL (or Percona-Server) ourselves, we selected a managed solution to power parts of our production infrastructure: a Multi-AZ setup with Amazon's RDS.
Judging from my experience with our own setups where EBS is in the mix, I have to say that Amazon does an …
…and gotten fingered in the alley outside Dunkin Donuts?
It's like, I'm 13, scared to use a tampon, and shop at Delia's — at least let me create a decoy screen name and fake fight with my friends over who gets to see a 53 year old in Arizona's "rock hard boner" so that we can laugh about it and then go downstairs for dinner. At least give me that.
It was like improv everywhere with no stakes or twee.
…would you pay an engineer $ 150,000 to answer phones when you could pay someone in Arizona $ 8 an hour?' If you make the engineers answer e-mails and phone calls from the customers, the second or third time they get the same question, they'll actually stop what they're doing and fix the code. Then we don't have those questions anymore.
That's a quote from an interview with Paul English, co-founder of Kayak. At a time when most web companies hire outsourced …