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

Posted in: Log Buffer, Technical Track

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

Cloud:

What is the quickest way to integrate NLP in an application?

How to Process and Present IoT Data on Microsoft Azure?

Amazon Kinesis Analytics Now Supports Configuring Multiple Destinations in the Console

Demystifying ML: How machine learning is used for speech recognition

Google Cloud Dedicated Interconnect gets global routing, more locations, and is GA

Oracle:

Microservices: Running a webserver (caddy) on Ubuntu Core with snap

ksplice kernel updates and Exadata patching

GoldenGate Naming Convention P03

Essential WebLogic Tuning to Run on Docker and Avoid OOM

Exadata X5-2L deployment & Challenges

PostgreSQL:

Just within the past month there have been a number of strong technical articles written by users of PostgreSQL showcasing how they are leveraging the database. It seemed worth highlighting a few of the best that Jeremy Schneider came across.

Innumerable companies are entrusting a priceless asset – source code – to PostgreSQL via GitLab. Just a few weeks ago, Yorick Peterse from GitLab wrote about different approaches for scaling PostgreSQL and why they chose against sharding and in favor of standbys with am external connection pooler.

German eCommerce company Shopping24 is a heavy PostgreSQL user; their standard database deployment is a 40 core, 256G, SSD-backed bare metal server. Torsten Bøgh Köster recently wrote an excellent post about how they have created a dynamic autovacuum configuration. (For those of you on other database platforms, “vacuum” is PostgreSQL’s clever mechanism to move undo processing out of the commit path and defer it for later processing.)

Phil Freeman at Lumi documented their surprise at PostgreSQL’s performance and maturity in handling JSON and full text search. They successfully migrated their backend stack from RethinkDB and ElasticSearch to PostgreSQL.

Speaking of features, GIS support is something PostgreSQL is very well known for – many argue that it’s even a better platform than the commercial alternatives in this area. Mark Mathis at DescartesLabs wrote a fantastic article about creating animated maps showing crop yield forecasts over time with PostgreSQL.

And finally, are there any Game of Thrones fans out there? PatrickTriest is a fan – and he wrote a two-part article about how he aggregated open-source geo-data and wiki text from other fans to create a PostgreSQL-based google-maps-style website for exploring the entire Game of Thrones world! He even posted all of his code on github and keeps a public demo at atlasofthrones.com.

MySQL:

Contention-Aware Transaction Scheduling Arriving in InnoDB to Boost Performance

There’s a GTID_SUBTRACT function, and the manual shows how to write your own cheap GTID_UNION, but not a GTID_INTERSECT.

In the 1990s C.J.Date said: “The rule by which it is determined within the standard that one key word needs to be reserved while another need not be is not clear to this writer.”

Insert benchmark, IO-bound, Intel NUC: MyRocks vs InnoDB

Top Performance Metrics to Monitor on MySQL (Connections & Buffer Pool Usage)

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 *