Log buffer #559: a carnival of the vanities for DBAs
This Log Buffer Edition covers Cloud, Oracle and MySQL.
Cloud: AWS
Solutions Architects are on the front line of helping customers succeed using our technologies. The new version of the AWS Ops
Automator, a solution that enables you to automatically manage your AWS resources, features vertical scaling for Amazon EC2 instances. How do you train the next generation of digital leaders? How do you provide them with a modern educational experience? Can you do it without
technical expertise? From web hosting to databases, workloads running on Compute Engine need a reliable, convenient and automatic way to create periodic snapshots for disks of
VM instances. Recently the disclosure of a vulnerability (
CVE-2019-5736) was announced in the open-source software (OSS) container runtime, runc.
Oracle:
Szymon Skorupinski has investigated a very interesting issue about troubleshooting Oracle session disconnection slowness. Oracle Enterprise Manager
Cloud Control 13c provides a wizard to convert a single-instance database to an Oracle RAC database. This requires the Oracle Database Lifecycle Management Pack for Enterprise Manager Cloud Control. Today (14-Feb-2019) Oracle officially released the 19c docs and Oracle Database 19c for
Exadata through e-delivery channel. Since the news is out, the Oracle community is busy talking about 19c availability and sharing articles about 19c, etc. Often times, a
digital assistant must execute on logic that can’t be written in the YAML or in a Q&A and should therefore use a custom component. Some use cases for a custom component might be: sending an email to the user or bot administrator, making an API call with user input, or connecting to an external data source to return user’s information. The Oracle
HCM Cloud team hosted their annual Customer Advisory Board meetings at Oracle HQ last week.
MySQL:
Vitess is a sharding and scaling solution for MySQL that can make thousands of databases appear to be a single monolithic database. What is Aurora? It's a
MySQL wire protocol compatible storage management system that sits on top of MySQL and modifies some innodb internals. You can read more about the architecture
here: I think of it as a Proxy Storage Engine System. Let's explore the consequence of reducing durability on masters (including setting
sync_binlog to a value different than 1) when slaves are using legacy file+position replication.
Matomo (formerly Piwik) is a free and open source web analytics application developed by a team of international developers that runs on a PHP/MySQL web server. It tracks online visits to one or more websites and displays reports on these visits for analysis. When things go horribly wrong and a process crashes, one of the most powerful things to investigate the cause of the crash is a core dump. As the amount of memory allocated to processes such as MySQL has increased – in some cases approaching
1TiB of memory – enabling core dumps can cause problems of their own.
