Percona XtraDB Cluster 5.7.26-31.37 Is Now Available
1 hour ago, percona

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the following: Percona Server for MySQL 5.7.26-29 Codership WSREP API release 5.7.25 Codership Galera library 3.26 All Percona […]...

Stored Functions and Temporary Tables are Not a Good Fit
6 hours ago, percona

In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we aren’t cautious. For this example, I am only going to use the SLEEP function to demonstrate the issue, but you […]...

Percona Live Europe 2019 Call for Papers is Now Open!
1 day ago, percona

The Call for Papers for Percona Live Europe 2019 is now open!  This year’s conference will be held September 30 – October 2, 2019 in Amsterdam, the Netherlands. Percona Live is the one conference for the entire open source database community, especially for MySQL, PostgreSQL, MongoDB, and MariaDB. The theme of the 2019 conference is […]...

Upcoming Webinar 6/26: MongoDB Data Security – Custom Rules and Views
1 day ago, percona

Please join Percona’s Senior Support Engineer Adamo Tonete as he presents “MongoDB Data Security – Custom Rules and Views” on Wednesday, June 26th, 2019 at 11:00 AM PDT (UTC-7). Register Now In this presentation, we will discuss how to create custom rules when the default rules are not enough for the application. Have you ever […]...

Adaptive Hash Index on AWS Aurora
1 day ago, percona

Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why. I am not going to go into the details of how Aurora works, as there are...

Diving into the MongoDB 4.2 Release Small Print
1 day ago, percona

In my previous blog post “Percona’s View on MongoDB’s 4.2 Release – The Good, the Bad, and the Ugly…” I discussed the release of transaction support in sharded clusters, field-level encryption, search-engine integration, and the new update command syntaxes. Those are all very important, but to me making MongoDB easier to use and removing technical […]...

pt-kill: How it Works
2 days ago, percona

I receive many questions about errors being reported about pt-kill… and often those errors are not real. The main problem I have found is that pt-kill is hard to understand and the documentation doesn’t have many examples (I’ll add them), so, I decided to write a post about the most common usage of pt-kill: to […]...

Managing Multiple PostgreSQL Instances on Ubuntu/Debian
2 days ago, percona

Introduction Those DBAs who are experts in one database system look for other database systems to have “similar features”. It is a human tendency to look at any new technology and compare it with a world they are familiar with. Most of the time, I keep addressing Oracle DBAs who are looking for similar features […]...

Upcoming Webinar 6/25: MongoDB Transactions
2 days ago, percona

Please join Percona’s Support Engineer Aayushi Mangal as she presents “MongoDB Transactions” on Tuesday, June 25th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 PM EDT (UTC-4). Register Now Transactions are a feature of RDBMS systems, but MongoDB is a document-oriented non-RDBMS database. It is widely known for its simplicity of importing data and the […]...

Hypothetical Indexes in PostgreSQL
5 days ago, percona

At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?“. The answer to that question is EXPLAIN <QUERY>. However, if you wish to run an [crayon-5d0d1bade6f23483433034-i/] that runs that SQL and provides the run […]...

Percona Server for MongoDB 3.6.13-3.3 Is Now Available
5 days ago, percona

Percona announces the release of Percona Server for MongoDB 3.6.13-3.3 on June 21, 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 3.6 Community Edition. It supports MongoDB 3.6 protocols and drivers. Percona […]...

Percona’s View on MongoDB’s 4.2 Release – The Good, the Bad, and the Ugly…
5 days ago, percona

Part 1 of 2: The keynote-marketed features Percona’s MongoDB Tech Lead Akira Kurogane takes a look at MongoDB’s 4.2 release. Initial thoughts? Some great! Some not so compelling. Distributed Transactions Including distributed transactions is a great accomplishment, making MongoDB the only popular NoSQL distributed database to plug the gap with this fundamental feature, previously only available […]...

Percona Server for MongoDB 3.4.21-2.19 Is Now Available
6 days ago, percona

Percona announces the release of Percona Server for MongoDB 3.4.21-2.19 on June 20, 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 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. […]...

Percona Cloud Cover – For a Successful Migration to the Cloud
6 days ago, percona

We are pleased to announce the launch of Percona Cloud Cover (PCC), our new customized migration solution for companies moving databases from on-premises to DBaaS and other cloud-based solutions. We are in the middle of a seismic shift from traditional on-premises data architecture to cloud-based technology. As users become increasingly sophisticated, companies must embrace technologies […]...

Percona XtraDB Cluster 5.6.44-28.34 Is Now Available
1 week ago, percona

Percona is glad to announce the release of Percona XtraDB Cluster 5.6.44-28.34 on June 19, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.6.44-28.34 is now the current release, based on the following: Percona Server 5.6.44-86.0 Codership WSREP API release 5.6.43 Codership Galera library 3.26 All Percona software is open-source […]...

Percona’s Commitment to Supporting MongoDB Users
1 week ago, percona

Percona recognizes MongoDB’s performance, reliability, and flexibility and has been evaluating, developing, and extending MongoDB software since 2015. Along with many others, Percona believes that fully open source software provides great value to users and we will continue to follow that ethos and practice. We are involved with MongoDB software, services, and support on many […]...

Upcoming Webinar 6/19: A Deep Dive Into PostgreSQL Indexing
1 week ago, percona

Please join Percona’s Senior Software Engineer Ibrar Ahmed as he presents his talk “A Deep Dive Into PostgreSQL Indexing” on Wednesday, June 19th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and […]...

Percona Server for MongoDB – Now Featuring HashiCorp Vault Integration
1 week ago, percona

Last Friday we announced the release of Percona Server for MongoDB 4.0.10-5. This can be downloaded from the Percona website or the Percona software repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database. It is a fully compatible, drop-in replacement for MongoDB 4.0 Community Edition and doesn’t require any changes to MongoDB applications […]...

Percona Backup for MongoDB 0.5.0 Early Release is Now Available
1 week ago, percona

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 […]...

Bloom Indexes in PostgreSQL
1 week ago, percona

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 […]...

Next