Log Buffer

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

This Log Buffer Edition covers blog posts from Cloud, Oracle, and MySQL.
Cloud:
Google Stackdriver lets you track your cloud-powered applications with monitoring, logging and diagnostics. Using Stackdriver to monitor Google Cloud Platform (GCP) or Amazon Web Services (AWS) projects has many advantages—you can get detailed performance data and can set up tailored alerts.
This post is courtesy of Sam Dengler, AWS Solutions Architect. Message brokers can be used to solve a number of needs in enterprise architectures, including managing workload queues and broadcasting messages to a number of subscribers.
New Cloud Filestore service brings GCP users high-performance file storage.
One of the biggest trends in application development today is the use of APIs to power the backend technologies supporting a product.
It’s no secret that data is an essential part of running a business, no matter how large or small a business may be. Many companies host their business data using relational databases.
Oracle:
How can I print to PDF? How can I get a document/report with my data? How can I export my data from APEX to Excel?
Almost a year ago, Oracle released Oracle GoldenGate 12c (12.3.0.1.x). At that time, there were two architectures released: Microservices and Classic. Both architectures provided the same enterprise-level replication. The only difference was that one enabled a RESTful API interface with HTML5 page and the other was still command line driven.
Ubuntu 16.04: Installation of Chrome browser fails with libnss3 (>= 2:3.22) [2]

UTL_FILE_DIR and 18c
DevOps in OAC: Scripting Oracle Cloud Instance Management with PSM Cli
MySQL:
One problem that’s a lot less common these days is swapping. Most of the issues that cause swapping with MySQL have been nailed down to several different key configuration points, either in the OS or MySQL, or issues like the swap insanity issue.
MariaDB 10.3 is now generally available (10.3.7 was released GA on 2018-05-25). The article What’s New in MariaDB Server 10.3 by the MariaDB Corporation lists three key improvements in 10.3: temporal data processing, Oracle compatibility features, and purpose-built storage engines.
MySQL 8.0 InnoDB Cluster on ARM64 with Oracle Linux and the Raspberry Pi 3B.
Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0
JFG Posted on the Percona Community Blog – A Nice Feature in MariaDB 10.3: no InnoDB Buffer Pool in Core Dumps

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

This Log Buffer edition covers Oracle, SQL Server and MySQL.
Cloud:
What DBAs need to know about Cloud Spanner, Part 1: Keys and indexes
Introducing sole-tenant nodes for Google Compute Engine — when sharing isn’t an option
A serverless solution for invoking AWS Lambda at a sub-minute frequency
Amazon Aurora MySQL DBA Handbook – connection management
Why you should bet on Azure for your infrastructure needs, today and in the future
Oracle:
The ability to make grants on objects in the database such as tables, views, procedures or others such as SELECT, DELETE, EXECUTE and more is the cornerstone of giving other users or schemas granular access to objects.
While clients tend to tell developers to skip wireframing and prototyping, seasoned veterans tell newbies that they can skip wireframing and proceed with prototyping.
Last week in Stream Processing & Analytics – 6.6.2018
Facebook, Google and Custom Authentication in the same Oracle APEX 18.1 app
Quick install of Prometheus, node_exporter and Grafana
MySQL:
Benchmarking the Read Backup feature in the NDB storage engine
MySQL Cluster 7.6 and the thread pool
MySQL on Docker: Running a MariaDB Galera Cluster without Container Orchestration Tools – Part 1
MySQL Streaming Xtrabackup to Slave Recovery
A friendly comparison of InnoDB and MyRocks Performance
PostgreSQL:
By Jeremy Schneider
Hello from California!
Part of my team is here in Palo Alto and I’m visiting for a few days this week. You know, for all the remote work I’ve done over the years, I still really value this in-person, face-to-face time. These little trips from Seattle to other locations where my teammates physically sit are important to me.
This is also part of the reason I enjoy user groups and conferences so much. They’re opportunities to meet with other PostgreSQL users in real life. In fact – at this very moment – one of the most important PostgreSQL conferences in the world is happening: PgCon! Having attended a few other conferences over the past year, I’m holding down the fort in the office this week in order to send a bunch of other teammates… but you can be sure I’m keeping an eye on Twitter. 🙂
In the meantime, let’s get busy with the latest updates from the postgresql virtual world. First of all, I think the biggest headline is that (just in time for pgcon) we have the first official beta version of PostgreSQL 11! The release announcement headlines with major partitioning enhancements, more parallelism, a feature to speed up SQL execution by compiling certain operations on-demand into native machine code (JIT/Just-In-Time compilation), and numerous SQL enhancements. You can also read the first draft of the release notes. This is the time to start testing and give feedback to the development community!
Closely related to this, there’s one other really big headline that I’m excited about: the new AWS RDS Preview Environment. You can now try out the new pg11 features ahead of time with a single click! In part, because the development community is so awesome, the first database available in the RDS Preview Environment is PostgreSQL. And the official PostgreSQL 11 beta release is _already_ available on RDS!! Personally, I’m hoping that this benefits the community by getting more people to test and give feedback on new features being built for PostgreSQL 11. I hope it will make a great database even better.
Moving on from headlines, let’s get to the real stuff – the meaty technical articles. 🙂
First up, who likes testing and benchmarking? One of my favorite activities, truth be told! So I can’t quite convey just how excited I am about the preview release of Kevin Closson’s pgio testing kit. For those unfamiliar, Kevin has spent years refining his approach for testing storage through database I/O paths. Much work was done in the past with Oracle databases, and he calls his method SLOB. I’m excited to start using this kit for exploring the limits of storage through PostgreSQL I/O paths too.
Right after Kevin published that post, Franck Pachot followed up with a short article using pgio to look at the impact of the ext4 “sync” filesystem option (made relevant by the recently disclosed flaws in how PostgreSQL has been interacting with Linux’s implementation of fsync).
In addition to Kevin’s release of PGIO, I also saw three other generally fun technical articles. First, Kaarel Moppel from Cybertec published an article showing much lower-than-expected impact of pl/pgsql triggers on a simple pgbench execution. Admittedly, I want to poke around at this myself, having seen a few situations where the impact seemed higher. Great article – and it certainly got some circulation on Twitter.
Next, Sebastian Insausti has published an article explaining PostgreSQL streaming replication. What I appreciate the most about this article is how Sebastian walks through the history of how streaming replication was developed. That context is so important and helpful!
Finally, the requisite Vacuum post. 🙂 This month we’ve got a nice technical article from Sourabh Ghorpade on the Gojek engineering team. Great high-level introduction to vacuuming in general, and a good story about how their team narrowly averted an “xid wraparound” crisis.

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

This Log Buffer Edition touches upon various blog posts from Cloud, Oracle, SQL Server and MySQL.
Cloud:
Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)
Multiple APEX Workspaces in one Oracle Exadata Express Cloud account is now possible.
Setting up Oracle Event Hub (Apache Kafka) Cloud Service and Pub & Sub from local Node Kafka client.
AWS Adds 12 More Services to Its PCI DSS Compliance Program.
Committed use discounts for Google Compute Engine is now generally available.
Announcing Stackdriver Debugger for Node.js
Oracle:
Migrating Databases to Oracle Cloud Using RMAN Backup
Oracle SOA Suite and WebLogic: Overview of key and keystore configuration
Unify Update – v1.0.1
Oracle WebCenter Enterprise Capture Overview
So just what is a “partition-wise” join ?
SQL Server:
When sp_HelpText is not so helpful!
More SQL Server Features that Time Forgot
Overview of Azure Data Lake
Database as a Service: Defining Quality
Network Configuration of SQL Server Always On Availability Groups in Azure
MySQL:
Sealing MongoDB documents on the blockchain
Attached Storage Hindering Commit Performance
Revisiting roles in MySQL 8.0
How to Deal with XA Transactions Recovery
How to Analyze Actions for Certain MySQL Tables

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

This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.
Cloud:
Introducing managed SSL for Google App Engine
Using Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot Application
ClusterControl in the Cloud – All Our Resources
Monitoring Amazon Aurora Audit Events with Amazon CloudWatch
Integrating Teradata with Amazon Redshift Using the AWS Schema Conversion Tool
Oracle:
Demo App for REST enabled SQL
The Insurance of Oracle APEX – Can Your Low Code Framework Do This?
Oracle GoldenGate is now avaliable on Docker! All the details you need to get up and running on an image is included in Oracle’s public github.
Assign Pseudo Random Password for Oracle DB Users
Simple regexp to check that string contains word1 and word2 and doesn’t contain word3
SQL Server:
Automate MSBI deployments Using PowerShell
NEW – Machine Learning with SQL Server 2017 and R Tutorial
Optional Parameters and Missing Index Requests
Moving Dynamic Data Masked Data to New Locations
Indexing for Windowing Functions: WHERE vs. OVER
MySQL:
Lock, Stock and MySQL Backups: Data Guaranteed Webinar Follow Up Questions
gh-ost 1.0.42 released: JSON support, optimizations
Massive Parallel Log Processing with ClickHouse
cscope: Searching Code Efficiently
Updating InnoDB Table Statistics Manually

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

While cloud technologies are roaring ahead in full force; the traditional RDBMS like Oracle, Microsoft SQL Server and MySQL are adapting pretty fast. This Log Buffer Edition covers blogs related to that and more.
Oracle:
Oracle JET Simple Table with Fake JSON Server
Every time any page is requested from your website by a human or another program or an automated bot, the event is tracked in a log file that is stored on the web server.
Gitora 2 enabled developers to manage database objects that support the CREATE OR REPLACE command, namely PACKAGES, PROCEDURES, FUNCTIONS, TRIGGERS, VIEWS, SYNONYMS and TYPES in a Git repository.
Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release.
When you are restrained in the JRE that you can use with SQLcl, you can embed your own in the sqlcl directory tree.
SQL Server:
Understanding Azure Data Factory – A Cloud Based Integration Service
The Shortcomings of Predictive Accuracy
Setting Variables in Calling T-SQL Code While Using sp_executesql
Azure DWH part 15: PolyBase and Azure Data Lake
Creating Basic Indexes on the Stack Overflow Public Database
MySQL:
Heads Up: The List of Replication Defaults That Have Changed in 8.0.2
IO-bound table scan performance for MyRocks, InnoDB and TokuDB
MyRocks Experimental Now Available with Percona Server for MySQL 5.7.19-17
Timing load & index for sysbench tables
Automatic Partition Maintenance in MariaDB

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

This Log Buffer Edition covers from various blogs covering the technologies and news of Oracle, SQL Server and MySQL.
Oracle:
Storage Server: datasets, snapshots and performance
A Different Cause for enq: TM – contention
ODA X6-2M – How to create your own ACFS file system
Oracle New Version Numbering
KBHS-00600: Internal Error, Arguments [1] [kbhshtCreateDataBucket] Error During Backup To Oracle Cloud
SQL Server:
Using Database Master Keys in SQL Server
SQL Server Management Studio Tips
Sqlcmd is not just a script execution tool. It gives us access to internal variables and commands that we can use to automate code execution.
Additional SERVERPROPERTY properties in SQL Server
Simple SQL: Random Thoughts
My SQL:
The danger of no Primary Key when replicating in RBR (and a partial protection with MariaDB 10.1)
What’s New With MySQL Replication in MySQL 8.0
Docker Secrets and MySQL Password Management
More Details about InnoDB Compression Levels (innodb_compression_level)
Extending the Power of MariaDB ColumnStore with User Defined Functions

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

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:
Protecting Financial Data with Oracle WebCenter and Adobe LiveCycle
Oracle Forms 12c oracle.security.jps.JpsException Error after Database change
The Future of Content Management: Oracle Content & Experience Cloud
Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release Upgrade“ and RUR „Release Update Revision“ Patches.
Cloud Ward: Who Will Win the Battle for IT’s Future?
SQL Server:
SQL Server Management Studio add-ins
Resolve Network Binding Order Warning in failover cluster
Queries to inventory your SQL Server Agent Jobs
SQL Server 2016 ColumnStore Index String Predicate Pushdown
The Fast Route from Raw Data to Analysis and Display
MySQL:
Group-Replication, sweet & sour
You QA Most of Your System — What About Your Database?
Multi-Threaded Slave Statistics
Protecting your data! Fail-safe enhancements to Group Replication.
InnoDB Basics – Compaction: when and when not

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

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:
12.2 New Feature: the FLEX ASM disk group part 2
Oracle ASM in Azure corruption – follow up
Set-based processing
ADF 12c BC Proxy User DB Connection and Save Point Error
Enabling A Modern Analytics Platform
SQL Server:
Batch SSIS pkg execution from Business Intelligence Development Studio
Find Database Connection Leaks in Your Application
Troubleshooting CPU Performance on VMware
SQLskills Wait Types Library now shows SentryOne data
PowerShell Tool Time: The Tool Framework
MySQL:
Installing Zabbix into Azure using a MySQL PaaS
Streaming Global Cyber Attack Analytics with Tableau and Python
Thread Statistics and High Memory Usage
On slave_parallel_workers and the logical clock
RDS / Aurora OS monitoring with Monyog v8.1.0

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

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:
You may wish to clone an Oracle Home (for example you have all your databases on a single Oracle Home, but you want to separate Development from Test
Removing Outliers using stddev()
Installing Scala and Apache Spark on a Mac
Introduction to Oracle Big Data Cloud Service – Compute Edition (Part V) – Pig
More on Optimistic Locking with ORA_ROWSCN
SQL Server:
How to Decipher sysschedules
SQL Azure Reporting Automation
Database Code Analysis
Visual Studio 2017 and Swagger: Building and Documenting Web APIs
Techniques to Cleanse Bad Data in SQL Server
MySQL:
ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)
Debian 9 and MySQL: Watch Out!
How to Install LAMP on Ubuntu 16.04
Linux perf and the CPU regression in MySQL 5.7
Secure Binlog Server: Encrypted binary Logs and SSL Communication

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569