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

Posted in: Log Buffer, Technical Track

This Log Buffer Edition covers Cloud, Oracle and MySQL.

Cloud:

Cloud Directory is a neglected serverless data store that deserves much more attention.

Many of our large enterprise customers have this worry hanging over their heads … what are they going to do about that mainframe when they migrate?

Miners Extract More Value from the Cloud When They Transform Their Cultures

7 steps to keep your Windows Servers Patched with AWS Systems Manager

No application is an island—each one has dependencies and exists alongside other services, sharing resources and data.

Oracle:

An example gitignore file for Nodejs projects to ensure that local environment variables, build-related output and modules are not committed to the git repository.

Jonathan Lewis writes about Column Group Catalog.

Franck Pachot blogs about Oracle write-consistency bug and multi-thread de-queuing.

Mohammed Azar discusses the issues which may arise when we try to rebuild the forms or reports.

MySQL:

Change management is hard. In everyday production, there are numerous factors working against embracing change. Limited preparation time and a whole new show = a whole new crew, innumerable planning variables, and the challenge of driving an operational plan based on creative instincts.

Kathy Forte shows you how to connect to the same Docker instance using the MySQL Shell which is a tool to use Document Store and to create InnoDB Clusters.

Percona XtraDB Cluster 5.7.23-31.31 Is now available.

A query plan uses a loose index scan if “Using index for group-by” appears in the “Extra” column of the EXPLAIN output. In some plans though, “Using index for group-by (scanning)” appears. What does “(scanning)” mean and how is it different from the regular loose index scan?

Chien Tran on debugging a slow WordPress site.

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 *