Movatterモバイル変換

It is possible in NDB 8.0 to take a backup with multiple local data managers (LDMs) acting in parallel on the data nodes. For this to work, all data nodes in the cluster must use multiple LDMs, and each data node must use the same number of LDMs. This means that all data nodes must runndbmtd (ndbd is single-threaded and thus always has only one LDM) and they must be configured to use multiple LDMs before taking the backup;ndbmtd by default runs in single-threaded mode. You can cause them to use multiple LDMs by choosing an appropriate setting for one of the multi-threaded data node configuration parametersMaxNoOfExecutionThreads orThreadConfig. Keep in mind that changing these parameters requires a restart of the cluster; this can be a rolling restart. In addition, theEnableMultithreadedBackup parameter must be set to 1 for each data node (this is the default).

Depending on the number of LDMs and other factors, you may also need to increaseNoOfFragmentLogParts. If you are using large Disk Data tables, you may also need to increaseDiskPageBufferMemory. As with single-threaded backups, you may also want or need to make adjustments to settings forBackupDataBufferSize,BackupMemory, and other configuration parameters relating to backups (seeBackup parameters).

Once all data nodes are using multiple LDMs, you can take the parallel backup using theSTART BACKUP command in the NDB management client just as you would if the data nodes were runningndbd (orndbmtd in single-threaded mode); no additional or special syntax is required, and you can specify a backup ID, wait option, or snapshot option in any combination as needed or desired.

Backups using multiple LDMs create subdirectories, one per LDM, under the directoryBACKUP/BACKUP-backup_id/ (which in turn resides under theBackupDataDir) on each data node; these subdirectories are namedBACKUP-backup_id-PART-1-OF-N/,BACKUP-backup_id-PART-2-OF-N/, and so on, up toBACKUP-backup_id-PART-N-OF-N/, wherebackup_id is the backup ID used for this backup andN is the number of LDMs per data node. Each of these subdirectories contains the usual backup filesBACKUP-backup_id-0.node_id.Data,BACKUP-backup_id.node_id.ctl, andBACKUP-backup_id.node_id.log, wherenode_id is the node ID of this data node.

ndb_restore automatically checks for the presence of the subdirectories just described; if it finds them, it attempts to restore the backup in parallel. For information about restoring backups taken with multiple LDMs, seeSection 25.5.23.3, “Restoring from a backup taken in parallel”.

To force creation of a single-threaded backup that can easily be imported byndb_restore from an NDB release prior to 8.0, you can setEnableMultithreadedBackup = 0 for all data nodes (you can do this by setting the parameter in the[ndbd default] section of theconfig.ini global configuration file). It is also possible to restore a parallel backup to a cluster running an older version ofNDB. SeeSection 25.5.23.1.1, “Restoring an NDB backup to a previous version of NDB Cluster”, for more information.