by Borys Belinsky | Feb 28, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.25-31.35 on February 28, 2018. Binaries are available from the downloads section or from our software repositories. This release of Percona XtraDB Cluster includes the support of Ubuntu 18.10...
by Dmitriy Kostiuk | Jan 4, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.42-28.30 (PXC) on January 4, 2019. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.42-28.30 is now the current release, based on the following:...
by Dmitriy Kostiuk | Jan 4, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.24-31.33 (PXC) on January 4, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.24-31.33 is now the current release, based on the...
by Tibor Korocz | Jan 2, 2019 | MySQL, Percona Software
Recently, I encountered a situation where MySQL gave error messages that I had never seen before: MySQL 2018-12-12T14:36:45.571440Z 0 [ERROR] Error log throttle: 150 'Can't create thread to handle new connection' error(s) suppressed 2018-12-12T14:36:45.571456Z 0...
by Marco Tusa | Nov 15, 2018 | Insight for DBAs, MySQL, PostgreSQL
In this series of blog posts, I’m going to look at some high availability reference architecture solutions over geographically distributed areas. The Problem Nowadays, when businesses plan a new service or application, it is very common for them to worry about...
by Tibor Korocz | Nov 2, 2018 | Cloud
Recently, I’ve been working with a customer to evaluate the different cloud solutions for MySQL. In this post I am going to focus on maintenance windows and requirements, and what the different cloud platforms offer. Why is this important at all? Maintenance...
by Tibor Korocz | Oct 17, 2018 | Insight for DBAs, MySQL
Parallel replication has been around for a few years now but is still not that commonly used. I had a customer where the master had a very large write workload. The slave could not keep up so I recommended to use parallel slave threads. But how can I measure if it...
by Borys Belinsky | Oct 2, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
To resolve a critical regression, Percona announces the release of Percona XtraDB Cluster 5.7.23-31.31.2 on October 2, 2018 Binaries are available from the downloads section or from our software repositories. This release resolves a critical regression in...
by Borys Belinsky | Sep 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
This release has been superseded by 5.7.23-31.31.2 after a critical regression was found. Please update to the latest release. Percona is glad to announce the release of Percona XtraDB Cluster 5.7.23-31.31 on September 26, 2018. Binaries are available from...
by Dmitriy Kostiuk | Sep 18, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.41-28.28 (PXC) on September 18, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.41-28.28 is now the current release, based on the following:...
by Jaime Sicam | Jul 2, 2018 | Insight for DBAs, MySQL
GTID replication has made it convenient to setup and maintain MySQL replication. You need not worry about binary log file and position thanks to GTID and auto-positioning. However, things can go wrong when pointing a slave to a different master. Consider a situation...
by Dmitriy Kostiuk | Jun 29, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.22-29.26 (PXC) on June 29, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.22-29.26 is now the current release, based on the following: Percona...
by Dmitriy Kostiuk | Jun 20, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.40-26.25 (PXC) on June 20, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.40-26.25 is now the current release, based on the following: Percona...
by Marco Tusa | Jun 12, 2018 | MySQL, Percona Software, Security
Let them stay together. In the last YEARS, I have seen quite often that users, when installing a product such as PXC, instead of spending five minutes to understand what to do just run iptables -F and save. In short, they remove any rules for their firewall. With...
by Sveta Smirnova | May 21, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Please join Percona’s Principal Support Escalation Specialist, Sveta Smirnova, as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now ...
by Tibor Korocz | May 9, 2018 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Yes, it does! In this blog post, I am going to share my recent experiences with ProxySQL and how important the database software version number can be. Migration I was working on a migration to Percona XtraDB Cluster (PXC) with ProxySQL, fortunately on a staging...
by Roel Van de Paar | Apr 27, 2018 | Insight for DBAs, MySQL, Open Source
What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA? When it comes to being a software critic, a lot. In many ways, the work of a software critic is easy. We risk very little and thrive on negative...
by Dmitriy Kostiuk | Apr 16, 2018 | Insight for DBAs, MariaDB, MySQL
Due to continuous development and improvement, Percona Server for MySQL incorporates a number of improvements related to binary log handling and replication. This results in replication specifics, distinguishing it from MySQL Server. Temporary tables and mixed logging...
by Sveta Smirnova | Apr 4, 2018 | Insight for DBAs, MySQL
In this blog, I will provide answers to the Q & A for the Performance Schema for MySQL Troubleshooting webinar. First, I want to thank everybody for attending my March 1, 2018, webinar. The recording and slides for the webinar are available here. Below is the list...
by Corrado Pandiani | Mar 29, 2018 | MySQL, ProxySQL
In this blog post, we’ll look at using ProxySQL and VIRTUAL columns to solve object-relational mapping (ORM) issues. There are a lot of web frameworks all around. Programmers and web designers are using them to develop and deploy any website and web application....
