Percona announces the release of Percona Server for MongoDB 3.4.17-2.15 on September 27, 2018. Download the latest version from the Percona website or the Percona Software Repositories. Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. Percona Server for MongoDB extends [&]

The post Percona Server for MongoDB 3.4.17-2.15 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/percona-server-for-mongodb-3-4-17-2-15-is-now-available/

In this blog post, we will look at how to do MongoDB® log rotation in the right—and simplest—way. Log writing is important for any application to track history. But when the log file size grows larger, it can cause disk space issues. For database servers especially, it may cause performance issues as the database needs to write [&]

The post Automating MongoDB Log Rotation appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/automating-mongodb-log-rotation/

In this blog post, we will look at how to do MongoDB® log rotation in the right—and simplest—way. Log writing is important for any application to track history. But when the log file size grows larger, it can cause disk space issues. For database servers especially, it may cause performance issues as the database needs to write [&]

The post Automating MongoDB Log Rotation appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/automating-mongodb-log-rotation/

In this blog post, we will look at how to do MongoDB® log rotation in the right—and simplest—way. Log writing is important for any application to track history. But when the log file size grows larger, it can cause disk space issues. For database servers especially, it may cause performance issues as the database needs to write [&]

The post Automating MongoDB Log Rotation appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/automating-mongodb-log-rotation/

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.23-31.31 on September 26, 2018. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.23-31.31 is now the current release, based on the following: Percona Server for MySQL 5.7.23 Galera Replication library 3.24 Galera/Codership WSREP API Release 5.7.23 Deprecated The following [&]

The post Percona XtraDB Cluster 5.7.23-31.31 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/26/percona-xtradb-cluster-5-7-23-31-31-is-now-available/

This post is a followup to my previous article https://www.percona.com/blog/2018/08/29/scaling-io-bound-workloads-mysql-cloud/ In this instance, I want to show the data in different dimensions, primarily to answer questions around how throughput scales with increasing IOPS. A recap: for the test I use Amazon instances and Amazon gp2 and io1 volumes. In addition to the original post, I [&]

The post Scaling IO-Bound Workloads for MySQL in the Cloud  part 2 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/26/scaling-io-bound-workloads-for-mysql-in-the-cloud-part-2/

In this post we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL® cluster. In setting up our demonstration system, we use pg_basebackup and continuous archiving. The size of the database and your database environment—if it is on colo or cloud—matters. It is very important to understand how we can ensure minimalistic [&]

The post PostgreSQL Backup Strategy for an Enterprise-Grade Environment appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/25/postgresql-backup-strategy-enterprise-grade-environment/

Lately, I worked on several queries which started returning wrong results after upgrading MySQL Server to version 5.7 The reason for the failure was derived merge optimization which is one of the default [crayon-5bad99e6e350d113982083-i/]  options. Issues were solved, though at the price of performance, when we turned it [crayon-5bad99e6e3514554416742-i/] . But, more importantly, we could not [&]

The post Why Optimization derived_merge can Break Your Queries appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/25/why-optimization-derived_merge-can-break-your-queries/

Please join Percona’s Principal Architect Alex Rubin as he presents Best Practices Using Indexes in MongoDB on Thursday, September 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   Indexes support the efficient execution of queries in MongoDB. Without indexes, MongoDB must perform a collection scan, i.e. scan every document in [&]

The post Upcoming Webinar Thurs 9/27: Best Practices Using Indexes in MongoDB appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/25/webinar-best-practices-indexes-mongodb/

To use Percona XtraBackup with keyring_vault plugin enabled you need to take some special measures to secure a working backup. This post addresses how to backup Percona Server for MySQL with keyring_vault plugin enabled. We also run through the steps needed to restore the backup from the master to a slave. This is the second [&]

The post Backing up Percona Server for MySQL with keyring_vault plugin enabled appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/24/backing-up-percona-server-for-mysql-with-keyring_vault-plugin-enabled/

In this post, we review how you can build an enhanced and secure PostgreSQL database environment using community software. We look at the features that are available in PostgreSQL that, when implemented, provide improved security. As discussed in the introductory blog post of this series, in our webinar of October 10, 2018 we highlight important [&]

The post Securing PostgreSQL as an Enterprise-Grade Environment appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/21/securing-postgresql-as-an-enterprise-grade-environment/

As noted on our Software and Platform Lifecycle page, Percona Server for MongoDB 3.2 will be end of life on September 30, 2018. According to the Percona Services Lifecycle Policy, customers with an active support contract with Percona will continue receiving support; however, end-of-life software receives no new builds, bug fixes, security fixes, or features. [&]

The post End-of-Life Reminder for Percona Server for MongoDB 3.2 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/21/end-of-life-reminder-for-percona-server-for-mongodb-3-2/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week is clearly what Id call a MariaDB week — plenty of announcements coming from MariaDB Corporation and MariaDB Foundation. It started with Alibaba Cloud and MariaDB Announce the Launch of ApsaraDB RDS for MariaDB [&]

The post This Week in Data with Colin Charles 53: Its MariaDB Week PLUS Percona Live Europe Update appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/21/this-week-in-data-with-colin-charles-53-its-mariadb-week-plus-percona-live-europe-update/

Prometheus 2 time series database (TSDB) is an amazing piece of engineering, offering a dramatic improvement compared to “v2” storage in Prometheus 1 in terms of ingest performance, query performance and resource use efficiency. As we’ve been adopting Prometheus 2 in Percona Monitoring and Management (PMM), I had a chance to look into the performance [&]

The post Prometheus 2 Times Series Storage Performance Analyses appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/20/prometheus-2-times-series-storage-performance-analyses/

ProxySQL 1.4.10, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. Ren'e Canna`o created [&]

The post ProxySQL 1.4.10 and Updated proxysql-admin Tool Now in the Percona Repository appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/20/proxysql-1-4-10-and-updated-proxysql-admin-tool-now-in-the-percona-repository/

RocksDB engine—and its MySQL implementation MyRocks—is a very good alternative engine for MySQL. It has proven to be very efficient and stable for many workloads, including those of large scale. However, it is still a relative newborn in the MySQL ecosystem, and has only a small fraction of the adoption rate of InnoDB. That means [&]

The post MyRocks Disk Full Edge Case appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/20/myrocks-disk-full-edge-case/

Percona has revealed the line-up of in-depth tutorials for the Percona Live Europe 2018 Open Source Database Conference, taking place November 5–7, 2018 at the Radisson Blu Hotel in Frankfurt, Germany. Secure your spot now with Advanced Registration prices. Be sure to buy your tickets soon as tickets prices will only head up, not down! Sponsorship opportunities for the conference [&]

The post Tutorial Schedule for Percona Live Europe 2018 Is Live appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/19/tutorial-schedule-for-percona-live-europe-2018-is-live/

Percona announces the release of Percona Server for MongoDB 3.2.21-3.12 on September 18, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.2 Community Edition. It supports MongoDB 3.2 protocols and drivers. Percona [&]

The post Percona Server for MongoDB 3.2.21-3.12 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/18/percona-server-for-mongodb-3-2-21-3-12-is-now-available/

Percona announces the release of Percona XtraDB Cluster 5.6.41-28.28 (PXC) on September 18, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.41-28.28 is now the current release, based on the following: Percona Server for MySQL 5.6.41 Codership WSREP API Rrelease 5.6.41 Codership Galera library 3.24 Fixed Bugs PXC-1017: [&]

The post Percona XtraDB Cluster 5.6.41-28.28 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/18/percona-xtradb-cluster-5-6-41-28-28-is-now-available/

A few months ago I wrote a blog post on How to Capture Per Process Metrics in PMM. Since that time, Nick Cabatoff has made a lot of improvements to Process Exporter and Ive improved the Grafana Dashboard to match. I will not go through installation instructions, they are well covered in original blog post.  This [&]

The post Monitoring Processes with Percona Monitoring and Management appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/18/monitoring-processes-with-percona-monitoring-management/