Update: The creator of Sidekiq, Mike Perham, quickly and correctly pointed out that standard ActiveRecord use inside Sidekiq should include automatic connection pool checkins when jobs are complete.
I failed to realize that using ActiveRecord::Base.connection checks out a... continue reading
When restoring an RDS instance from a snapshot, AWS unavoidably lazy loads the
entire database on-demand. This leads to a huge performance penalty until the
entire database has been accessed at least once.
This is fine if your database is... continue reading
When working with RDS, I would occasionally find my web console-initiated
restores-from-s3 stall out indefinitely with no errors of any kind. Confused, I
ran to AWS Support, who told me that I should not specify "root" as the admin
user... continue reading
While getting our CDK-based AWS infrastructure going, I often found myself
restoring a MySQL backup to RDS. This went fairly smoothly, except that I could
not avoid the end-of-restore snapshot that the AWS web console requires. This
adds several hours... continue reading
I love Percona and its MySQL tools. They have really enabled me to pretend I'm
a DBA for much longer than I probably should have.
One of the main Percona tools we use is called "xtrabackup", an online / hot
backup... continue reading