Thu, 28 Mar 2024 16:51:28 +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/how-missing-primary-keys-break-your-galera-cluster/ https://www.percona.com/blog/how-missing-primary-keys-break-your-galera-cluster/#respond Thu, 28 Mar 2024 16:50:18 +0000 https://www.percona.com/blog/?p=95436 Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side-effects such as inconsistent ordering: rows can appear in different order on different nodes in your cluster.If you are not actively relying on row orders, this could seem acceptable. Deletes […]]]> https://www.percona.com/blog/how-missing-primary-keys-break-your-galera-cluster/feed/ 0 95436 https://www.percona.com/blog/consequences-of-forcing-bootstrap-on-percona-xtradb-cluster/ https://www.percona.com/blog/consequences-of-forcing-bootstrap-on-percona-xtradb-cluster/#respond Wed, 28 Jun 2023 12:02:50 +0000 https://www.percona.com/blog/?p=89046 Recently, I was working on a very unfortunate case that revolved around diverging clusters, data loss, missing important log errors, and forcing commands on Percona XtraDB Cluster (PXC). Even though PXC tries its best to explain what happens in the error log, I can vouch that it can be missed or overlooked when you do not […]]]> https://www.percona.com/blog/consequences-of-forcing-bootstrap-on-percona-xtradb-cluster/feed/ 0 89046