by David Ducos | May 16, 2023 | Insight for DBAs, MySQL
At the end of 2021, I pushed the first Docker image to hub.docker.com. This was the first official image and since then, we have been improving our testing and packaging procedures based on Docker, CircleCI, and GitHub Actions. However, when I’m coding, ... by David Ducos | Apr 10, 2023 | Insight for DBAs, MySQL
For a long time, MyDumper has been the fastest tool to take Logical Backups. We have been adding several features to expand the use cases. Masquerade was one of these features, but it was only for integer and UUID values. In this blog post, I’m going to present... by David Ducos | Nov 30, 2022 | Cloud, Insight for DBAs, MySQL
If you are using MyDumper as your Logical Backup solution and you store your backups on S3, you need to take a local backup and then upload it to S3. But what if there is not enough space to hold the backup on the server where we are taking the backup? Even if we have... by David Ducos | Aug 17, 2022 | Insight for DBAs, MySQL
The title is not entirely true, but ‘FTWRL on MyDumper is not needed anymore for consistent backups’ was a long title. One more time, I wanted to share a new feature in MyDumper. This is related to an important piece: the locking mechanism that mydumper... by David Ducos | Jun 3, 2022 | Insight for DBAs, MySQL
As you might know, mysqldump is single-threaded and STDOUT is its default output. As MyDumper is multithreaded, it has to write on different files. Since version 0.11.3 was released in Nov 2021, we have the possibility to stream our backup in MyDumper. We thought for... by David Ducos | May 9, 2022 | Insight for DBAs, MySQL
The new MyDumper 0.12.3-1 version, which includes many new features and bug fixes, is now available. You can download the code from here. MyDumper is Open Source and maintained by the community, it is not a Percona, MariaDB, or MySQL product.In this new version... by David Ducos | 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 David Ducos | Dec 3, 2021 | Insight for DBAs, MySQL
For a long time, MyDumper has been in Max Bubenick’s personal GitHub repository. Now, we decided to move to a new MyDumper’s Organization as requested earlier this year by a user from the community.There were also two other reasons why we decided to move... by David Ducos | Dec 1, 2021 | Insight for DBAs, MySQL, Percona Software
Working on a real case scenario in a five node Percona XtraDB Cluster (PXC), we were forced to use wsrep_sync_wait = 1, because the app does reads-after-write and we send reads to all the nodes. We had the idea to leave some nodes in DESYNC mode to reduce the flow... by David Ducos | Nov 29, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.11.3 version, which includes many new features and bug fixes, is now available. You can download the code from here.We are very proud to announce that we were able to achieve the two main objectives for the milestone ZSTD and Stream... by David Ducos | Sep 21, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.11.1 version, which includes many new features and bug fixes, is now available. You can download the code from here.For this release, there are three main changes: 1) we added config file functionality which allows users to set session-level... by David Ducos | Aug 23, 2021 | Insight for DBAs, MySQL, Open Source
During the development of the myloader –innodb-optimize-keys option, which was released in version 0.10.7, we found several issues and opportunities to improve the process. We had to change the approach, reimplement some of the core functionality and add a... by David Ducos | Jul 6, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.10.7 version, which includes many new features and bug fixes, is now available. You can download the code from here.For this release, we have added several features like WHERE support that is required for partial backups. We also added... by David Ducos | Jun 8, 2021 | Insight for DBAs, MySQL
In my previous post Back From a Long Sleep, MyDumper Lives!, I told you that Fast Index Creation was in the queue and (after fixing several bugs) it will package in release 0.10.7 next month. But why am I so excited about it? Well, this feature opens new... by David Ducos | May 7, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.10.5 version, which includes many new features and bug fixes, is now available. You can download the code from here.For this release, we focused on fixing some old issues and testing old pull requests to get higher quality code. On releases... by David Ducos | Apr 21, 2021 | Insight for DBAs, MySQL, Open Source
MySQL databases keep getting larger and larger. And the larger the databases get, the harder it is to backup and restore them. MyDumper has changed the way that we perform logical backups to enable you to restore tables or objects from large databases. Over the... by David Ducos | Mar 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Starting a long time ago, we wanted to reproduce workload in a non-production environment, and there were different attempts to achieve that goal (Query Playback is just one of them). But there is another point of view, where you need to write your own workload to do... by David Ducos | Aug 28, 2020 | Insight for DBAs, MySQL, Open Source, ProxySQL
We sometimes receive challenging requests… this is a story about one of those times.The customer has implemented a sharding solution and would like us to review alternatives or improvements. We analyzed the possibility of using ProxySQL as it looked to be a... by David Ducos | May 13, 2020 | Insight for DBAs, MySQL, Percona Software
pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table. In this repository, there is... by David Ducos | Jan 2, 2020 | MySQL, ProxySQL
ProxySQL and Orchestrator are usually installed to achieve high availability when using MySQL replication. On a failover (or graceful takeover) scenario, Orchestrator will promote a slave, and ProxySQL will redirect the traffic. Depending on how your environment is...