by Robert Bernier | Sep 29, 2020 | Insight for DBAs, Open Source, PostgreSQL
So you’ve installed postgres onto your machine, and you want to start working with it. How? The key to understanding the post-installation procedure is to realize that it “depends”. It “depends” on the OS i.e. MSWindows vs Linux. It...
by Taras Onishchuk | Sep 25, 2020 | Insight for DBAs, MySQL, Percona Software
We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them. Most of the cases when the...
by David Quilty | Sep 24, 2020 | Cloud, Insight for DBAs, Open Source, Webinars
Database-as-a-service (DBaaS) can be thought of as a platform that can be used to manage an organization’s database environment(s). One of the most well known DBaaS platforms is Aurora powered by AWS. In this webinar, Ananias Tsalouchidis, Senior MySQL DBA at...
by Mike Grayson | Sep 21, 2020 | Insight for DBAs, Insight for Developers, MongoDB, Security
As with any database platform, MongoDB security is of paramount importance to keeping your data safe. MongoDB and other data platforms like Redis and Elasticsearch are often in the news for data breaches because of misconfigured settings in the database. So how do...
by Vadim Tkachenko | Sep 16, 2020 | Benchmarks, Insight for DBAs, MongoDB
There is a special collection of database bugs when the system starts to perform worse when given more resources. Examples of such bugs for MySQL I have: Bug #15815 – This is where InnoDB on an 8-CPU system performed worse than on a 4-CPU system with increased...
by Vadim Tkachenko | Sep 15, 2020 | Benchmarks, Insight for DBAs, MongoDB
Following my previous blogs on py-tpcc benchmark for MongoDB, Evaluating the Python TPCC MongoDB Benchmark and Evaluating MongoDB Under Python TPCC 1000W Workload, and the recent release of Percona Server for MongoDB 4.4, I wanted to evaluate 4.2 vs 4.4 in similar...
by Jake Davis | Sep 15, 2020 | Insight for DBAs, MySQL
If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction. Shell...
by Peter Zaitsev | Sep 11, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer...
by Ibrar Ahmed | Sep 10, 2020 | Insight for DBAs, PostgreSQL
Indexes are one of the core features of all the database management systems (DBMS). Indexes have a very long history in PostgreSQL, which has quite a rich set of index features. PostgreSQL has B-Tree, Hash, GIN, GIST, and BRIN indexes. And because the development...
by Jobin Augustine | Sep 9, 2020 | Cloud, Insight for DBAs, PostgreSQL
It is very common to see many customer cases where a sudden increase in disk space usage is caused by a lot of WAL segments filling up the WAL directory (pg_wal). Panicking customers generally ask “Why isn’t PostgreSQL deleting them?”. The most...
by Daniel Guzmán Burgos | Sep 8, 2020 | Cloud, Insight for DBAs, MySQL
MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of...
by Lalit Choudhary | Aug 31, 2020 | Insight for DBAs, Insight for Developers, 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 Jobin Augustine | Aug 21, 2020 | Insight for DBAs, PostgreSQL
I find myself discussing and explaining sychronous_commit with many PostgreSQL users, especially with novice users. So, I thought of noting down all the key points as a blog post which will be useful for more users. Recently I got an opportunity to talk about some...
by Diana Muina | Aug 17, 2020 | Insight for DBAs, Monitoring, Percona Software
Every software story starts with a simple idea of how to serve a specific user need. However, with the growing number of applications and ways to deploy those applications (on-premise or in the cloud or both) our environments are becoming more and more complex. But...
by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Part one of this series can be found here: How Many innodb_buffer_pool_instances Do You Need in MySQL 8? Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I...
by Vadim Tkachenko | Aug 13, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I wanted to dig a little deeper and understand how different MySQL parameters affect performance. One of the...
by Carlos Tutte | Aug 12, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Disclaimer: the following script only works for Percona Server for MySQL 5.7, and relies on enabling performance schema (PS) instrumentation which can add overhead on high concurrent systems, and is not intended for continuous production usage as it’s a POC (proof of...
by Sri Sakthivel | Aug 7, 2020 | Insight for DBAs, Insight for Developers, MySQL
Rewriting a MySQL query for performance is an important process that every DBA should be aware of so they can fix the wrong queries on runtime without code changes on the application end. ProxySQL has great support for rewriting the queries, which Alkin Tezuysal...
by Matt Yonkovit | Aug 5, 2020 | Database Trends, Insight for DBAs, Security
How many times have we seen this headline lately: “X million records leaked in data breach”? The answer is, too many! In fact, because “millions of records” are starting to leak so frequently, larger news outlets are not covering the “smaller” leaks as often as they...
by Agustín | Aug 4, 2020 | Cloud, Insight for DBAs, Monitoring, Percona Software
In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2. Installing Dependencies First, let’s get some basic packages out of the way,...
