Buy Percona ServicesBuy Now!

Question in regards to Xtrabackup and primary keys in a galera cluster.

  • Filter
  • Time
  • Show
Clear All
new posts

  • Question in regards to Xtrabackup and primary keys in a galera cluster.

    Hi All,

    I hope your well.

    I have a question in regards to xtrabackup and the requires of tables with primary keys, I'm pretty sure I read up that primary keys are required for xtrabackup to function but I can't remember where that is why I have decided to ask here.

    I was looking at xtra dbcluster, but that looks like I would have to build a new cluster all together and then migrate data over which wouldn't be suitable, but I have been advised that xtrabackup it's self is a great tool for Galera clusters.

    Any advice would be awesome, as I need to look at getting this installed asap. Our cluster is monitored through the cluster control free version.

    Kindest Regards,

    Jammy :-)

  • #2
    Sorry for the bump, I was just wondering if anyone has any advice on this? :-) We have 1 table in our galera cluster with out primary keys, so just need advice as to whether or not xtrabackup requires them.


    • #3
      Hi James you might have been reading around PKs in general.

      First of all, for PXC to function correctly, you need PKs in place.

      Although you reference galera, PXC has that as its foundation.
      There's a relevant discussion here I think:

      It's a bit old but the SeveralNines blog seems to have some good content related to this

      Overall, I think we'd advise use of a primary key even if it's not functional.

      If I missed the point let me know and we can take another run at it. Thanks!