Log Buffer #537: A Carnival of the Vanities for DBAs

Posted in: Log Buffer, Technical Track

This Log Buffer Edition covers Cloud, Oracle, MySQL, and PostgreSQL.

Cloud:

How GIPHY engineers the perfect delivery of a GIF

How to get started on AWS (From a dead standstill)

Building Blocks of Amazon ECS

How we built a serverless digital archive with machine learning APIs, Cloud Pub/Sub and Cloud Functions

Analyzing your BigQuery usage with Ocado Technology’s GCP Census

Oracle:

VBCS: Create your Mobile Application

Getting started with Spring Boot microservices. Why and how.

Two Multitenant Instances

Identity columns in 12c … just a sequence ?

How to Enable Exadata Write-Back Flash Cache

MySQL:

MySQL 8.0.4 RC: auth_socket Users Beware!

How to Install Nginx with PHP + MySQL (LEMP) on Debian 9

Replication Features in MySQL 8.0.4

MySQL 8.0: changing configuration easily and cloud friendly !

Meltdown Vulnerability Impact On MariaDB Server

PostgreSQL:

Thanks to Jeremy Schneider.

What a week for tech! Missile alarms, security scandals, large-scale migration rumors… one of those weeks when I had to turn off social media to get any work done.

First off: Google may have officially published their first Spectre/Meltdown disclosure on Jan 3, but it felt like last week was when the tweets and articles really started coming out en masse. For example, while not directly PostgreSQL-related, David Gilbertson‘s Jan 6 article about harvesting credit card numbers and passwords was widely re-tweeted and well-commented.

The Linux Kernel team published patches with a feature called Page Table Isolation to address the vulnerabilities that were disclosed. There were rumors about a 30% perf hit on PostgreSQL due to a mailing list post, however on Jan 10 Simon Riggs from 2nd Quadrant published an article with results of pgbench runs showing a much smaller 7% impact with the Page Table Isolation linux kernel patches enabled.

Next up, it seemed that every major tech news outlet last week ran the story about Amazon and Salesforce “reportedly” moving away from Oracle databases. I’m not sure how much real news there was in this, but I did come across one article that I think is worth passing along. While he might make the process of porting apps between database platforms sound a little easier than it really is, Hal Berenson (former VP of Amazon RDS) published a solid article “Amazon moving off Oracle?” that uses the topic as a springboard.

Speaking of migrations, Javier Collado published a well-organized article on Jan 15 about a PostgreSQL migration inside of RDS. He systematically lists problems, solutions and lessons-learned in this quick read.

This reminds me of two additional migration-related articles that we skipped at the end of last year, but which I think are worth mentioning now. Elisha Zhang from Wootric published an article on Nov 20 about How They Migrated from Heroku PostgreSQL to AWS RDS. And Jobin Augustine from OpenSCG published an article on Nov 9 about Migrating partitioned tables to PostgreSQL 10’s Native Partitioning.

Back to this current week and diving a little deeper into PostgreSQL internals: on Jan 12, Sidharth Shanker from Fin Exploration published an article called “Migrations and Long Transactions in Postgres.” Now from my reading of the article, he’s describing a DDL schema change (adding a column) which didn’t involve moving data to a new system. But he does get into locking internals and it’s worth the read!

I really love good technical articles and on Jan 15 Laurenz Albe from Cybertec published an article about How a bad network configuration can cause table bloat. Great example of step-by-step troubleshooting and some interesting new insights into how the PostgreSQL stats collector works!

Speaking of amazing technical content, Egor Rogov has been writing a series of very high-quality blog posts about Indexes in PostgreSQL. He published has latest article on Jan 16 with a deep-dive into BRIN indexes. Unfortunately I don’t yet read Russian – but I was pleasantly surprised that google translate actually converts these articles to english amazingly well!

Setting up authentication is one of those topics that you don’t think about every day, but when it comes up you have to scramble to figure things out! If you’re a microsoft shop then you might want to bookmark Denish Patel‘s Jan 10 article about Connecting Postgres to Active Directory for Authentication.

And last but not least, Jan Karremans from EnterpriseDB wrote a second article on Jan 10 about his personal journey of picking Postgres over Oracle.

Definitely a little more reading than usual this week. Guess it’s pretty clear we’re out of the holiday lull. And don’t get too far behind…
when it comes to PostgreSQL, the pace only seems to be increasing!

email

Interested in working with Fahd? Schedule a tech call.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *