by Eduardo Krieg | Jan 8, 2024 | Insight for DBAs, MySQL
One of the most underlooked parameters to configure MySQL is server_id, which is an integer number to identify a server inside a replication topology uniquely. Note that two servers within a replication set can’t have the same server_id value.It is generally set... by Eduardo Krieg | Jun 23, 2023 | Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups.It is a good practice to compress the backups to save costs on storage and to encrypt the... by Eduardo Krieg | Jan 19, 2023 | Insight for DBAs, MySQL, Percona Software
16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and we will cover more on this blog. While the technologies have evolved and matured enough, there are still some people thinking that MySQL is only...