Log buffer #561: A carnival of the vanities for DBAs
This Log Buffer Edition covers Cloud, Oracle, and MySQL. Cloud: AWS has completed its 2018 assessment against the Cloud Computing Compliance Controls Catalog (C5) information security and compliance program. One of the most important things you can do as a customer to ensure the security of your resources is to maintain careful control over who has access to them. Amazon Elasticsearch Service (Amazon ES) is a fully managed service to search, analyze, and visualize data in real-time. The service offers integration with Kibana, an open-source data visualization and exploration tool that lets you perform log and time-series analytics and application monitoring. Security can be a never-ending saga—a chronicle of increasingly sophisticated attacks, volumes of alerts, and long resolution timeframes where today’s Security Information and Event Management ( SIEM) products can’t keep pace. Kubernetes is going from strength to strength as adoption across the industry continues to grow. But there are still plenty of customers coming to container orchestration for the first time while also building up their familiarity with Docker and containers in general. Oracle: Resolving the ORA-17503: ksfdopn:10 Failed to open spfile. Fishbowl Solutions helps a key customer gain efficiencies and cuts costs through the implementation and data migration of PTC Windchill PartsLink & Supplier Management. Checking Flash Cache Mode in Exadata Cloud Blaming and praising room occupiers using Outlook API, InfluxDB, IoT and Azure serverless functions Filesystem events are useful to monitor. They can indicate a security breach. They can also help in understanding how a complex system works by looking at the files it reads and writes. java.sql.SQLException: invalid name pattern while pushing the data to Oracle EBS via SOAP. MySQL: The LEMP stack is a web development platform for hosting static and dynamic websites. It is a combination of free and open-source software including Linux, Nginx, MySQL, and PHP. Cachet is a beautiful and powerful open source status page system written in PHP that allows you to better communicate downtime and system failures to your customers, teams, and shareholders. 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. InnoDB keeps hot data in memory on its buffer named InnoDB Buffer Pool. For a long time, when a MySQL instance needed to bounce, this hot cached data was lost and the instance required a warm-up period to perform as well as it did before the service restart. Galera Cluster 4 available for use in the latest MariaDB 10.4.3 Release Candidate!