Fri, 16 Feb 2024 21:49:13 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/faster-streaming-backups-introducing-percona-xtrabackup-fifo-parallel-stream/ https://www.percona.com/blog/faster-streaming-backups-introducing-percona-xtrabackup-fifo-parallel-stream/#respond Tue, 25 Jul 2023 12:12:45 +0000 https://www.percona.com/blog/?p=88580 When it comes to backups, there are several options for saving backup files. You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. Percona XtraBackup facilitates streaming through the use of an auxiliary tool called xbcloud.STDOUT DatasinkThis diagram displays the process of streaming […]]]> https://www.percona.com/blog/faster-streaming-backups-introducing-percona-xtrabackup-fifo-parallel-stream/feed/ 0 88580 https://www.percona.com/blog/percona-xtrabackup-now-supports-iam-instance-profile/ https://www.percona.com/blog/percona-xtrabackup-now-supports-iam-instance-profile/#respond Fri, 10 Feb 2023 13:13:21 +0000 https://www.percona.com/blog/?p=85162 https://www.percona.com/blog/percona-xtrabackup-now-supports-iam-instance-profile/feed/ 0 85162 https://www.percona.com/blog/making-your-mysql-backup-process-faster-introducing-percona-xtrabackup-smart-memory-estimation/ https://www.percona.com/blog/making-your-mysql-backup-process-faster-introducing-percona-xtrabackup-smart-memory-estimation/#comments Fri, 18 Nov 2022 14:32:28 +0000 https://www.percona.com/blog/?p=83616 Taking a MySQL backup using Percona XtraBackup (PXB) consists of basically two steps: 1) take the backup and 2) prepare the backup.Briefly speaking, taking a backup means that PXB will copy all of the files from your instance and transfer them to another location. While it does the copy, it spawns a thread that will […]]]> https://www.percona.com/blog/making-your-mysql-backup-process-faster-introducing-percona-xtrabackup-smart-memory-estimation/feed/ 2 83616 https://www.percona.com/blog/get-your-backup-to-half-of-its-size-introducing-zstd-support-in-percona-xtrabackup/ https://www.percona.com/blog/get-your-backup-to-half-of-its-size-introducing-zstd-support-in-percona-xtrabackup/#comments Thu, 17 Nov 2022 13:00:23 +0000 https://www.percona.com/blog/?p=83604 Having a backup of your database is like insurance, you have to pay a monthly price to ensure you have a service available when you need to. When talking about backups, the storage required to keep your backups is what comes into factor when talking about price, the bigger your backup, or the bigger the […]]]> https://www.percona.com/blog/get-your-backup-to-half-of-its-size-introducing-zstd-support-in-percona-xtrabackup/feed/ 10 83604 https://www.percona.com/blog/percona-xtrabackup-8-0-29-and-instant-add-drop-columns/ https://www.percona.com/blog/percona-xtrabackup-8-0-29-and-instant-add-drop-columns/#comments Tue, 19 Jul 2022 12:53:05 +0000 https://www.percona.com/blog/?p=81836 Oracle’s MySQL 8.0.29 release extended the support for ALTER TABLE … ALGORITHM=INSTANT to 1) allow users to instantly add columns in any position of the table, and 2) instantly drop columns. As part of this work, the InnoDB redo log format has changed for all DML operations on the server. This new redo log format […]]]> https://www.percona.com/blog/percona-xtrabackup-8-0-29-and-instant-add-drop-columns/feed/ 19 81836 https://www.percona.com/blog/mysql-8-0-29-and-percona-xtrabackup-incompatibilities/ https://www.percona.com/blog/mysql-8-0-29-and-percona-xtrabackup-incompatibilities/#comments Mon, 09 May 2022 13:48:59 +0000 https://www.percona.com/blog/?p=80924 Earlier last week, Oracle released their Q2 releases series. Unlike previous releases, backward compatibility has now been broken with previous versions of MySQL.MySQL 8.0.29 extended the support for the online DDL algorithm INSTANT. Prior to 8.0.29 only adding columns to the end of the table was supported.In 8.0.29, this functionality was extended to allow the […]]]> https://www.percona.com/blog/mysql-8-0-29-and-percona-xtrabackup-incompatibilities/feed/ 6 80924 https://www.percona.com/blog/percona-xtrabackup-changing-to-strict-by-default/ https://www.percona.com/blog/percona-xtrabackup-changing-to-strict-by-default/#respond Thu, 20 Jan 2022 13:50:50 +0000 https://www.percona.com/blog/?p=79859 Backups are a key part of a disaster recovery strategy, making sure you can continue or restore your business in case of an unwanted event with your data.We always work on trying to improve Percona XtraBackup reliability, always favoring consistency, attempting to make unwanted outcomes be noticed as earlier as possible in the process.Enabling –strict […]]]> https://www.percona.com/blog/percona-xtrabackup-changing-to-strict-by-default/feed/ 0 79859 https://www.percona.com/blog/introducing-xbcloud-exponential-backoff-feature-in-percona-xtrabackup/ https://www.percona.com/blog/introducing-xbcloud-exponential-backoff-feature-in-percona-xtrabackup/#comments Thu, 02 Sep 2021 12:02:15 +0000 https://www.percona.com/blog/?p=77939 Storing your data locally can impose security and availability risks. Major cloud providers have object storage services available to allow you to upload and distribute data across different regions using various retention and restore policies.Percona XtraBackup delivers the xbcloud binary – an auxiliary tool to allow users to upload backups to different cloud providers directly.Today […]]]> https://www.percona.com/blog/introducing-xbcloud-exponential-backoff-feature-in-percona-xtrabackup/feed/ 1 77939 https://www.percona.com/blog/replay-the-execution-of-mysql-with-rr-record-and-replay/ Mon, 12 Apr 2021 19:00:26 +0000 https://www.percona.com/blog/?p=75414 Chasing bugs can be a tedious task, and multi-threaded software doesn’t make it any easier. Threads will be scheduled at different times, instructions will not have deterministic results, and in order for one to reproduce a particular issue, it might require the exact same threads, doing the exact same work, at the exact same time. […]]]> 75414 https://www.percona.com/blog/percona-xtrabackup-introducing-support-for-storage-class-in-xbcloud/ Mon, 28 Dec 2020 14:10:17 +0000 https://www.percona.com/blog/?p=72823 A lot of elements take part in a good backup strategy. Two of them are: Where to store your backups – Never on the same server. Preferable not in the same datacenter. Ideally far enough so you can restore in case of a natural disaster (region flood, extended local power outage, etc…). Retention period – […]]]> 72823 https://www.percona.com/blog/redesign-of-lock-ddl-per-table-in-percona-xtrabackup/ https://www.percona.com/blog/redesign-of-lock-ddl-per-table-in-percona-xtrabackup/#comments Tue, 22 Dec 2020 13:05:26 +0000 https://www.percona.com/blog/?p=73108 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 for backup tools. To block DDL statements on an instance, Percona Server for MySQL […]]]> https://www.percona.com/blog/redesign-of-lock-ddl-per-table-in-percona-xtrabackup/feed/ 1 73108 https://www.percona.com/blog/say-hello-to-libcoredumper-a-new-way-to-generate-core-dumps-and-other-improvements/ https://www.percona.com/blog/say-hello-to-libcoredumper-a-new-way-to-generate-core-dumps-and-other-improvements/#comments Wed, 28 Oct 2020 14:41:43 +0000 https://www.percona.com/blog/?p=69951 In a perfect world, we expect all software to run flawlessly and never have problems such as bugs and crashes. We also know that this perfect world doesn’t exist and we better be as prepared as possible to troubleshoot those types of situations. Historically, generating core dumps has been a task delegated to the kernel. […]]]> https://www.percona.com/blog/say-hello-to-libcoredumper-a-new-way-to-generate-core-dumps-and-other-improvements/feed/ 3 69951 https://www.percona.com/blog/mysql-new-releases-and-percona-xtrabackup-incompatibilities/ https://www.percona.com/blog/mysql-new-releases-and-percona-xtrabackup-incompatibilities/#comments Fri, 23 Oct 2020 15:43:24 +0000 https://www.percona.com/blog/?p=72177 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.32While our QA team was performing an extensive test on it,  we found out this version introduced a new compression format version. […]]]> https://www.percona.com/blog/mysql-new-releases-and-percona-xtrabackup-incompatibilities/feed/ 9 72177 https://www.percona.com/blog/finding-a-regression-in-mysql-source-code-a-case-study/ Thu, 06 Aug 2020 18:12:30 +0000 https://www.percona.com/blog/?p=70356 At the Percona engineering team, we often receive requests to analyze changes in MySQL/Percona Server for MySQL behavior from one version to another, either due to regression or a bug fix (when having to point out to a customer that commit X has fixed their issue and upgrading to a version including that fix will […]]]> 70356 https://www.percona.com/blog/configuring-proxysql-binlog-reader/ https://www.percona.com/blog/configuring-proxysql-binlog-reader/#comments Tue, 18 Feb 2020 17:26:18 +0000 https://www.percona.com/blog/?p=62606 In a previous post, MySQL High Availability: Stale Reads and How to Fix Them, I’ve talked about the challenges of scaling out reads, where some types of applications cannot tolerate reading stale data. One of the ways of fixing it is by using ProxySQL Binlog Reader.Long story short, binlog reader is a lightweight binary that […]]]> https://www.percona.com/blog/configuring-proxysql-binlog-reader/feed/ 1 62606 https://www.percona.com/blog/simulating-innodb-secondary-index-corruption/ https://www.percona.com/blog/simulating-innodb-secondary-index-corruption/#comments Wed, 04 Sep 2019 14:17:46 +0000 https://www.percona.com/blog/?p=61756 Working as a support engineer here at Percona is amazing, as you get a variety of requests, ranging from the most trivial questions to questions that require source code review and understanding of the internals of InnoDB, for example.In our world where High Availability is a must, everything is about being pro-active, and when we […]]]> https://www.percona.com/blog/simulating-innodb-secondary-index-corruption/feed/ 1 61756 https://www.percona.com/blog/percona-university-travels-to-south-america/ https://www.percona.com/blog/percona-university-travels-to-south-america/#comments Wed, 27 Mar 2019 15:28:39 +0000 https://www.percona.com/blog/?p=56135 We started hosting Percona University a few years back with the aim of sharing knowledge with the open source database community. The events are held in cities across the world. The next Percona University days will visiting Uruguay, Argentina, and Brazil, in a lightning tour at the end of April. Montevideo, Tuesday, April 23 2019 […]]]> https://www.percona.com/blog/percona-university-travels-to-south-america/feed/ 4 56135 https://www.percona.com/blog/reducing-high-cpu-on-mysql-a-case-study/ https://www.percona.com/blog/reducing-high-cpu-on-mysql-a-case-study/#comments Thu, 07 Mar 2019 15:17:35 +0000 https://www.percona.com/blog/?p=55561 In this blog post, I want to share a case we worked on a few days ago. I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting. The customer had noticed a linear high CPU usage in one of their MySQL instances […]]]> https://www.percona.com/blog/reducing-high-cpu-on-mysql-a-case-study/feed/ 8 55561 https://www.percona.com/blog/percona-xtrabackup-now-supports-dump-of-innodb-buffer-pool/ https://www.percona.com/blog/percona-xtrabackup-now-supports-dump-of-innodb-buffer-pool/#comments Tue, 26 Feb 2019 10:38:24 +0000 https://www.percona.com/blog/?p=54554 InnoDB keeps hot data in memory on its buffer named InnoDB Buffer Pool. For a long time, when a MySQL instance needed to bounce, this hot cached data was lost and the instance required a warm-up period to perform as well as it did before the service restart.That is not the case anymore. Newer versions […]]]> https://www.percona.com/blog/percona-xtrabackup-now-supports-dump-of-innodb-buffer-pool/feed/ 2 54554 https://www.percona.com/blog/mysql-high-availability-stale-reads-and-how-to-fix-them/ https://www.percona.com/blog/mysql-high-availability-stale-reads-and-how-to-fix-them/#comments Thu, 29 Nov 2018 14:51:48 +0000 https://www.percona.com/blog/?p=53856 Continuing on the series of blog posts about MySQL High Availability, today we will talk about stale reads and how to overcome this issue.The ProblemStale reads is a read operation that fetches an incorrect value from a source that has not synchronized an update operation to the value (source Wiktionary).A practical scenario is when your […]]]> https://www.percona.com/blog/mysql-high-availability-stale-reads-and-how-to-fix-them/feed/ 6 53856