by Arunjith Aravindan | Oct 27, 2020 | Insight for DBAs, Insight for Developers, MySQL
This blog discusses new features about the persisted system variables and how we can use it to make variable changes persistent. The MySQL server maintains system variables that control its operations. The dynamic variables used prior to the MySQL 8 release are not...
by Yves Trudeau | Oct 27, 2020 | Cloud, Insight for DBAs, MySQL
If you often deploy services in the cloud, you certainly, at least once, forgot to stop a test instance. I am like you and I forgot my share of these. Another mistake I do once in a while is to provision a bigger instance than needed, just in case, and forget to...
by Sri Sakthivel | Oct 26, 2020 | Insight for DBAs, Insight for Developers, MySQL
MySQL 8.0.22 was released on Oct 19, 2020, and came with nice features and a lot of bug fixes. Now, you can configure your async replica to choose the new source in case the existing source connection (IO thread) fails. In this blog, I am going to explain the entire...
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 David Busby | Oct 23, 2020 | MongoDB, MySQL, Percona Software
CVE-2020-26542 When using the SimpleLDAP authentication in conjunction with Microsoft’s Active Directory, Percona has discovered a flaw that would allow authentication to complete when passing a blank value for the account password, leading to access against the...
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 David Quilty | Oct 22, 2020 | Cloud, MySQL, Percona Services, Webinars
Google Cloud Platform (GCP), with its CloudSQL offering, has become a leading platform for database-as-a-service workload deployments for many organizations. Scale and High Availability have surfaced as primary goals for many of these deployments. Unfortunately, the...
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 Daniil Bazhenov | Oct 12, 2020 | MongoDB, MySQL, Percona Services, Percona Software, PostgreSQL
Have you recently visited Percona’s Community Forum? It’s your hub for direct Q&A with top database experts, including Percona CEO Peter Zaitsev and CTO Vadim Tkachenko. Last quarter over 450 users participated, including 45 engineers from Percona’s staff. Since...
by Marco Tusa | Oct 9, 2020 | Benchmarks, Cloud, MySQL, ProxySQL
For what reason should I use a real multi-primary setup? To be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for Percona XtraDB Cluster (PXC) or Percona Server for MySQL using Group_replication. No, we are talking...
by Stephen Thorn | Oct 8, 2020 | Cloud, MongoDB, 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 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 Sri Sakthivel | Oct 6, 2020 | MySQL, Open Source, Percona Software
Schema changes are the big challenges in Galera replication. So, it is recommended to understand the schema changes operation for everyone who uses the Percona XtraDB Cluster (PXB)/Galera clusters. In this blog, I am going to explain the operation and impact of the...
by Daniil Bazhenov | Oct 5, 2020 | Open Source, Percona Announcements, Percona Software
Would you like to get the latest in Percona gear 100% free, shipped to you anywhere in the world? Maybe that sounds too good to be true, but it’s true! It’s easy and takes as little as 20 minutes to earn your swag. Here are some examples of the swag items you can...
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 Vadim Tkachenko | Oct 1, 2020 | Hardware and Storage, MongoDB, MySQL, Percona Software
Network volumes in Kubernetes provide great flexibility, but still, nothing beats local volumes from direct-attached storage in the sense of database performance. I want to explore ways to deploy both Percona Kubernetes Operators (Percona Kubernetes Operator for...
