by Marcelo Altmann | Oct 23, 2020 | Insight for DBAs, MySQL, Percona Software
Earlier this week, Oracle released their Q4 releases series. As on the previous releases, backward compatibility has been broken with previous versions of the server. This time on both MySQL 5.7 and 8.0: MySQL 5.7.32 While our QA team was performing an extensive test...
by Vadim Tkachenko | Oct 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a snapshot of data volume and later to clone into a new volume, which opens a variety of possibilities like instant backups or testing upgrades. This...
by Steve Hoffman | Oct 22, 2020 | Insight for DBAs, Monitoring, Percona Software
About the Author – This blog was written as a collaboration with my colleague Jiri Ctvrtka. Jiri is a senior software developer from Brno, Czech Republic, and has been partnering with Percona for almost a year working on various components of our Percona...
by Diana Muina | Oct 20, 2020 | Insight for DBAs, Percona Services, Percona Software
There is an on-going shift within many organizations where the focus placed on application engineers is expanding while at the same time infrastructure teams within the DBA landscape are being trimmed back. The result is application engineers with little to no...
by Carlos Tutte | Oct 16, 2020 | Insight for DBAs, MySQL, Percona Software
Changing the default value (3) of log_error_verbosity in MySQL/Percona Server for MySQL 5.7 can have a hidden unintended effect! What does log_error_verbosity do exactly? As per the documentation: “The log_error_verbosity system variable specifies the verbosity for...
by Mike Grayson | Oct 16, 2020 | Insight for DBAs, MongoDB, Percona Software
MongoDB is one of the most popular databases and is one of the easiest NoSQL databases to set up for a DBA. Oftentimes, relational DBAs will inherit MongoDB databases without knowing all there is to know about MongoDB. I encourage you to check out our Percona blogs...
by Peter Zaitsev | Oct 14, 2020 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
I am very passionate about database observability, and I believe query performance observability is the most important insight you can get in your database. Why? Because if you look from an application developer’s point of view, once a database is provisioned and you...
by Vadim Yalovets | Oct 12, 2020 | Insight for DBAs, Monitoring, Percona Software
From time to time we are asked how to limit users to viewing only some dashboards or servers in Percona Monitoring and Management (PMM). Here are some hints on how to do this. Let’s imagine you want the following: Users user1 and user2 are only allowed to see...
by Rituja Borse | Oct 8, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is a free and open source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL databases. In this blog, we will look at troubleshooting MySQL issues and performance bottlenecks with the help of PMM. We can start...
by Przemysław Malkowski | Oct 8, 2020 | Insight for DBAs, MySQL, Percona Software
Recently I was dealing with an unexpected issue raised by our Support customer, in which data became inconsistent after a schema change was applied. After some investigation, it turned out that affected tables had a special word in the comments of some columns, which...
by Daniel Guzmán Burgos | Oct 7, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Visibility is a blessing, and with databases, visibility is a must. That’s true not only for metrics but for the queries themselves. Having info on all the stats around query execution is priceless, and Percona Monitoring and Management (PMM) offers that in the form...
by David Quilty | Oct 7, 2020 | Insight for DBAs, Insight for Developers, Webinars
Any good system must be built to expect the unexpected. None are perfect and at some point, something WILL happen to render the system non-operational causing failure. Join Dimitri Vanoverbeke, Senior Percona Engineer, as he discusses the concepts of High...
by Vasyl Yurkovych | Oct 7, 2020 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Hey Community! This is my first blog post so let me introduce myself. My name is Vasyl Yurkovych. I am a QA Automation Engineer at Percona and I have solid experience in software testing. Software quality is one of the main focuses of Percona so we put a lot of...
by Walter Garcia | Oct 2, 2020 | Insight for DBAs, Insight for Developers, MySQL
Hello everyone, in this little post we will review a new feature in MySQL 8. What is “CHECK Constraint”? This is a new feature to specify a condition to check the value before INSERT or UPDATE into a row. The constraint could return an error if the result...
by Sri Sakthivel | Oct 2, 2020 | Insight for DBAs, MariaDB, MySQL
MariaDB 10.5 was released in June 2020 and it will be supported until June 2025. This is the current stable version and comes with more exciting new features. In this blog, I am going to explain the new and exciting features involved in MariaDB 10.5. Amazon S3 engine...
by Daniel Guzmán Burgos | Oct 2, 2020 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control writes to the database, is the Rate limit. It’s also lately one of the most popular conversations around the community. But what is it? In plain...
by Ibrar Ahmed | Oct 1, 2020 | Insight for DBAs, Open Source, PostgreSQL
There have been many big features added to PostgreSQL 13, like Parallel Vacuum, de-duplication of indexes, etc., and a complete list can be found at PostgreSQL 13 release notes. Along with the big features, there are also small ones added, including dropdb...
by David Quilty | Oct 1, 2020 | Insight for DBAs, MongoDB, Percona Software, Webinars
This webinar will be delivered in Italian. MongoDB is the most used document-oriented database but some of the more requested features are available only in the Enterprise version. Percona Server for MongoDB (PSMDB) is an alternative to MongoDB with its open source,...
by Francisco Bordenave | Sep 30, 2020 | Insight for DBAs, MySQL, Storage Engine
In this post, we will discuss what to do when you add more memory to your instance. Adding memory to a server where MySQL is running is common practice when scaling resources. First, Some Context Scaling resources is just adding more resources to your environment, and...
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...
