One of our internal apps at Booking.com audits changes to our tables on various clusters. We used to use tungsten replicator, but have since migrated onto our own solution.
If you’re still using a password to login to your AWS account it’s time you batten down the hatches. With a little work you can dramatically improve security. 1. install command line tools First get ahold of the aws comand line tools. They’re python based so you’ll need the package manager “pip” first.
I will begin by noting that the project is stated to be pre-production, and so of course none of the below are complaints, but rather food for thought, points for action and otherwise recommendations.
We are used to issue queries with an IN clause of the form:
... where state in ('started', 'completed', 'failed') ...
However I've had a few cases where I used an inverted format. Here's one use case followed by an inverted IN clause.
Say we have this function:
The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available. You can download the code from here.