Insight for DBAs

A Snippet of Features: Reviewing PostgreSQL Version 13

Reviewing PostgreSQL Version 13

This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of gains in performance, administration, application development, and security enhancements.
Of the many new features and enhancements that have been made, some of the more notable ones include:

Space savings and performance gains from de-duplication of B-tree […]

Read more

Streaming MySQL Backups with Percona XtraBackup – Another Alternative

Today we are going to present you with another way to make a database copy between servers using our Percona XtraBackup utility.  What is the difference with many others existing on the web?  Not many, but they are interesting in terms of performance and availability.
We will combine the xbstream utility with the power of […]

Read more

Updated MySQL OSMetrics Plugins

Updated MySQL OSMetrics Plugins

It has been some time since I have posted updates to my plugins.  After the initial version, I decided to split the plugins into categories of metrics.  This will allow users to choose whether they want to install all of the plugins or only select ones they care about.
Since the installation process is unfamiliar […]

Read more

MongoDB 101: How to Tune Your MongoDB Configuration After Upgrading to More Memory

MongoDB configuration

In this post, we will be discussing what to do when you add more memory to your MongoDB deployment, a common practice when you are scaling resources.
Why Might You Need to Add More Memory?
Scaling resources is a way of adding more resources to your environment.  There are two main ways this can be accomplished: […]

Read more

Google Cloud Platform: MySQL at Scale with Reliable HA Webinar Q&A

MySQL at Scale with Reliable HA

Earlier in November, we had a chance to present the “Google Cloud Platform: MySQL at Scale with Reliable HA.” We discussed different approaches to hosting MySQL in Google Cloud Platform with the available options’ pros and cons. This webinar was recorded and can be viewed here at any time. We had several great questions, […]

Read more