by Leonardo Bacchi Fernandes | Jun 30, 2020 | Insight for DBAs, MySQL
In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its performance impacts, and we don’t recommend using it in production. Still, it is amazing at helping you understand some things that happen in MySQL, where the OS is...
by Przemysław Malkowski | Jun 29, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option. Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona...
by Brian Sumpter | Jun 29, 2020 | Insight for DBAs, Percona Services, Percona Software
In 2006, a small company formed, specializing in MySQL database consulting at a time when very few companies had fully embraced open source. This small company quickly grew, riding the wave of open source adoption within the greater enterprise market and became the...
by Robert Bernier | Jun 25, 2020 | Database Trends, Insight for DBAs, Security
Today I’m going to talk about my favorite trope, “database security”. When done right, a good security policy not only protects your data but improves performance, system stability, and enhances the development life-cycle. When done wrong it not only...
by Vadim Tkachenko | Jun 25, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
In my recent post Evaluating MongoDB Under Python TPCC 1000W Workload with MongoDB benchmarks, I showed an average throughput for a prolonged period of time (900sec or 1800sec), and the average throughput tended to smooth and hide problems. But if we zoom in to 1-sec...
by Sri Sakthivel | Jun 24, 2020 | Insight for DBAs, MySQL
Usually, database people are familiar with table fragmentation with DELETE statements. Whenever doing a huge delete, in most cases, they are always rebuilding the table to reclaim the disk space. But, are you thinking only DELETEs can cause table fragmentation?...
by Vadim Tkachenko | Jun 24, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
Following my blog post Evaluating the Python TPCC MongoDB Benchmark, I wanted to evaluate how MongoDB performs under workload with a bigger dataset. This time I will load a 1000 Warehouses dataset, which in raw format should equal to 100GB of data. For the comparison,...
by Lalit Choudhary | Jun 23, 2020 | Insight for DBAs, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build not only 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...
by Rick Golba | Jun 23, 2020 | Insight for DBAs, MySQL, Percona Software
Percona is pleased to announce the release of Percona Distribution for MySQL. Following our recent releases of Percona Distribution for MongoDB and Percona Distribution for PostgreSQL, we have assembled the best and most critical enterprise components for MySQL,...
by Carlos Tutte | Jun 19, 2020 | Insight for DBAs, Monitoring, Percona Software
Disclaimer: This blog post is about migrating Percona Monitoring and Management 2 (PMM) data between PMM2 versions, and not for migrating data from PMM1 to PMM2. Restoring data from PMM1 to PMM2 is NOT supported since there were many architectural changes. I...
by Mykola Marzhan | Jun 12, 2020 | Insight for DBAs, MySQL, Security
In most cases, MySQL password instructions provide information on changing MySQL user passwords on the production system (e.g., reset root password without restart). It is even recommended to change passwords regularly for security reasons. But still, sometimes DBA...
by Akira Kurogane | Jun 11, 2020 | Insight for DBAs, MongoDB, Open Source
by Max Dudin | Jun 11, 2020 | Insight for DBAs, MySQL, Security
Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things like SQL injections. In order to prevent such kind of an attack, we have included go-sql-driver into our code for secure placeholder...
by Akira Kurogane | Jun 11, 2020 | Insight for DBAs, MongoDB
by Ibrar Ahmed | Jun 9, 2020 | Insight for DBAs, PostgreSQL
Due to the immense generation of data, scalability has become one of the hottest topics in the field of databases. Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the...
by Daniil Bazhenov | Jun 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona engineers often need to analyze and review complex SQL database queries. Good formatting can make these SQL queries much easier to understand and work with. Without clear formatting, queries can become confusing and hard to debug. Online query formatting...
by Agustín | Jun 1, 2020 | Insight for DBAs, MySQL, Open Source
In a previous post, Using DBdeployer to manage MySQL, Percona Server, and MariaDB sandboxes, we covered how we use DBdeployer within the Support Team to easily create MySQL environments for testing purposes. Here, I will expand on what Peter wrote in Installing MySQL...
by Robert Bernier | May 29, 2020 | Insight for DBAs, PostgreSQL
Taking our cue from Peter Zaitsev’s article on MySQL Performance Bottlenecks, I’m going to talk a little about the PostgreSQL perspective of removing bottlenecks caused by high traffic. Many stacks these days are implemented by trusting the Object...
by Daniil Bazhenov | May 28, 2020 | Insight for DBAs, MySQL, Open Source, Percona Software
Open-source companies live by their community. Favorable buzz by community users is ultimately what’s made Percona software successful. Some users make further contributions in the form of expertise, source code, documentation, and more. As an open-source company in...
by Stephen Thorn | May 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Database backups are a fundamental requirement in almost every implementation, no matter the size of the company or the nature of the application. Taking a backup should be a simple task that can be automated to ensure it’s done consistently and on schedule....
