by Sri Sakthivel | Mar 26, 2021 | Insight for DBAs, Insight for Developers, MySQL, Storage Engine
For MySQL, MyISAM and InnoDB storage engines are very popular. Currently, we are mostly using InnoDB engines for high reliability and high performance. Apart from those engines, we also have some other alternative engines and they have some nice features in them. In...
by Sri Sakthivel | Mar 24, 2021 | Insight for DBAs, MySQL
Transportable tablespaces were introduced in MySQL 5.6. Using this feature, we can directly copy a tablespace to another server and populate the table with data. This is a very useful feature for large tables. The transportable tablespace mechanism is faster than any...
by David Ducos | Mar 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Starting a long time ago, we wanted to reproduce workload in a non-production environment, and there were different attempts to achieve that goal (Query Playback is just one of them). But there is another point of view, where you need to write your own workload to do...
by David Quilty | Mar 11, 2021 | Insight for DBAs, MongoDB, Webinars
Join Percona Technical Expert Corrado Pandiani as he presents a quick yet robust comparison of the different backup solutions that can be used with MongoDB. This webinar will highlight: – Terminology – Elements of MongoDB Backups – Backup &...
by Evgeniy Patlan | Mar 10, 2021 | Insight for DBAs, MySQL, Percona Software
Lately, the number of questions about how to build Percona software has been increased. More and more people try to add their own patches, add some modifications, and build software by themselves. But this raises the question of how to do this in the same way as...
by David Quilty | Mar 9, 2021 | Insight for DBAs, PostgreSQL, Webinars
Join Peter Zaitsev, Percona CEO, and Ibrar Ahmed, Percona Sr. Software Engineer, as they discuss pg_stat_monitor! If you’re tasked with optimizing PostgreSQL performance, chances are you’re relying on the pg_stat_statements extension to capture information...
by Jobin Augustine | Feb 26, 2021 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Yes, this post is about connection queueing, not just pooling. Because “connection pooling” – pre-created connections as a pool – is a much-celebrated feature. Almost every discussion on connection pool/pgBouncer starts with the overhead of...
by David Quilty | Feb 26, 2021 | Cloud, Insight for DBAs, Webinars
Join Rick Vasquez, Percona Technical Expert, as he discusses the pros and cons of moving your database to the cloud. Flexibility, performance, and cost management are three things that make cloud database environments an easy choice for many businesses. If you are...
by Sri Sakthivel | Feb 25, 2021 | Insight for DBAs, Monitoring, MySQL
MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “\show” and “\watch”. Both commands are very useful to monitor the MySQL process. It provides more insights into the foreground...
by Lalit Choudhary | Feb 25, 2021 | Insight for DBAs, Insight for Developers, Percona Software
Here 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...
by Matt Yonkovit | Feb 17, 2021 | Database Trends, Insight for DBAs, Insight for Developers
I have talked extensively about the DBA’s evolving role and how many DBA’s and operations professionals are now becoming SRE’s (site reliability engineers) or DBRE’s (database reliability engineers). Often, databases get blamed as the bottleneck for application...
by Patrick Birch | Feb 16, 2021 | Insight for DBAs, MySQL, Percona Software
MySQL 5.6.51 is the last release of the MySQL 5.6 series. Oracle will no longer provide updates or security fixes for this version. Following Percona’s Release Lifecycle policies, the Percona Server for MySQL 5.6 series has reached End of Life (EOL) as well, and...
by Akira Kurogane | Feb 15, 2021 | Cloud, Insight for DBAs, Insight for Developers
For MongoDB data directories only XFS is recommended. The ext4 filesystem isn’t so bad but when there are a very, very high number of random accesses (which WiredTiger can reach) it can hit a bottleneck. To be fair most deployments will never hit this...
by Mukesh Kumar | Feb 15, 2021 | Insight for DBAs, Insight for Developers, MongoDB
MongoDB is one of the most admired and effortless NoSQL databases to set up. Developers want to spend time building the features for their application, and with MongoDB, developers can build the application quickly while utilizing well-supported infrastructure and...
by Sri Sakthivel | Feb 11, 2021 | Insight for DBAs, MySQL, Storage Engine
The goal of this blog post is to explain the various types of transaction isolation levels available in MySQL. After reading the blog, you will be able to explain dirty reads, non-repeatable reads, and the concept of phantom rows as well. What is the Isolation Level...
by Matt Yonkovit | Feb 9, 2021 | Insight for DBAs, Insight for Developers, MongoDB
A few weeks ago I sat down and talked about tuning MongoDB memory settings with Mike Grayson, one of our MongoDB Database Engineers here at Percona. If you have not seen the video I would recommend it. Since then I have heard from people in the community about other...
by Peter Zaitsev | Feb 2, 2021 | Database Trends, Insight for DBAs, Open Source
After MongoDB switched to SSPL I wrote part one of this article, titled “Why MongoDB’s SSPL is Bad For You”. At the time it was a MongoDB phenomenon, though over the last 2+ years more companies (typically VC-funded unicorns or public companies) changed licenses to...
by Ibrar Ahmed | Feb 1, 2021 | Insight for DBAs, PostgreSQL, Security
Recently, I wrote an overview about what you need to know about PostgreSQL security. For this post, I want to write about PostgreSQL authentication. It is divided into three categories: 1. PostgreSQL Internal Authentication, 2. OS-based Authentication, and 3. External...
by Vadim Yalovets | Jan 29, 2021 | Insight for DBAs, Monitoring, Percona Software
In Percona Monitoring and Management 2.12.0 (PMM), we replaced Prometheus with VictoriaMetrics. Metrics data can now be ‘pushed’ to the server as well as being ‘pulled’ by the server. This is useful if you want to keep open ports to a minimum or your monitored system...
by Ibrar Ahmed | Jan 28, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Some time ago, I required a specific version of PostgreSQL. After searching on all the repositories, I was unable to find that specific version. It seems that the PostgreSQL community removes the old package when a new minor version comes. For example, if you need the...
