Buy Percona ServicesBuy Now!

PostgreSQL Backup Strategy for an Enterprise-Grade Environment

, and  | September 25, 2018 |  Posted In: Backups, PostgreSQL

PostgreSQL enterprise-grade backup and recovery

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 […]

Read More

Why Optimization derived_merge can Break Your Queries

 | September 25, 2018 |  Posted In: MySQL

MySQL optimizer bugs

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 optimizer_switch  options. Issues were solved, though at the price of performance, when we turned it OFF . But, more importantly, we could not […]

Read More

Upcoming Webinar Thurs 9/27: Best Practices Using Indexes in MongoDB

 | September 25, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Technical Webinars

Best Practices Using Indexes in MongoDB

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 […]

Read More

Backing up Percona Server for MySQL with keyring_vault plugin enabled

 | September 24, 2018 |  Posted In: MySQL, Percona Server for MySQL, Percona XtraBackup, Security

Percona XtraBackup with keyring_vault

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 […]

Read More

Securing PostgreSQL as an Enterprise-Grade Environment

, and  | September 21, 2018 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, PostgreSQL, Security

PostgreSQL enterprise-grade security

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 […]

Read More

End-of-Life Reminder for Percona Server for MongoDB 3.2

 | September 21, 2018 |  Posted In: Events and Announcements, MongoDB, Percona Server for MongoDB

Percona Server for MongoDB

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. […]

Read More

This Week in Data with Colin Charles 53: It’s MariaDB Week PLUS Percona Live Europe Update

 | September 21, 2018 |  Posted In: MariaDB, MongoDB, MySQL, open source databases, Percona Server for MongoDB, Percona XtraDB Cluster, PostgreSQL

Colin Charles

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 I’d 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 […]

Read More

Prometheus 2 Times Series Storage Performance Analyses

 | September 20, 2018 |  Posted In: Benchmarks, MySQL, Percona Monitoring and Management, PMM, Prometheus

cpu saturation and max core usage

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 […]

Read More

ProxySQL 1.4.10 and Updated proxysql-admin Tool Now in the Percona Repository

 | September 20, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona XtraDB Cluster, ProxySQL

ProxySQL 1.4.9

ProxySQL 1.4.10, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s 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é Cannaò created […]

Read More

MyRocks Disk Full Edge Case

 | September 20, 2018 |  Posted In: MariaDB, MyRocks, Percona Server for MySQL

problem in MyRocks

RocksDB engine—and it’s 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 […]

Read More

Subscribe to the Percona Database Performance Blog for open source database help, technical resources, Percona Live updates and upcoming webinars.

Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.