Mon, 08 Jan 2024 17:41:57 +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/the-underlying-importance-of-the-server_id-parameter/ https://www.percona.com/blog/the-underlying-importance-of-the-server_id-parameter/#respond Mon, 08 Jan 2024 17:41:57 +0000 https://www.percona.com/blog/?p=92800 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 the […]]]> https://www.percona.com/blog/the-underlying-importance-of-the-server_id-parameter/feed/ 0 92800 https://www.percona.com/blog/is-my-backup-stuck-a-quick-guide-for-reviewing-percona-xtrabackup-threads/ https://www.percona.com/blog/is-my-backup-stuck-a-quick-guide-for-reviewing-percona-xtrabackup-threads/#comments Fri, 23 Jun 2023 13:49:12 +0000 https://www.percona.com/blog/?p=88873 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 compromised […]]]> https://www.percona.com/blog/is-my-backup-stuck-a-quick-guide-for-reviewing-percona-xtrabackup-threads/feed/ 1 88873 https://www.percona.com/blog/why-mysql-could-be-slow-large-tables https://www.percona.com/blog/why-mysql-could-be-slow-large-tables#respond Thu, 19 Jan 2023 12:40:16 +0000 https://www.percona.com/blog/?p=84691 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 […]]]> https://www.percona.com/blog/why-mysql-could-be-slow-large-tables/feed/ 0 84691