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 […]
Read more
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 we’re well aware of the growing number of Percona software users around the world, and whenever we have a chance […]
Read more
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 for […]
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 […]
Read more
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 […]
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 […]
Read more
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. They’ll be working with us over the next four months, and we’re delighted to welcome them […]
Read more
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 DDL’s on such tables in a production environment […]
Read more
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 have […]
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
