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

Posted in: Log Buffer, Technical Track

This log buffer edition covers Cloud, Oracle and MySQL.

Cloud

Increasingly, enterprise backends combine legacy systems, modern microservices, and various SaaS applications. More and more of the modern applications are built on the cloud or are migrating there.

Account management, authorization and password management can be tricky. For many developers, account management is a dark corner that doesn’t get enough attention. For product managers and customers, the resulting experience often falls short of expectations.

A growing desire to run more heterogeneous and less trusted workloads has created a new interest in sandboxed containers—containers that help provide a secure isolation boundary between the host OS and the application running inside the container.

Amazon Elasticsearch Service (Amazon ES) announced support for publishing error logs to Amazon CloudWatch Logs. This new feature provides you with the ability to capture error logs so you can access information about errors and warnings raised during the operation of the service.

Many customers use Amazon EMR and Apache Spark to build scalable, big data pipelines. For large-scale production pipelines, a common use case is to read complex data originating from a variety of sources.

Oracle

When it comes to big data platforms, one of the biggest challenges is getting a test environment setup where you can try out the various components. There are a few approaches to doing this. The first is to set up your own virtual machine or some other container with the software.

Scott Wesley is thinking about APEX 18.2 Statement of Direction.

kpatch is a no-downtime Kernel Patching Solution that is built in Red Hat Enterprise Linux (RHEL).

High-profile breaches have propelled security to the top of the agenda at many organizations as the combination of faster, more-damaging attacks, increasingly complex technology environments, and demanding regulatory requirements continue to create new security challenges.

How do you know you are hiring the right candidates? According to the Society for Human Resource Management, the average cost per hire is US$4,129, and it takes an average of 42 days to fill an open requisition.

MySQL

The world of application and its related services are migrating more towards cloud because of availability, elasticity, manageability, etc. When moving the entire stack, we need to be very cautious while migrating the database part.

ClickHouse is an open-source column-oriented columnar Database Management System (DBMS) for online analytical processing.

Amazon RDS is a managed relational database service that makes it easier to set up, operate, and scale a relational database in the cloud. One of the most common questions we get is, “What is Multi-AZ and how is it different from Read Replica. Do I need both?”

With the introduction of MySQL Shell 8.0, the second major version of the new command-line tool for MySQL, a new and rich-featured prompt, was introduced. Unlike the prompt of the traditional MySQL command-line client, it does not just say mysql> by default. Instead, it comes in a color-coded spectacle.

Windowing Functions can get quite complex very quickly when you start taking advantage of the frame clause. Ranges and rows can get confusing.

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 *