154 karma · joined May 28, 2012
The use case was: Keep the table online and don't bring down the Galera cluster (which happened when running an ALTER on a table with millions of rows).
We went for pt-online-schema-change (from Percona) which copies, alters the new table, keeps them in sync, and then replaces it. All automated which is pretty sweet.
One of the answers on here has more info:
https://stackoverflow.com/questions/463677/alter-table-witho...
Of course this requires a bunch of extra tooling, like upgrade scripts that don't ALTER tables directly but rather lock-copy-delete-rename, etc.
There are many tools out there which help out with this, and whatever we couldn't find we built ourselves. Tools like JOOQ can update code entities based on the database, so a database-first approach is what we used, but you can go either way.
The benefit of this approach is ultimately security and less multi-tenant catastrophes leaking data from customers, etc.
When I was 10 years old I started coding in Qbasic, a few years later I told my dad I wanted to be a programmer when I grew up, he told me that it would likely be automated soon (as had happened with his industry, electronic engineering) and I'd be struggling to find a job. 23 years later and the demand still seems to be rising.
I'd say we're still quite far from such level of abstraction; but a certain degree of it is already possible as you say... k8s/docker/kafka/glue/databricks/redshift, all of these technologies mesh together "seamlessly", but more problems arise as a result.
The problems we must tackle just shift elsewhere.
I doubt this is a realistic consequence... I mean, who is following these bots? Would people really listen to a bot? I presume most people would be able to tell bot-controlled Twitter accounts from friends and legitimate followers.
I think the study should have included impact from those tweets, such as number of likes, retweets, quotes, and replies, as well as count of human followers.
Native English/Spanish speaker... having one paragraph in English and one in Spanish is very confusing.
It's an interesting format for a Podcast, but the written version really messes with your brain. Specially given that sometimes the following sentence translates part of the previous paragraph, but then sometimes adds additional context or continues the story.
Still much work to be done, but feel free to check it out: https://twitter.com/lemiffe/lists/tophackers/members