chucky_z

I've found MySQL to have issues with datasets that don't fit into the innodb buffer pool. Are you doing a lot of partitioning to make everything work well?

If everything is behind an ORM, have you considered trying out PostgreSQL w/ the MySQL FDW? pgsql 10's improvements to FDW's make it a truly viable option.

Also to clarify: I'm just saying this as pgsql seems to handle queries that involve disk access and large datasets much better. I have found that as long as your hot dataset fits into the innodb buffer pool and/or you're doing only key lookups (e.g.: select * from tbl where pk=1;) MySQL is most certainly faster for real-world usage. If you're pulling and sorting/filtering millions (or billions) of rows per query, I find that pgsql stands up extremely well to that. Even in a single huge server setup.

Also a semi-unrelated ditty, but as someone who has to run migrations on pretty big (100m rows) tables, ALTER TABLE LOCK=NONE ALGORITM=INPLACE is pretty great (here's a table of what you can user per-situation https://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-...)

If you made it this far in my comment you'll probably realize I didn't grasp the article well. I just re-read it and tl;dr, MyRocks works well (as expected) with datasets that don't fit into the innodb buffer pool. :)

I just got back from RedisConf and antirez brought up the idea (or that it's already in-development... he was not clear) of releasing an official redis cluster proxy for use with older/less-featured clients.

I believe it was brought up in the keynote (which I missed unfortunately), and also as part of one of the Redis Clients talks.

Excellent article! The use of Lua solves a lot of potential issues here with competing writes to similar spaces for rate limiting, causing potential bizarre errors.

The one thing I would note that doesn't seem to be covered is if you are using a relatively large Lua script and running eval over and over it's getting cached every time, instead `SCRIPT LOAD ...` can be ran, which spits out a sha1 which can then be ran with `EVALSHA (sha1) (keys) (args)`. This can potentially speed stuff up as well as cutting back on memory.

Did you ever attempt to use PyPy? Flask works with it, and in my experience the handful of times I've needed Python to be more performant, PyPy got me there easily.

My use-case was I was doing a heavy part of an ETL pipeline out of MySQL and it was taking an unreasonable amount of time. PyPy was a roughly ~8x speedup, which ended up being faster than doing direct manipulation with MySQL via the cli (!!!).

fdw_cstore! It's a workable columnar store, but honestly if you have "big" data it's only passable. It is much easier to run than other columar stores however.

I don't know TimescaleDB but PipelineDB is more about real time constant aggregation. You can do like a rolling sum that's has many inserts a second for a very long time, and the speed of retrieving the sum and inserts remain pretty constant.

RDS supports some random PL stuff, specifically PL/Perl and PL/v8 it seems.

The documentation is actually quite good!

http://yaml.org/spec/1.2/spec.html

They provide a huge amount of examples, and YAML is actually I think a lot more powerful than most folks realize.

I think it's naive to think you're completely protected just because code isn't supposed to ever run. It seems as though the simplest and safest piece of mind is to use some extra layers of protection ala SELinux.

This won't stop the memory from being accessed, but it has a better chance of stopping things that can exploit the bug(s) in the first place.

Revoking TLS certs is probably a little bit on the side of paranoia.

I think you're on the right track -- just watch for the kernel update, and rotate passwords plus keys if it's not a hassle.

running containers on google compute or ec2 has always been the same.

gke is great, however. if you need to run kubernetes in production, today, i would not even slightly hesitate to yell to the corners of the earth to run gke. it makes me excited for eks!

i would also say that the new c5 instance type w/ ena is extremely nice. if they are unaffected by this, they're probably the fastest cpu-based instances you can get anywhere (admittedly i haven't checked... really anything else, but they're fast).

Not having much of a savings, and moving to the bay area after getting a bay area job with a bay area salary (wow!!), only to realize that you also need to pay for bay area rent (WOW!!!).

If said person has animals, children, or a spouse it becomes even more complicated.

I've personally had different experiences in a professional workspace. I'm currently sitting at a ~15% replacement rate (e.g.: Apple saying they cannot fix it, and giving us a new one) across ~12 touchbar MBP's. We have 2 of the 13" MBP's sans touchbar and they've been relatively trouble free.

That's similar to Macbook Air's, which I despise in the workplace simply because they seem to randomly die much more than other models.

All of our 2012-2015 MBP's are still going very strong. We have not replaced a single one.

Lenovo's tablets are quite solid. I've been using a Lenovo Yoga Tab 2 for a year or two now quite happily.

We're in the process of trying to get a trial for Zoom, as we initially bought in heavily on Google Hangouts and it's proving to be a terrible UX. I know how to use it, and I've shown everyone how to setup meetings, add rooms, etc... several times now, but it never sticks.

I say "trying" to get a trial, as two people from our company have contacted Zoom multiple times, and while the initial contact is great, we just cannot get any followups. It's very frustrating, especially considering that all my dealings with Promevo have been absolutely outstanding.

But didn't it? If you go to any fancy estate you'll see quite a lot of Asian art. Most of it probably produced in/from/inspired by China.

If you're in the bay area go to Filoli and you'll see exactly what I'm talking about. They have hallways full of massive intricately carved blinds. They have huge beautiful rugs, but they are not featured in any way shape or form as much as the other art is.

Is this a surprise? When I think quality tapestries I always think India and Pakistan. India is similar to China in that they both have a rich heritage of wonderful art, and a huge population to carry on that tradition. It's surprising to me that we don't have more goods from India.

I'd be totally fine if we were charged like datacenters. e.g.: pay for a minimum of 10mbps, but burstable to 100mbps, and if you average over 10mbps/mo, pay some fee. It's typically different, but it ends up being a few TB/mo of traffic at the most absolute 'base' plan.

Then you can pay more for "unmetered" 10mbps, 100mbps, 1000mbps, 10000mbps, etc...

There's also plans for "minimum + burst" e.g.: 20mbps->200mbps, 50mbps->300mbps, 100mbps->1000mbps, so on and so forth.

I think this is a perfectly acceptable method of billing and I really wish we could just use this. As, in effect, if you pay for the '100mbps->1000mbps,' this translates too... you get 1000mbps at all times you use the internet, but you get 100mbps/mo worth of bandwidth.

That translates to ~8.75TB/mo of bandwidth or,

  ((100*24*30)/1024)/8

(someone please correct me if I'm very wrong here. I worked at a webhost several years ago and this was basically our pricing model.)

Do you primarily drink iced, cold brewed, or something like keurig?

there's.... i believe there is enough anecdotal evidence to state with a reasonable confidence level that coffee makes you poop.

I would add the caveat that it depends on your data heavily.

I supported a 20TB single-node DB, and it worked just fine. We had a lot of cold data though (about 10TB of it was solely for historical records, and 9.5TB of the rest was only accessed 4x yearly for massive reports).

The hardest part was never postgresql, mainly in numa related stuff.

Yep! I tried edibles, joints, and vape pens from 3 different dispensaries in the bay area. The edibles and "free" joint I got from Airfield Supply Co. were the ones that effected me the least negatively.

This is great news! VSCode has become my defacto editor across all of my environments, Linux, macOS, and Windows (10).

With a small amount of background setup that differs between environments I have essentially the exact same thing across all of my environments, and everything 'just works.'

I'm a big fan of VSCode, and it's awesome to see Microsoft putting heavy effort into it.

On the note of this specific plugin -- it's really good! I'd also suggest this plugin - https://marketplace.visualstudio.com/items?itemName=felixfbe... - if you like PHP. I switch between PHP/Python a lot and these two plugins have made VSCode great for my workflow.

Cannabis has pretty awful side-effects for me. It gives me absolutely incredible nausea, to the point where I've tried it ~10 times in varying doses, thinking my dosage was an issue, and out of those I was violently ill 4 of the times. The other 6 times were simply unenjoyable.

It doesn't just go away like alcohol either. If I drink too much and throw up, I feel better within a few minutes. For cannabis I remain high afterwards, so I've become pretty hesitant about it.

That being said, it is very likely less addictive and has far fewer side-effects for those who it helps. For that reason I am extremely positive about legalizing it and studying it further. :)

I don't know too much about Raja Koduri, but is leaving AMD and immediately joining Intel not... really shady?

Pretty regular, I will say they haven't seemed to put forth a patch for WPA2 yet, but I'm also unsure how fully vulnerable it is mostly because Android can be such a customized beast.

Check out mid-range stuff. There's an absolute treasure trove. I've been using a Moto G5 Plus (the 4GB RAM model) for some time now and it's an absolute treat.

Have you tried a trackball mouse? That was the magic 'ah-ha' moment for me. I haven't used a normal mouse (at work) in probably 6 years or so. I find in speed it is trackball + kb > kb-only > normal mouse + kb.

In the case of Microsoft specifically it's a silly meme that started due to the Xbox 360.

'Why do they call it the Xbox 360? Because when you see it you do a 360 and walk away.'

In favor of Ansible, I'd argue that extending it is trivial.

I tend to write simple Jinja2 filters when I need something done quickly that's not included, and it's as simple as making a specifically named directory (filter_plugins) and a python class (FilterModule). You can write your own modules pretty simply as well but there's a bit more boilerplate.