by Carlos Tutte | Jan 18, 2022 | MySQL, Percona Software
The most common issue when using row-based replication (RBR) is replication lag due to the lack of Primary keys. The problem is that any replicated DML will do a full table scan for each modified row on the replica. This bug report explains it more in-depth:...
by Lenz Grimmer | Oct 6, 2021 | MySQL, Percona Announcements, Percona Software, Storage Engine
As we’ve communicated in our blog post in May, the TokuDB Storage Engine has been marked as “deprecated” in Percona Server for MySQL 8.0. It will be removed in a future version (Percona Server for MySQL 8.0.28, expected to ship in Q1 2022). With the release of Percona...
by Carlos Tutte | Sep 16, 2021 | Insight for DBAs, MySQL, Percona Software
When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C...
by Aleksandra Abramova | Aug 13, 2021 | MySQL, Percona Software
Note: This promotion has ended. The next 10 user reviews for Percona Server for MySQL will receive a $10 Amazon gift card from Sourceforge. Add yours now! Why does Percona value honest user reviews? They provide valuable information for engineers to guide product...
by Lenz Grimmer | Jun 1, 2021 | MySQL, Open Source, Percona Software
After Oracle released MySQL version 8.0.24 on April 20, 2021, our engineering team got started right away with merging our enhancements to prepare the corresponding 8.0.24 version of Percona Server for MySQL. However, Oracle released MySQL version 8.0.25 shortly...
by Marco Tusa | Apr 15, 2021 | Insight for DBAs, MySQL, Percona Software
While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL is executed inside a Group Replication cluster. The online DDL feature provides support for instant and in-place table alterations and...
by Mike Benshoof | Apr 6, 2021 | MySQL, Percona Software, Storage Engine
As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth. One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier. However, in many cases,...
by Mike Benshoof | Apr 1, 2021 | MySQL, Percona Software, Storage Engine
Percona Technical Account Managers get the privilege of working with some of our largest enterprise clients day in and day out. As such, we get to really focus on how to best leverage our technology to generate measurable benefits for our users. While it is fun to...
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 Marcelo Altmann | Dec 22, 2020 | Insight for DBAs, MySQL, Percona Software
MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care...
by Daniil Bazhenov | Sep 14, 2020 | MySQL, Percona Services, Percona Software
MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been...
by Kathy Williamson | Aug 18, 2020 | MySQL, Percona Software
We are excited to let you know about two upcoming changes to Percona XtraBackup which will align Percona XtraBackup Versions with Percona Server for MySQL. These changes are to bring Percona XtraBackup release naming line with Percona Server and MySQL and ensure...
by Tibor Korocz | Aug 6, 2020 | Benchmarks, MySQL, Percona Software
Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity. First of all, why do we need another storage...
by Peter Zaitsev | Apr 13, 2020 | Benchmarks, MySQL, Percona Software
When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address – “localhost” or 127.0.0.1 – or use Unix Domain Socket. If you have a choice (if your application supports both methods), use...
by Borys Belinsky | Feb 11, 2020 | MySQL, Percona Software, ProxySQL
ProxySQL 1.4.16, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL, and database servers in the MySQL ecosystem...
by Vadim Tkachenko | Jan 17, 2020 | MySQL, Percona Software
Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations. For this I planned to use three bare metal nodes, SSD...
by Daniel Guzmán Burgos | Nov 1, 2019 | Insight for DBAs, MariaDB, MySQL
Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket. Neither of these plugins is new, and some words have been written about the auth_socket on...
by Borys Belinsky | Oct 23, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.7, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includesPSQLADM-204: Add support of...
by Borys Belinsky | Aug 21, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.6, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includesDocker images for release...
