Percona is pleased to announce the early release of our latest software product Percona Backup for MongoDB 0.5.0 on June 17, 2019. The GA version is scheduled to be released later in 2019. Percona Backup for MongoDB is a distributed, low-impact solution for consistent backups of MongoDB sharded clusters and replica sets. This is a [&]

https://www.percona.com/blog/2019/06/17/percona-backup-for-mongodb-0-5-0-early-release-available/

Percona is pleased to announce the early release of our latest software product Percona Backup for MongoDB 0.5.0 on June 17, 2019. The GA version is scheduled to be released later in 2019. Percona Backup for MongoDB is a distributed, low-impact solution for consistent backups of MongoDB sharded clusters and replica sets. This is a [&]

https://www.percona.com/blog/2019/06/17/percona-backup-for-mongodb-0-5-0-early-release-available/

There is a wide variety of indexes available in PostgreSQL. While most are common in almost all databases, there are some types of indexes that are more specific to PostgreSQL. For example, GIN indexes are helpful to speed up the search for element values within documents. GIN and GiST indexes could both be used for [&]

https://www.percona.com/blog/2019/06/14/bloom-indexes-in-postgresql/

There is a wide variety of indexes available in PostgreSQL. While most are common in almost all databases, there are some types of indexes that are more specific to PostgreSQL. For example, GIN indexes are helpful to speed up the search for element values within documents. GIN and GiST indexes could both be used for [&]

https://www.percona.com/blog/2019/06/14/bloom-indexes-in-postgresql/

Not long after this year’s SouthEast LinuxFest 2019 in mid-June I’ll be speaking at a series of open source database meetups in Russia & UK, plus a big data MeetUp in France. At Percona were well aware of the growing number of Percona software users around the world, and whenever we have a chance to [&]

https://www.percona.com/blog/2019/06/14/on-the-road-russia-uk-and-france-summer-meetups/

Not long after this year’s SouthEast LinuxFest 2019 in mid-June I’ll be speaking at a series of open source database meetups in Russia & UK, plus a big data MeetUp in France. At Percona were well aware of the growing number of Percona software users around the world, and whenever we have a chance to [&]

https://www.percona.com/blog/2019/06/14/on-the-road-russia-uk-and-france-summer-meetups/

Percona announces the release of Percona Server for MongoDB 4.0.10-5 on June 13, 2019. Download the latest version from the Percona website 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 4.0 Community Edition. It supports MongoDB 4.0 protocols and drivers. Percona Server [&]

https://www.percona.com/blog/2019/06/13/percona-server-for-mongodb-4-0-10-5-now-available/

Percona announces the release of Percona Server for MongoDB 4.0.10-5 on June 13, 2019. Download the latest version from the Percona website 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 4.0 Community Edition. It supports MongoDB 4.0 protocols and drivers. Percona Server [&]

https://www.percona.com/blog/2019/06/13/percona-server-for-mongodb-4-0-10-5-now-available/

Clear and structured bug, improvement, and new feature request reports are always helpful for validating and fixing issues. In a few cases, we have received these reports with incomplete information which can cause a delay in the verification of issues. The most effective method to avoid this situation is to ensure complete information about the [&]

https://www.percona.com/blog/2019/06/12/report-bugs-improvements-new-feature-requests-for-percona-products/

Foreign key related issues are very common when dealing with DDL changes in MySQL using Percona toolkit. In this blog post, I will explain how the tool (pt-online-schema-change) handles foreign key constraints when executing a DDL change. First of all, I would like to explain why foreign keys have to be handled at all before [&]

https://www.percona.com/blog/2019/06/07/how-pt-online-schema-change-handles-foreign-keys/

It used to be easy: a company developed a new application, chose a database solution, launched the new application and then tuned the chosen database solution. A team of DBAs looked at the infrastructure as well as the workload and made changes (or suggestions) as needed. The application then stayed in production for years and [&]

https://www.percona.com/blog/2019/06/05/enterprise-data-solution-maximizing-return-for-the-lowest-cost/

Google Summer of Code (GSoC) is a program that focuses on bringing young talented students from universities into open source projects. This year, Percona became a mentor organization, so two student interns will join us as GSoC interns. Theyll be working with us over the next four months, and were delighted to welcome them to [&]

https://www.percona.com/blog/2019/06/05/google-summer-of-code-percona-interns/

Recently, I received a support request where the customer wanted to convert an INTEGER column to BIGINT on two tables. These tables are related by a foreign key, and it is a 3 node PXC cluster. These tables are 20GB and 82 GB in size and DDLs on such tables in a production environment is [&]

https://www.percona.com/blog/2019/06/04/ddl-queries-foreign-key-columns-mysql-pxc/

Redhat Enterprise Linux 8 packages have been released into our repositories.  Recent versions of Percona Server for MySQL, Percona XtraDB Cluster, Percona XtraBackup,  Percona Server for MongoDB, Percona Toolkit, and the PMM Client can now be automatically installed via Redhats dnf utility. How to install RHEL 8 Visit https://www.redhat.com/en/technologies/linux-platforms/enterprise-linux and follow the instructions.  If you [&]

https://www.percona.com/blog/2019/05/31/rhel-8-packages-available-for-percona-products/

Redhat Enterprise Linux 8 packages have been released into our repositories.  Recent versions of Percona Server for MySQL, Percona XtraDB Cluster, Percona XtraBackup,  Percona Server for MongoDB, Percona Toolkit, and the PMM Client can now be automatically installed via Redhats dnf utility. How to install RHEL 8 Visit https://www.redhat.com/en/technologies/linux-platforms/enterprise-linux and follow the instructions.  If you [&]

https://www.percona.com/blog/2019/05/31/rhel-8-packages-available-for-percona-products/

Welcome to Percona Live 2019 keynotes, day two! Day two of Percona Live 2019 looks to be as filled with great talks as day one. Today we started with presentations from Percona, Continuent, VividCortex, Oracle, and Alibaba. You can view the recording of today’s keynotes

https://www.percona.com/blog/2019/05/30/percona-live-2019-keynotes-day-two/

It was all aboard the Lone Star river boat for the 100 delegates who joined our Community Dinner. Loading took quite some time, Tom Basil attended to the guest list, and then the necessary signatures for those aboard. Id woken at 6 am to a less than favorable forecast, but the weather was kind to [&]

https://www.percona.com/blog/2019/05/30/percona-live-community-dinner-2019/

It was all aboard the Lone Star river boat for the 100 delegates who joined our Community Dinner. Loading took quite some time, Tom Basil attended to the guest list, and then the necessary signatures for those aboard. Id woken at 6 am to a less than favorable forecast, but the weather was kind to [&]

https://www.percona.com/blog/2019/05/30/percona-live-community-dinner-2019/

We are pleased to announce the release of PMM 2 Beta!  PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. Query Analytics: MySQL and MongoDB  Slow log, PERFORMANCE_SCHEMA, and Profiler data sources Support for large environments  default view all queries from all instances Filtering  display [&]

https://www.percona.com/blog/2019/05/30/percona-monitoring-and-management-pmm-2-beta-is-now-available/

We are pleased to announce the release of PMM 2 Beta!  PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. Query Analytics: MySQL and MongoDB  Slow log, PERFORMANCE_SCHEMA, and Profiler data sources Support for large environments  default view all queries from all instances Filtering  display [&]

https://www.percona.com/blog/2019/05/30/percona-monitoring-and-management-pmm-2-beta-is-now-available/