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....
by Sveta Smirnova | Mar 27, 2018 | Insight for DBAs, MySQL, Storage Engine
In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table. In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas...
by Jaime Sicam | Mar 26, 2018 | Insight for DBAs, MySQL, Percona Software
In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these...
by Tibor Korocz | Mar 19, 2018 | Insight for DBAs, MySQL
From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time....
by Tibor Korocz | Mar 15, 2018 | Monitoring, MySQL, Percona Software, ProxySQL
In this blog post, we’ll look at how you can verify query performance using ProxySQL. In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could...
by Sveta Smirnova | Mar 14, 2018 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Basic Internal Troubleshooting Tools for MySQL Server webinar. First, I want to thank everybody for attending my February 15, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for...
by Robert Golebiowski | Mar 8, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Security
In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL. Why do I need this? As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between...
by Dmitriy Kostiuk | Mar 2, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.21-29.26 (PXC) on March 2, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.21-29.26 is now the current release, based on the following: Percona...
by Tate McDaniel | Mar 1, 2018 | Monitoring, MySQL, Percona Software
by Sveta Smirnova | Feb 28, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version 5.5,...
