Log buffer #532: a carnival of the vanities for DBAs

Posted in: Log Buffer, Technical Track

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

Cloud:

Oracle Integration Cloud Update

AWS Contributes to Milestone 1.0 Release and Adds Model Serving Capability for Apache MXNet

Get Ready for the AWS Serverless Application Repository

How to get real-time, actionable insights from your Fastly logs with Looker and BigQuery

OAuth whitelisting can now control access to GCP services and data

Oracle:

Resumable operations are operations that can be suspended instead of failing, allowing us to fix the problem and resume the operation.

Improving Google Crawl Rate Optimization

Errors when downloading a file on page submit in Oracle Application Express (APEX) 5.1 or later…

Exporting an APEX page plus Shared Components

Oracle Forms & Reports on Docker – The Concept and Technique behind

MySQL:

Hands-On Look at ZFS with MySQL

How Scary is Enabling Semi-Sync Replication?

Percona Server for MySQL 5.5.58-38.10 is Now Available

Insert benchmark: IO-bound, high-concurrency, fast server

MySQL 8.0: Query Optimizer Takes Data Buffering into Account

PostgreSQL:

First off, there have been a few announcements over the past month or so worth mentioning.

Google announced on Nov 6: Cloud SQL for PostgreSQL adds high availability and replication.

Amazon announced on Nov 22: Amazon RDS Now Supports Database Storage Size up to 16TB and Faster Scaling for MySQL, MariaDB, Oracle, and PostgreSQL Engines.

Amazon announced on Nov 29 at reInvent: Serverless and Multi-Master (clustering) for Amazon Aurora.

Next, in the category of “battle stories with really useful information for everyone” there were two articles that got a lot of circulation and
stood out to us.

Pavan Patibandla from Amplitude published an article on Nov 22 which seemed to get a lot of attention on twitter: How a single PostgreSQL
config change improved slow query performance by 50x Michael Malis from Heap Analytics’ engineering team published an article on Nov 27 about Analyzing Millions of Postgres Query Plans. (This isn’t Michael’s first really interesting technical article about PostgreSQL either!)

In the category of “engaging articles about design & architecture” at least two recent articles stand out.

Stavros Korokithakis from Greece published an article on Nov 12 called “Startup Mistakes: Choice of Datastore” which was essentially about why you should not choose MongoDB.

Keith Alsheimer from EnterpriseDB published an article on Nov 21 called “Amazon RDS and Aurora: The Golden Arches of Postgres?” which was about how the heart and soul of PostgreSQL is its extensibility, and whether cloud-provided versions of PostgreSQL are worth the limits imposed on your ability to customize it.

Last but not least, the category of “stories and lore from PostgreSQL history”, you should definitely read Bruce Momjian‘s short article from
Nov 24 called “Postgres vs PostgreSQL”. Aren’t you wondering why Postgres/PostgreSQL has two names? Why nobody can make up their mind about which one to use? And WHY IS THE MASCOT AN ELEPHANT?! Read and learn!

email

Author

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 *