by Jobin Augustine | May 21, 2020 | Insight for DBAs, Insight for Developers, PostgreSQL
Missing Piece: Failover of the Logical Replication Slot Logical decoding capability has existed in PostgreSQL for the last several versions, and a lot more functionalities are added over time. However, one of the very crucial functionalities is still missing in...
by Yves Trudeau | May 14, 2020 | Insight for DBAs, MySQL
In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)...
by David Ducos | May 13, 2020 | Insight for DBAs, MySQL, Percona Software
pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table. In this repository, there is...
by Lalit Choudhary | May 8, 2020 | Insight for DBAs, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open source form,...
by Stephen Thorn | May 7, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
As a Solutions Engineer at Percona, one of my responsibilities is to support our customers as they investigate new and emerging technologies. This affords me the opportunity to speak to many current and new customers who partner with Percona. The topic of Kubernetes...
by Jake Davis | May 7, 2020 | Insight for DBAs, MySQL
In Percona’s Managed Services, we start up and shut down MySQL servers all the time. Over the years, we’ve seen various issues occur due to the way servers are shut down. No matter if it is a situation where unexpected errors appear in the log or...
by Ivan Groenewold | May 5, 2020 | Insight for DBAs, MongoDB
On a recent project, we were tasked with loading several billion records into MongoDB. That prompted us to dig a bit deeper into WiredTiger knobs & turns, which turned out to be a very interesting experience. What we noticed is the load started at a decent rate,...
by Jericho Rivera | May 5, 2020 | Insight for DBAs, MySQL, Percona Software
by Peter Schwaller | May 4, 2020 | Insight for DBAs, Percona Software
Ubuntu 20.04 LTS (Focal Fossa) packages have been released into our repositories. The most recent versions of Percona Server for MySQL (5.7 and 8.0), Percona XtraDB Cluster (5.7 and 8.0), Percona XtraBackup (2.4 and 8.0), Percona Server for MongoDB (3.6, 4.0, and...
by Alkin Tezuysal | May 4, 2020 | Insight for DBAs, MySQL, Percona Software
In the light of support for Percona XtraDB Cluster (PXC), the DBdeployer anniversary, and the newly released Percona XtraDB Cluster 8.0, I’m happy to announce that Giuseppe Maxia has recently updated DBdeployer to support Percona XtraDB Cluster 8.0. We at Percona,...
by Ivan Groenewold | Apr 28, 2020 | Insight for DBAs, MongoDB
If you have been working in the database field for some time, you have likely come across the need to create a new database, based on an existing one. The most common example I can think of is to create a copy of the production database for testing purposes. In the...
by Uday Varagani | Apr 24, 2020 | Insight for DBAs, Monitoring, MySQL
A couple of weeks ago, one of our customers reached us asking about the WARNING messages in their MySQL error log. After a while, there were a few more requests from some other customers asking whether to worry about these messages or not. In this post, I am going to...
by Igor Solodovnikov | Apr 24, 2020 | Insight for DBAs, MongoDB, Percona Software
Automatic Role-Based Authorization by LDAP Comes to Percona Server for MongoDB (PSMDB) In PSMDB 4.2.5-5, admins now have a way to leverage LDAP infrastructure to automatically assign database roles to LDAP-authenticated database users. The keyword is that LDAP...
by Jaime Sicam | Apr 21, 2020 | Insight for DBAs, MongoDB, Security
Since the release of Percona Server MongoDB 3.6.13 (PSMDB), you have been able to use Vault to store the encryption keys for data at rest encryption. Here’s how to set it up. First, you need to have a Vault server up and running. My colleague, Jericho, has an...
by Akira Kurogane | Apr 20, 2020 | Database Trends, Insight for DBAs, MongoDB
“Get big fast” was a mantra in the second eCommerce boom. MongoDB’s success during its startup years was due in large part to being the best database to support that. But maybe, after your growth years, the data’s rent bill has become a little...
by Jobin Augustine | Apr 16, 2020 | Insight for DBAs, Insight for Developers, PostgreSQL
This is one of the most common questions asked by developers who write SQL queries against the PostgreSQL database. There are multiple ways in which a sub select or lookup can be framed in a SQL statement. PostgreSQL optimizer is very smart at optimizing queries, and...
by Sveta Smirnova | Apr 9, 2020 | Insight for DBAs, MySQL, Open Source
March is not only the month when a pandemic closed all borders and people had to stay home on the quarantine; it’s also the month when daylight saving time change happens. For some regions, this is not only a time change but also a switch to a different...
by Michael Patrick | Apr 8, 2020 | Database Trends, Insight for DBAs, Percona Services
As I interface with large clients as a Technical Account Manager (TAM) at Percona, one thing I have noticed is the evolution of the DBA role. With the rise of the cloud, DBAs seem to be spending less time doing traditional DBA roles of performance tuning, configuring...
by Peter Zaitsev | Apr 7, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here. 13. Configure MySQL Server Properly Complexity:Medium Potential Impact: High A poorly...
by Peter Zaitsev | Apr 6, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here and part three can be found here. 7. Get More Memory Complexity: Low Potential Impact: High If your data does not fit into...
![[Warning] InnoDB: Difficult to Find Free Blocks in the Buffer Pool](https://www.percona.com/blog/wp-content/uploads/2020/04/InnoDB-Buffer-Pool.png)
