Log buffer #558: a carnival of vanities for DBAs

Posted in: Log Buffer, Technical Track

This log buffer edition overs cloud, Oracle, PostgreSQL and MySQL.

Cloud

On December 4, 2018 Microsoft’s Azure Database for Open Sources announced the general availability of MariaDB. This blog intends to share some guidance and best practices for alerting on the most commonly monitored metrics for the service.

Technology allows manufacturers to generate more data than traditional systems and users can digest. Predictive analytics, enabled by big data and cloud technologies, can take advantage of this data and provide new and unique insights into the health of manufacturing equipment and processes.

Questions about the security of and control over data, and where it resides, are on the minds of cloud customers today.

The AZ-203 Developing Solutions for Microsoft Azure certification exam tests and validates your expertise as an Azure Developer. This exam tests your expertise across all phases of the Microsoft Azure development process; from solution design to development and deployment to testing and maintenance.

Amazon Elastic Container Service (ECS) is a highly scalable, high-performance container orchestration service that allows you to easily run and scale containerized applications on AWS.

Oracle:

Strong relevancy is critical to a well-adopted search solution. Mindbreeze provides several ways to finetune relevancy which they refer to as “boosting”. This post will explore how boosting works and four ways to apply boosting rules within Mindbreeze.

Ever wondered why it’s not possible to reset a session modifiable parameter to its default value (that is, the system-wide current value)?

Azar discusses about ORA-01157 ORA-01110 ORA-27041 OSD-04002 O/S-Error.

You can install Python 3 on your Oracle Linux 7 environment with three simple steps.

One of the neat things about automation is it gives you the ability to quickly build/replace test environments, so you know you have a consistent starting point. This is especially important for automated testing (unit, integration etc.), but it also applies to your learning experience.

PostgreSQL

pgbouncer is the most widely used connection pooler for PostgreSQL. This blog will provide a simple cookbook on how to configure user authentication with pgbouncer.

This year, PostgresConf 2019 will be in NYC at the Sheraton New York Times Square March 18-22, 2019.

Postgres is up and running, and things are humming along. Replication is working, vacuums are running and there are no idle transactions in sight. You poke around your logs and make sure things are clean, but you notice a little warning.

Data Anonymization is a complex topic but PostgreSQL has a lot of interesting features to tackle this challenge! Here is an overview of a different approach and how to implement them directly within a PostgreSQL database.

After the final release of patch 9.3.25 on November 8th 2018, PostgreSQL 9.3 is no longer supported. Therefore it’s time for all users of PG 9.3 to upgrade their databases to a newer supported version.

MySQL

ProxySQL 1.4.13, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool.

With MySQL 8.0 it’s not possible anymore to create a user directly from the GRANT command. This means that to grant some privileges, the user must be created first.

LSM math: revisiting the number of levels that minimizes write amplification

Here are routines that can handle date arithmetic on BC dates, Julian day functions and simulation of Oracle’s support of old-style-calendar dates — including simulation of an Oracle bug. So the routines are good for extending the range of useable dates, compact storage and import/export between DBMSs that have different rules.

If you’re integrating your Node.js service with MySQL, you probably want to execute queries.

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 *