by Jobin Augustine | Sep 28, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of informed choices to be made to optimize PostgreSQL replication so that you achieve HA. In this post we introduce an overview of the topic,...
by Colin Charles | Sep 28, 2018 | MySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I consider this to be the biggest news for the week: Alpha Build of Percona Server for MySQL 8.0. Experiment with it in a...
by Peter Zaitsev | Sep 28, 2018 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Software
Starting with PMM 1.13, PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU and RAM. With Prometheus 2 Performance Improvements, PMM can scale to more than 1000 monitored nodes per instance in default configuration. In this...
by Borys Belinsky | Sep 27, 2018 | MySQL, Open Source, Percona Events, Percona Software
Alpha Build of Percona Server 8.0 released An alpha version of Percona Server 8.0 is now available in the Percona experimental software repositories. This is a 64-bit release only. You may experiment with this alpha release by running it in a Docker container: $...
by Borys Belinsky | Sep 27, 2018 | Percona Events, Percona Software
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...
by Borys Belinsky | Sep 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
This release has been superseded by 5.7.23-31.31.2 after a critical regression was found. Please update to the latest release. Percona is glad to announce the release of Percona XtraDB Cluster 5.7.23-31.31 on September 26, 2018. Binaries are available from...
by Vadim Tkachenko | Sep 26, 2018 | Benchmarks, MySQL, Storage Engine
This post is a followup to my previous article
by Sveta Smirnova | Sep 25, 2018 | MySQL
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...
by Alexander Rubin | Sep 25, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Webinars
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....
by Jericho Rivera | Sep 24, 2018 | MySQL, Percona Software, Security
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...
by Avinash Vallarapu | Sep 21, 2018 | Insight for DBAs, Insight for Developers, Percona Events, PostgreSQL, 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...
by Jeff Sandstrom | Sep 21, 2018 | MongoDB, Percona Events, Percona Software
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;...
by Colin Charles | Sep 21, 2018 | MariaDB, MongoDB, MySQL, Open Source, Percona Software, PostgreSQL
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...
by Peter Zaitsev | Sep 20, 2018 | Benchmarks, MySQL, Percona Software
by Dmitriy Kostiuk | Sep 20, 2018 | MySQL, Percona Events, Percona Software, ProxySQL
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...
by Przemysław Malkowski | Sep 20, 2018 | MariaDB, Percona Software, Storage Engine
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,...
by Bronwyn Campbell | Sep 19, 2018 | MariaDB, MongoDB, MySQL, Percona Events, Percona Live, Percona Software, PostgreSQL
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...
by Dmitriy Kostiuk | Sep 18, 2018 | MongoDB, Percona Events, Percona Software
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...
by Dmitriy Kostiuk | Sep 18, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
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:...
by Peter Zaitsev | Sep 18, 2018 | Insight for DBAs, MySQL, Percona Software
Please note: This blog refers to Percona Monitoring and Management v1. For information on v2, please visit Understanding Processes Running on Linux Host with Percona Monitoring and Management. A few months ago I wrote a blog post on How to Capture Per Process Metrics...
