Announcement

Announcement Module
Collapse
No announcement yet.

Best practice with XtraDB backups in a XtraDB Cluster environment.

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Best practice with XtraDB backups in a XtraDB Cluster environment.

    I have a three node cluster. Should we be performing XtraDB backups independently on each/all the nodes or designate a specific node ?

    Currently all transactions/connections are routed to ONLY node1. I am thinking of offloading the the XtraDB backup to node2 OR node3. But I can see that the binlog files on node1 are bigger in sizes which is as expected. Binlog for the other nodes are minimal. Do you see any issues/gotchas when performing point in time recovery using node2 or node3 full backups and binlog files?

    -Stevie
    Last edited by djstev1e; 07-08-2014, 04:19 PM.

  • #2
    Ok after testing further- looks like the answer in my case is that a point in time recovery will NOT be valid when backup is performed on node2 or node3 because the transactions performed on node1 are not recorded in the binlog files (node2 and node3). So in order to support point in time recovery I need to take the backup on node1 because node1 is where all transactions are performed.

    Now how would you handle point in time restore in a typical cluster setup where all transactions are spread out to all 3 nodes?

    Comment

    Working...
    X