by Marcelo Altmann | Jul 25, 2023 | Insight for DBAs, MySQL, Percona Software
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... by Marcelo Altmann | Feb 10, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Amazon instance profiles are used to pass IAM roles to an EC2 instance. This IAM role can be queried using EC2 instance metadata to access an S3 bucket. Please check Amazon’s Official Documentation for more information.Today we are happy to announce that... by Marcelo Altmann | Nov 18, 2022 | Insight for DBAs, MySQL, Percona Software
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.... by Marcelo Altmann | Nov 17, 2022 | Insight for DBAs, MySQL, Percona Software
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... by Marcelo Altmann | Jul 19, 2022 | Insight for DBAs, MySQL, Percona Software
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... by Marcelo Altmann | May 9, 2022 | MySQL, Percona Software
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... by Marcelo Altmann | Jan 20, 2022 | MySQL, Percona Software
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... by Marcelo Altmann | Sep 2, 2021 | Cloud, Insight for DBAs, MySQL, Percona Software
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... by Marcelo Altmann | Apr 12, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
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... by Marcelo Altmann | Dec 28, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
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... 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 Marcelo Altmann | Oct 28, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
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,... by Marcelo Altmann | Oct 23, 2020 | Insight for DBAs, MySQL, Percona Software
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.32 While our QA team was performing an extensive test... by Marcelo Altmann | Aug 6, 2020 | Insight for DBAs, Insight for Developers, MySQL
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... by Marcelo Altmann | Feb 18, 2020 | ProxySQL
by Marcelo Altmann | Sep 4, 2019 | MySQL
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... by Marcelo Altmann | Mar 27, 2019 | MariaDB, MongoDB, MySQL, Percona Events, PostgreSQL
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... by Marcelo Altmann | Mar 7, 2019 | Insight for DBAs, MySQL, Percona Software
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... by Marcelo Altmann | Feb 26, 2019 | MySQL, Percona Software
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... by Marcelo Altmann | Nov 29, 2018 | Insight for DBAs, Insight for Developers, MySQL
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 Problem Stale reads is a read operation that fetches an incorrect value from a source that has not synchronized an update...