Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the implementation process of backup and recovery of Mysql Cluster". In the daily operation, I believe that many people have doubts about the implementation process of backup and recovery of Mysql Cluster. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about the implementation process of backup and recovery of Mysql Cluster. Next, please follow the editor to study!

A) backup: use ndb_mgm management client to back up

Execute ndb_mgm in the management node to enter the management command line

Enter start backup to back up all nodes. If it is followed by the id of the corresponding data node, only the corresponding data node will be backed up

B) restore: use the command ndb_restore to restore, as follows:

Start the management node

/ usr/bin/ndb_mgmd-f / usr/local//mysql-cluster/config.ini-- reload

Start the data node:

/ usr/bin/ndbd-- initial

When the first node is restored

/ usr/bin/ndb_restore-c 192.168.100.223-n 11-b 1-m-r-- backup_path=/data/dbdata1/BACKUP/BACKUP-1/

When other nodes are restored (later nodes do not need to add-m parameter)

/ usr/bin/ndb_restore-c 192.168.100.223-n 11-b 1-r-backup_path=/data/dbdata1/BACKUP/BACKUP-1/

Among them, 192.168.100.223 is the IP,-n of the management node, followed by the backupid,-r data switch to be restored by the node id,-b, that is, to restore the data,-m restore the table structure.

After importing the table structure, you can restore it in parallel!

The mysqld node is needed for recovery, so you need to add multiple empty mysqld nodes, and the empty mysqld node should at least have the same data as your mysqld node.

When restoring hard disk tables, after initialization with-initial, there is no need to recreate data filegroups, redo log files, tablespaces and data files, but will be created automatically during restore

At this point, the study on "the implementation process of backup and recovery of Mysql Cluster" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.