In this post, well cover Perconas thoughts about the current MySQL community discussion happening around MySQL LOCAL INFILE security issues. Some of the detail within this blog post is marked . I hope to address this shortly (by the end of Feb 2019) and provide complete detail and exploit proof-of-concept code. However, this post is [&]

https://www.percona.com/blog/2019/02/06/percona-responds-to-mysql-local-infile-security-issues/

In this post, well cover Perconas thoughts about the current MySQL community discussion happening around MySQL LOCAL INFILE security issues. Some of the detail within this blog post is marked . I hope to address this shortly (by the end of Feb 2019) and provide complete detail and exploit proof-of-concept code. However, this post is [&]

https://www.percona.com/blog/2019/02/06/percona-responds-to-mysql-local-infile-security-issues/

Percona announces the release of Percona Server for MongoDB 3.6.10-3.0 on February 6, 2019. Download the latest version from the Percona website or the Percona Software Repositories. This release is also available for Ubuntu 18.10 (Cosmic Cuttlefish). Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.6 Community Edition. It supports [&]

https://www.percona.com/blog/2019/02/06/percona-server-for-mongodb-3-6-10-3-0-is-now-available/

Percona announces the release of Percona Server for MongoDB 3.6.10-3.0 on February 6, 2019. Download the latest version from the Percona website or the Percona Software Repositories. This release is also available for Ubuntu 18.10 (Cosmic Cuttlefish). Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.6 Community Edition. It supports [&]

https://www.percona.com/blog/2019/02/06/percona-server-for-mongodb-3-6-10-3-0-is-now-available/

Please join Perconas PMM Product Manager, Michael Coburn for a webinar on The Top Trends in Modern Data Architecture for 2019 hosted by DBTA on Thursday, February 7th at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). Register Now A strong data architecture strategy is critical to supporting your organizations data-driven goals. AI and machine [&]

https://www.percona.com/blog/2019/02/06/top-trends-modern-data-architecture-2019/

On December 20th, 2018 we began to sign our packages with a new encryption key. Our percona-release package contains both the latest and older package signing keys. However, older versions of the percona-release rpm package do not contain our latest key. Users with older percona-release packages installed, that have not been updated, may see an [&]

https://www.percona.com/blog/2019/02/05/new-percona-package-signing-key-requires-update-on-rhel-and-centos/

Join Percona CEO Peter Zaitsev as he presents Percona Software News and Roadmap Update on Wednesday, February 6, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). Register Now Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software. Topics include Percona Server for MySQL and MongoDB, [&]

https://www.percona.com/blog/2019/02/05/percona-software-news-roadmap-update/

In this blog post, well look at how to use [crayon-5c5de43e9feb4549006263-i/] to rebuild PostgreSQL database objects online. Weve seen a lot of questions regarding the options available in PostgreSQL for rebuilding a table online. We created this blog post to explain the  [crayon-5c5de43e9feba817659042-i/] extension, available in PostgreSQL for this requirement. pg_repack is a well-known extension that was [&]

https://www.percona.com/blog/2019/02/04/pg_repack-rebuild-postgresql-database-objects-online/

While the PMM team works hard on our PMM 2.0 release, we have been working on a few things in the background which wed like to show off !  In particular we have developed a new dashboard that displays metrics related to memory usage on Linux systems. The dashboard leverages information collected by node_exporter. The graphs take [&]

https://www.percona.com/blog/2019/01/31/new-dashboard-to-monitor-memory-usage-pmm-plugin/

While the PMM team works hard on our PMM 2.0 release, we have been working on a few things in the background which wed like to show off !  In particular we have developed a new dashboard that displays metrics related to memory usage on Linux systems. The dashboard leverages information collected by node_exporter. The graphs take [&]

https://www.percona.com/blog/2019/01/31/a-new-pmm-dashboard-to-monitor-memory-usage/

Percona is glad to announce the release of Percona Server for MySQL 5.6.43-84.3 on January 29, 2019 (Downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.6.43, including all the bug fixes in it. Percona Server for MySQL 5.6.43-84.3 is now the current GA release in the 5.6 series. All of Percona’s software is open-source and [&]

https://www.percona.com/blog/2019/01/29/percona-server-for-mysql-5-6-43-84-3-is-now-available/

Please join Vinodh Krishnaswamy as he presents his talk, Percona Server for MongoDB 4.0 Feature Walkthrough on January 31st, 2019, at 6:00 AM PST (UTC-8) / 9:00 AM EST (UTC-5). Register Now Percona Server for MongoDB is an enhanced, open source, and highly-scalable database. Moreover, it is a fully-compatible, drop-in replacement for MongoDB 4.0 Community [&]

https://www.percona.com/blog/2019/01/29/percona-server-mongodb-4-feature/

Please join Percona’s Senior Technical Manager, Alkin Tezuysal, and Perconas Percona XtraDB Cluster Lead, Krunal Bauskar as they present their talk, Percona XtraDB Cluster: Failure Scenarios and their Recovery on Wednesday, January 30th, 2019, at 8:00 AM PST (UTC-8) / 11:00 AM EST (UTC-5). Register Now Percona XtraDB Cluster (a.k.a PXC) is an open source, [&]

https://www.percona.com/blog/2019/01/28/xtradb-cluster-failure-scenarios-recover/

Percona announces the availability of the Percona Server for MongoDB Operator 0.2.0 early access release. The Percona Server for MongoDB Operator simplifies the deployment and management of Percona Server for MongoDB in a Kubernetes or OpenShift environment. It extends the Kubernetes API with a new custom resource for deploying, configuring and managing the application through the whole [&]

https://www.percona.com/blog/2019/01/28/percona-server-for-mongodb-operator-0-2-0-early-access-release-is-now-available/

EverSQL is a platform that intelligently tunes your SQL queries by providing query optimization recommendations, and feedback on missing indexes. This is the second post of our EverSQL series, if you missed our introductory post take a look there first and then come back to this article. Well use the Stackoverflow data set again as we [&]

https://www.percona.com/blog/2019/01/28/monitor-and-optimize-slow-queries-with-pmm-and-eversql-part-2/

This year at our Open Source Database Conference were celebrating open source database technologies that dont fit into the MySQL®, MongoDB®, MariaDB®, or PostgreSQL realms by featuring them in their very own track. The glamorously-named Other Open Source Databases track! As unbiased champions of open source database solutions, we embrace all flavors of open source [&]

https://www.percona.com/blog/2019/01/25/open-source-database-conference-cfp-deadline-sun-jan-27/

TiDB is an open-source distributed database developed by PingCAP. This is a very interesting project as it is can be used as a MySQL drop-in replacement: it implements MySQL protocol, and basically emulates MySQL. PingCAP defines TiDB is as a one-stop data warehouse for both OLTP (Online Transactional Processing) and OLAP (Online Analytical Processing) workloads. [&]

https://www.percona.com/blog/2019/01/24/a-quick-look-into-tidb-performance-on-a-single-server/

TiDB is an open-source distributed database developed by PingCAP. This is a very interesting project as it is can be used as a MySQL drop-in replacement: it implements MySQL protocol, and basically emulates MySQL. PingCAP defines TiDB is as a one-stop data warehouse for both OLTP (Online Transactional Processing) and OLAP (Online Analytical Processing) workloads. [&]

https://www.percona.com/blog/2019/01/24/a-quick-look-into-tidb-performance-on-a-single-server/

TiDB is an open-source distributed database developed by PingCAP. This is a very interesting project as it is can be used as a MySQL drop-in replacement: it implements MySQL protocol, and basically emulates MySQL. PingCAP defines TiDB is as a one-stop data warehouse for both OLTP (Online Transactional Processing) and OLAP (Online Analytical Processing) workloads. [&]

https://www.percona.com/blog/2019/01/24/a-quick-look-into-tidb-performance-on-a-single-server/

For a very long time – since when multiple CPU cores were commonly available – I dreamed about MySQL having the ability to execute queries in parallel. This feature was lacking from MySQL, and I wrote a lots of posts on how to emulate parallel queries in MySQL using different methods: from simple parallel bash [&]

https://www.percona.com/blog/2019/01/23/mysql-8-0-14-a-road-to-parallel-query-execution-is-wide-open/