Its that time of year again, and weve just had the presentations of the MySQL Community Awards at Percona Live. A more fulsome blog post will be written for the Community Blog in the next few days about the worthy winners. Meanwhile, though, heres a summary. Committee Co-Secretaries Emily Slocombe of Square, and Agustin Gallego [&]

https://www.percona.com/blog/2019/05/29/mysql-community-awards-at-percona-live-2019/

Welcome to Percona Live 2019 keynotes, day one! Percona Live 2019 is up and running! We call this day one, but in reality, yesterday was filled with tutorials that provided excellent and practical information on how to get your MySQL, MongoDB, MariaDB, and PostgreSQL environments up, running, and optimized. Today we started with keynote presentations [&]

https://www.percona.com/blog/2019/05/29/percona-live-2019-keynotes-day-one/

Percona announced the release of Percona Kubernetes Operator for XtraDB Cluster and Percona Kubernetes Operator for Percona Server for MongoDB. Kubernetes delivers a method to orchestrate containers, providing automated deployment, management, and scalability. In today’s cloud-native world, the ability to easily and efficiently deploy new environments or scale existing environments is key to ongoing growth [&]

https://www.percona.com/blog/2019/05/29/percona-kubernetes-operators/

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

https://www.percona.com/blog/2019/05/28/proxysql-2-0-4-and-proxysql-admin-tool-now-available/

Percona announces the release of Percona Server for MySQL 5.7.26-29 on May 27, 2019 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.26, including all the bug fixes in it. Percona Server for MySQL 5.7.26-29 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. [&]

https://www.percona.com/blog/2019/05/27/percona-server-for-mysql-5-7-26-29-is-now-available/

This is a CRITICAL update and the fix mitigates the issues described in CVE-2019-12301. If you upgraded packages on Debian/Ubuntu to 5.6.44-85.0-1, please upgrade to 5.6.44-85.0-2 or later and reset all MySQL root passwords.   Issue On 2019-05-18 Percona discovered an issue with the Debian/Ubuntu 5.6.44-85.0-1 packages for Percona Server for MySQL. When the previous [&]

https://www.percona.com/blog/2019/05/24/critical-update-for-percona-server-for-mysql-5-6-44-85-0/

A couple of weeks ago I presented at Percona University S~ao Paulo about the new features in PostgreSQL that allow the deployment of simple shards. Ive tried to summarize the main points in this post, as well as providing an introductory overview of sharding itself. Please note I havent included any third-party extensions that provide [&]

https://www.percona.com/blog/2019/05/24/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/

Feeling the FOMO? Now you don’t have to! With the Percona Live Open Source Database Conference 2019 Live Stream, you’ll practically be there in person, living the experience to the fullest. Our keynote stage features morning and lunchtime keynotes on Wednesday, May 29th and morning keynotes on Thursday, May 30th. Join us at home or [&]

https://www.percona.com/blog/2019/05/22/check-out-the-percona-live-2019-live-stream/

In this blog post, Ill walk through using Docker containers and discuss the advantages of using them to run multiple versions of Percona Server for MongoDB (PSMDB) instances in the same server. This is particularly useful for local testing. Lots of companies have started to use containers for their applications, due to the advantages of [&]

https://www.percona.com/blog/2019/05/21/introduction-to-docker-and-using-percona-server-for-mongodb/

In this blog post, Ill walk through using Docker containers and discuss the advantages of using them to run multiple versions of Percona Server for MongoDB (PSMDB) instances in the same server. This is particularly useful for local testing. Lots of companies have started to use containers for their applications, due to the advantages of [&]

https://www.percona.com/blog/2019/05/21/introduction-to-docker-and-using-percona-server-for-mongodb/

Percona announces the release of Percona Server for MySQL 5.6.44-85.0 on May 17, 2019. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.6.44, and including all the bug fixes in it, Percona Server for MySQL 5.6.44-85.0 [&]

https://www.percona.com/blog/2019/05/17/percona-server-for-mysql-5-6-44-85-0-is-now-available/

Percona announces the release of Percona Server for MySQL 5.6.44-85.0 on May 17, 2019. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.6.44, and including all the bug fixes in it, Percona Server for MySQL 5.6.44-85.0 [&]

https://www.percona.com/blog/2019/05/17/percona-server-for-mysql-5-6-44-85-0-is-now-available/

Please join Percona’s Product Manager Michael Coburn as he presents his talk Monitoring MongoDB with Percona Monitoring and Management (PMM) on May 16th, 2019 at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now Learn how to monitor MongoDB using Percona Monitoring and Management (PMM) that will allow you to: Gain greater visibility of [&]

https://www.percona.com/blog/2019/05/14/monitoring-mongodb-with-percona/

Usually, the PostgreSQL Community releases minor patches on the Thursday of the second week of the second month of each quarter. This can vary depending on the nature of the fixes. For example, if the fixes include critical fixes as a postgres community response to security vulnerabilities or bugs that might affect data integrity. The [&]

https://www.percona.com/blog/2019/05/13/postgresql-minor-versions-released-may-9-2019/

Hey, whats going on with my applications? I installed a newer version of MySQL. I have queries that perfectly run with the older version and now I have a lot of errors. This is a question some customers have asked me after upgrading MySQL. In this article, well see what one of the most frequent [&]

https://www.percona.com/blog/2019/05/13/solve-query-failures-regarding-only_full_group_by-sql-mode/

Its not long now before well be gathering in Austin TX for this years Percona Live event. Its the only conference of its type dedicated entirely to open source databases – of all marques. From a community perspective, we have a few updates to share. Community Dinner Were happy to say that PlanetScale have stepped [&]

https://www.percona.com/blog/2019/05/13/community-update-for-pl-open-source-database-conference-2019/

Its not long now before well be gathering in Austin TX for this years Percona Live event. Its the only conference of its type dedicated entirely to open source databases – of all marques. From a community perspective, we have a few updates to share. Community Dinner Were happy to say that PlanetScale have stepped [&]

https://www.percona.com/blog/2019/05/13/community-update-for-pl-open-source-database-conference-2019/

pgBackRest addresses many of the must-have features that youll want to look for in a PostgreSQL backup solution. I have been a great fan of the pgBackRest project for quite some time, and it gets better all the time. Historically, it was written in perl and now over the last year, the project is making [&]

https://www.percona.com/blog/2019/05/10/pgbackrest-a-great-backup-solution-and-a-wonderful-year-of-growth/

There’s less than a month to go so it’s time to announce the keynote addresses for Percona Live Open Source Database Performance Conference 2019! We’re excited to share our lineup of conference keynotes, featuring talks from Continuent, Vivid Cortex, Amazon Web Services, Facebook, PingCap and more! The speakers will address the current status of key [&]

https://www.percona.com/blog/2019/05/09/announcing-keynotes-for-percona-live-2019/

Every database management system is not optimized for every workload. Database systems are designed for specific loads, and thereby give better performance for that workload. Similarly, some kinds of queries work better on some database systems and worse on others. This is the era of specialization, where a product is designed for a specific requirement [&]

https://www.percona.com/blog/2019/05/09/improving-olap-workload-performance-for-postgresql-with-clickhouse-database/