HNHacker News
TopNewBestAskShowJobs

AaronBBrown

330 karma · joined May 4, 2012

submissionscomments
AaronBBrown··on Surviving under water in an air bubble
The insides of submarines are at roughly 1 BAR. Unless there is a breach of the integrity of the submarine and you manage to stay in a compressed air pocket for a sustained amount of time (unlikely, at best) prior to ascent, you will not have gas disolved into your tissues and thus won't get bent.
AaronBBrown··on Relative Line Numbers in Vim
Also :<line> will do that.
AaronBBrown··on Wikipedia Adopts MariaDB
...after he made wheelbarrows full of money from the Sun purchase.
AaronBBrown··on Wikipedia Adopts MariaDB
MariaDB basically exists because of Monty's hatred for Oracle (which bought Sun after Sun bought MySQL for wheelbarrows full of money from Monty). It won't happen.
AaronBBrown··on The Day the Replication Died
Because MySQL replication is simple, mature, and has a rich toolset, it is usually easy to recover from most replication problems. The Percona Toolkit (formerly Maatkit) has two tools that make this fairly painless - pt-table-checksum and pt-table-sync. The former checks for consistency using MySQLs built-in checksumming abilities and the latter repairs found inconsistencies.

Another useful tool is pt-slave-restart which will limp you along and skip replication errors automatically until you can repair the problem.

AaronBBrown··on Why Use Nginx?
As can haproxy or any other L7 load balancer.
AaronBBrown··on Why Use Nginx?
SNI has the problem that it's not supported on all browsers or operating systems, so even if it worked without configuration it doesn't solve the problem for most use cases. Assuming multiple subdomains on the same domain the only viable alternative to multiple IPs is to use a wildcard certificate.
AaronBBrown··on Today's Email Incident
https://yourlogicalfallacyis.com/slippery-slope
AaronBBrown··on The Fireplace Delusion
I live in an area of the US where the temperature ranges from approximately -15F to 32F for 3 months of the year. Heat pumps are not particularly efficient in those temperature ranges. In more mild climates, heat pumps are great. It's just not a panacea.
AaronBBrown··on This Man Thinks He Never Has to Eat Again
If it were possible to remain healthy long term, I'd totally sign up for a pill or drink that took a minute or two to consume and contained everything that we need to survive. I might not do it every day because there are some foods that I really like, but generally I don't enjoy eating and find it irritating that I have to spend so much of my life doing it.
AaronBBrown··on The Fireplace Delusion
How go you propose that an individual heat their house if not with gas, propane, oil, or wood? Electric heat, except in the case of perhaps a space heater, is extremely inefficient (and in most cases the electricity itself is made by burning fossil fuels). Unless there have been some dramatic technological improvements recently, solar and geothermal heating are not practical in the northern US where temps can drop well below zero Fahrenheit. Of these options, I'm pretty sure that gas and propane have the lowest environmental impact.
AaronBBrown··on Antibiotic resistance 'a time-bomb'
I had a "minor" bought with MRSA a few years back that put me in the hospital for 2 days. Several weeks after getting a tiny little scratch near my elbow my entire forearm swelled up a couple inches. I went through several oral antibiotic treatments before they had to stick me in the hospital to give me the crazy IV stuff. The one that ended up solving the infection was vancomycin, which has been historically the "drug of last resort." During that little incident, I developed an allergy to two different antibiotics, so on top of bacterial resistance, now I have to be concerned with my own body's inability to deal with particular antibiotics.

Also, let me tell you, IV Benadryl is some good shit...

AaronBBrown··on Unix tricks
I'm the opposite. Every time I log into a server that doesn't have my bashrc, I immediately have to `set -o vi` or else I'm useless.
AaronBBrown··on How Balanced Does Database Migrations With Zero Downtime
Yes.
AaronBBrown··on How Balanced Does Database Migrations With Zero Downtime
I use nginx + haproxy and use haproxy for the load balancing piece, too. haproxy simply has much more visibility into the queue. I'm not aware of anything built into nginx that is as robust as the logging and stats page from haproxy. This makes horizontal scaling decisions infinitely easier.
AaronBBrown··on How Balanced Does Database Migrations With Zero Downtime
This isn't zero downtime. It's still 15s of downtime (which is really a trivial amount of time for a migration). As a user, I would rather see a maintenance page up than have my connections stall out and have me staring at a blank page.
AaronBBrown··on How I spend my first 5 minutes on a server
I'm not that familiar with Fabric, so maybe it can do some of the things I mention here out of the box without a lot of custom code. I'm only familiar with Capistrano and I associate them in my head, perhaps naively.

Your example is great to illustrate why configuration management is so powerful.

Most importantly, your example will upgrade the package to the latest version every time you run it (which is probably not what you intended, but maybe it is). I'm sure there is an idempotent command for each of apt, yum, ports, homebrew, etc, but I have better things to do with my time than figure that all out.

In puppet your command would be:

    package { 'foo': ensure => installed }  # or 'latest'
What if you also have RedHat servers? Now you need to figure out the right yum command to use to perform the equivalent. Or your developers Macs? Homebrew. Chef/Puppet are aware of the environment they run in and install appropriate packages using the appropriate package management script with minimal alteration to the underlying recipe.

For RedHat systems, it would be:

    package {'foo' : ensure => installed }
On a Mac, it would be:

    package {'foo' : ensure => installed }
On that Arch Linux machine that your devs are running, it would be:

    package {'foo' : ensure => installed }
Now, let's throw some dynamism into the mix...

What if you want to build an haproxy configuration file that pulls the list of hosts from an authoritative source? Do you "just" build it up from scratch every time and replace the file on every run of your script? With chef/puppet, you can pull that information in from your node classifier using the same query for dev, staging, and production and have the same recipe work for multiple environments. In some environments, the haproxy config has now changed, so I want to tell haproxy to reload. But in other environments, the config stayed the same, so I don't want it to reload. The file and service don't get touched if they didn't change.

What if a service has multiple files associated with it that when one or multiple of them change, you have to restart or reload the service? You don't want to restart each service every time one of the multiple files changes, so you end up having to build a queue to handle the service notifications.

Say I've got a few dozen users on my hosts and someone leaves. Which is easier - writing a purge script which knows how to purge the user from all environments that you support, or this...

    user { 'joe' : 
      ...
      ensure => absent
      ...
    }
I'm certain that that you can do these things with fabric scripts, but by the time you have, you've either written your own configuration management tool (which is unlikely to be as robust as chef or puppet) or you have a hodgepodge of unmaintainable scripts.
AaronBBrown··on James while John had had had ... had had had a better effect on the teacher
During an English class in High School, my teacher (we'll call him Mr. Jones) came into the classroom and saw the following written on the blackboard.

    YOU SUCK JONES
Mr. Jones proceeded to make this into a lesson about the importance of commas.

    YOU SUCK, JONES
and

    YOU, SUCK JONES
have wildly different meanings.
AaronBBrown··on What Thomas Edison expected job candidates to know
Really? You think the voltage on a street car and the wood that kerosene barrels is made of is common knowledge? I would say that I knew maybe 1/3rd of the questions in that list.
AaronBBrown··on Why We Still Believe in Working Remotely
Recommendations for a good wireless headset that has decent range?
AaronBBrown··on Why We Still Believe in Working Remotely
Another downside is that I have completely lost perspective on how long it takes me to "get ready" to go outside the house if I have to be somewhere early in the morning. My routine is that I get up, feed the kids, eat breakfast, read the Interwebs, check up on the night's disasters at work, then move upstairs to my office. I often don't get myself groomed until lunchtime or so.

To those that I work with...don't worry. I always wear pants. But don't expect me to want to video chat with you too early in the morning. :)

AaronBBrown··on Why We Still Believe in Working Remotely
Here's my big secret about remote working...

I sit at my desk a lot less, but work a lot more. I'm one of those people that simply cannot solve complex problems while sitting at a desk. Because I'm not beholden to butt-in-the-chair syndrome, I am free to spend an hour or more going for a walk, visiting a local coffee shop, or taking a bath so I can think and problem solve before typing into a console. As a result, my work takes less time and requires fewer revisions than when I was sitting in a chair at an office.

The down side...I'm always at work. In order to create the separation I have to make sure to leave the laptop upstairs in the office or else I'll just keep working at the kitchen counter.

AaronBBrown··on A Short Rant About Working Remotely
This... x10. Having worked remotely from 2000-2002 and also 2010 to the present, I don't know how anyone can make an accurate statement about remote working in 2013 based on a study from 2006.
AaronBBrown··on A Short Rant About Working Remotely
Having worked nearly half my career as a remote employee, I find Skype mostly eliminates this problem...

Onsite Employee: "Hey, got a second?" Me: "Yep" Video chat commences

It's a horrible work habit to get into to interrupt someone like that, but sometimes it's necessary. Plus, sometimes it's nice to just chitchat with your coworkers, just like you would in an office setting.

The bottom line is, I'm good at my job and if you're not willing to let me work remotely, you are welcome to discriminate based on geographic presence and eliminate 90% of qualified employees and I'll just go work for the increasing number of enlightened companies that have figured that they can get better talent by making telecommuting a reasonable option. Not all awesome engineers live within a commutable distance to a major metropolitan hub.

AaronBBrown··on Why Should You Use MySQL?
I suppose that depends on your definition of "database." This argument is very close to the No True Scotsman fallacy. Nowhere in the definition of "database" does it say that it won't default to truncating your data when you try to stuff it into a field that is too small. MongoDB, Riak, VoltDB, PostgreSQL, and CouchBase are all "databases" and they all have varying levels of strictness.

"it's the wrong tool" is an opinion and it is unsupported by history. It many cases, it's exactly the right tool and users are given the power to control the level of strictness they they require. Want to allow GROUP BYs that don't include all non-aggregate columns? Sure, you can do that. Or not. Want MySQL to accept what you give it and throw warnings instead of errors? Yep, you can do that, too. Or not.

The defaults are bad. No one will defend that. They are also easy to change. A privilege level allowing/denying the ability to change the sql_mode would be a welcome addition, also. Yet, MySQL is a capable tool that does some things really well, something things not so well, and some things terribly. Just like every other product out there. It is a tool. It works well for many, but not all cases. Apparently, you find it inadequate for your particular needs. I get that. You shouldn't use it.

AaronBBrown··on Why Should You Use MySQL?

  SET sql_mode = 'STRICT_ALL_TABLES';
http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#...

Yes, it's not default. Yes, it can be overridden. Yes, that bothers a lot of people.

AaronBBrown··on Why Should You Use MySQL?
RDS isn't really that great as a scaling strategy. It's only marginally easier to keep running than your own dedicated MySQL instances and it's far less flexible, particularly for disaster recovery since there is no way to do cross-region replication.
AaronBBrown··on Why Should You Use MySQL?
Yes...this.

Another thing that is often overlooked is tiered slaves in conjunction with logical replication for adding OLAP to an OLTP infrastructure. This allows you to have additional reporting data on slaves that is not present on the master and along with real-time replication, eliminating or simplifying nightly batch processing. This also allows you to keep a very small working set available on the master database with slaves that contain the full archive. In conjunction with BLACKHOLE tables, this can be very powerful.

AaronBBrown··on MySQL - Do Not Pass This Way Again
Can you provide some citations to this claim? I know a lot of people who understand ACID, Foreign Keys, and have experience with other DBs (like PostgreSQL) and still often choose MySQL based on its merits.
AaronBBrown··on MySQL - Do Not Pass This Way Again
I agree that the MariaDB and Percona Server versions of MySQL are far superior in many ways, but Oracle, with 5.6 has proved their commitment to MySQL with some awesome new features. I admit there has been a reduction in transparency with the test cases fiasco, but beyond FUD, what is it that they "can't be trusted with?" Are you concerned that they are in there secretly making a bittorrent out of your database or something?
← PreviousPage 3 of 5Next →