Jan 08, 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 up as a “random” number, just different from the one configured on […]
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 backups so those can’t be used if the files are […]
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 for small projects or that it can’t perform well with […]