(mysql.info.gz) MySQL Cluster Backup Concepts

(mysql.info.gz) MySQL Cluster Backup

(mysql.info.gz) MySQL Cluster Backup Using Management Server

 
 16.5.4.1 Cluster Backup Concepts
 ................................
 
 A backup is a snapshot of the database at a given time.  The backup
 contains three main parts:
 
   1. Meta data (what tables exists etc)
 
   2. Table records (data in tables)
 
   3. A log of committed transactions
 
 Each of these parts is saved on all nodes participating in a backup.
 
 During backup each node saves these three parts to disk into three
 files:
 
 `BACKUP-<BackupId>.<NodeId>.ctl'
      The control file which contain control information and meta data.
 
 `BACKUP-<BackupId>-0.<NodeId>.data'
      The data file that contain the table records.
 
 `BACKUP-<BackupId>.<NodeId>.log'
      The log file that contain the committed transactions.
 
 Above <BackupId> is an identifier for the backup and <NodeId> is the
 node id of the node creating the file.
 
 *Meta data*
      The meta data consists of table definitions. All nodes have the
      exact same table definitions saved on disk.
 
 *Table records*
      The table records are saved per fragment. Each fragment contains a
      header that describes which table the records belong to.  After the
      list of records there is a footer that contains a checksum for the
      records. Different nodes save different fragments during the
      backup.
 
 *Committed log*
      The committed log contains committed transaction made during the
      backup.  Only transactions on tables stored in the backup are
      stored in the log.  The different nodes in the backup saves
      different log records as they host different database fragments.

Info Catalog

(mysql.info.gz) MySQL Cluster Backup

(mysql.info.gz) MySQL Cluster Backup Using Management Server

automatically generated byinfo2html