Buy Percona ServicesBuy Now!

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

Collapse
X
 
  • 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.

    Comment


    • #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. https://www.percona.com/doc/percona-...he-primary-key

      Although you reference galera, PXC has that as its foundation.
      There's a relevant discussion here I think: https://www.percona.com/forums/quest...galera-cluster

      It's a bit old but the SeveralNines blog seems to have some good content related to this https://severalnines.com/blog/simple...sing-s9sbackup

      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!

      Comment

      Working...
      X