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

Posted in: Log Buffer, Technical Track

This log buffer edition covers Cloud, Oracle, PostgreSQL and MySQL.

Cloud

Brent Langston confirms that now you can add tags to your Amazon Elastic Container Registry (Amazon ECR) resources. This new feature enables better grouping of ECR repositories, better searching and filtering in the console and better cost allocation.

Here is something new for AWS Lambda: Use Any Programming Language and Share Common Components.

Today, most machine learning tasks use a technique called supervised learning: an algorithm learns patterns or behaviours from a labelled dataset.

This blog post has assembled some New Year’s resolutions to guide the way toward operating a faster, more efficient cloud infrastructure.

The pace of development for retail Internet of Things (IoT) solutions continues to build. From enhanced customer insights to better staff utilization and increased supply chain efficiency, sophisticated IoT solutions are helping retailers improve, and even reimagine, the retail experience.

Oracle

OIC Integration handles optional elements the same for both XML as well as JSON based elements, including mapping from XML to JSON and vice versa. The reason being that internally OIC will map JSON to XML.

Case-sensitive passwords were introduced in Oracle Database 11g, causing some misunderstanding and introducing quite a lot of annoying problems for DBAs, even though it was really required to bring level of Oracle’s security to 21st Century standards

The challenge: you are running a service, API or web application in a Docker container, locally on your laptop or in a cloud-based VM or container platform. You would like to provide access to external consumers – yourself on your smart phone, a piece of code running in a cloud environment, a colleague on your local network or on the other side of the world.

When configuring a physical standby database for Oracle using Data Guard, you need to create Standby Redo logs to allow the redo to be applied in (near) real-time to the standby. Without Standby Redo logs, Oracle will wait for an entire Archive Log to be filled and copied across to the standby before it will apply changes, which could take quite a while.

Oracle Connection Manager (cman) is a great tool to create a gateway between networks which cannot be connected or filter those who can access to a service. Most of the time, it’s a very robust implementation and doesn’t need a lot of attention.

PostgreSQL

Data Anonymization is a complex topic but PostgreSQL has a lot of interesting features to tackle this challenge! Here is an overview of different approaches and how to implement them directly within a PostgreSQL database.

After the final release of patch 9.3.25 on November 8, 2018, PostgreSQL 9.3 is no longer supported. Therefore, it’s time for all users of PG 9.3 to upgrade their databases to a newer supported version.

Postgres supports fourteen authentication methods — that might seem like a lot, but Postgres is used in many environments, and it has to support whatever methods are being used in those environments.

Historically, PostgreSQL has provided compilation features in the form of ahead-of-time compilation for PL/pgSQL functions and version 10 introduced expression compilation. None of those generate machine code though.

UUIDs are a popular identifier data type – they are unpredictable, and/or globally unique (or at least very unlikely to collide) and quite easy to generate.

MySQL

MySQL 8.0 was released with awesome features. One of its most prominent features is CTE (Common Table Expression).

MySQL is extensive and has lots of areas to optimize and tweak for the desired performance. Some changes can be performed dynamically, others require a server restart.

Amazon Aurora with MySQL Compatibility comes in three editions which, at the time of writing, have quite a few differences around the features that they support.

TasksMax: Another Setting That Can Cause MySQL Error Messages

Automation Script For Percona Xtrabackup FULL/Incremental

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 *