手把手交你mysql cluster 备份和恢复
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42. ndb_mgm> start backup ndb_mgm> shutdown ndb_mgm> exit 2、删掉SQL节点的数据。 DROP DATABASE TEST_CLUSTER; 3、关闭MYSQLD服务器。 [root@localhost bin]# service mysqld stop Shutting down MySQL... SUCCESS! 4、重新顺序启动所有节点。 [root@localhost mysql]#ndb_mgmd -f /etc/config.ini --reload [root@localhost data]#ndbd --initial 我发现如果不带这个 --initial选项的话,恢复会失败。 [root@localhost bin]# service mysqld start //我用的7.0.8a版rpm 安装<b>service mysqld start</b>无法启动,用、、 //[root@localhost ~]# mysqld_safe & 4、在NDBD节点上进行恢复。(每个节点都得执行一次,因为数据分散在两个节点上) 第一个节点: [root@localhost BACKUP]# /usr/local/mysql/bin/ndb_restore -n3 -b4 -r -m --backup_path=/usr/local/mysql/data/BACKUP/BACKUP-4/ -r开关是记录集合。 -m是元数据。就是表和库的SCHEMA。 Nodeid = 3 Backup Id = 4 backup path = /usr/local/mysql/data/BACKUP/BACKUP-4/ Ndb version in backup files: Version 5.1.21 Connected to ndb!! Successfully restored table `test_cluster/def/lk4_test` ... Successfully created index `PRIMARY` on `lk4_test` ... _____________________________________________________ Processing data in table: test_cluster/def/lk4_test54) fragment 1 _____________________________________________________ ... Restored 37 tuples and 0 log entries NDBT_ProgramExit: 0 - OK 第二个节点: [root@localhost BACKUP-1]# /usr/local/mysql/bin/ndb_restore -n4 -b4 -r --backup_path=/usr/local/mysql/data/BACKUP/BACKUP-4/ Nodeid = 4 Backup Id = 4
AIX backup and restore 2页 1下载券 MySQL Cluster Backup a... 5页 1...Nokia backup and restore 1 第 1 页共 4 页 Nokia backup and restore SOP...
Db2 backup and restore 11页 免费 AIX backup and restore 2页 2财富值 Nokia backup and restore 4页 10财富值 MySQL Cluster Backup and... 5页 2财富...
(1)第一个节点 ndb_restore -n2 -b5 -r -m --backup_path=/var/lib/mysql-clusterbak/BACKUP/BACKUP-5/ Nodeid = 2 Backup Id = 5 backup path ...
Nokia backup and resto... 4页 4下载券 MySQL Cluster Backup a... 5页...Operating System Managing Windows 2000 Disks, Backup and Restore Scenario ...
[root@test-db-20053 BACKUP-1]# /home/mysql-cluster-gpl-7.2.4-linux2.6-x86_64/bin/ndb_restore -e -c 10.100.200.36 -n 4 -b 1 -m --...
For more information, see Section 18.5.3, “Online Backup of MySQL Cluster”, and Section 18.4.19, “ndb_restore — Restore a MySQL Cluster Backup...
# TCP/IP options: [TCP DEFAULT] portnumber=3306 hosts in cluster # Note...ndb_restore) 五、启动 Mysql 集群服务 1、启动 MGM 管理节点(192.168.15....
在把主程序的数据库读写都切换到了 master 上以后,开始尝试恢复 MySQL Cluster 的状态。 继续之前,交代一下 MySQL Cluster 的配置:典型的 writer/reader。db01 ...
Db2 backup and restore 11页 免费 AIX backup and restore 2页 2财富值 Nokia backup and resto... 4页 10财富值 MySQL Cluster Backup a... 5页 2...
[mysql@sicloud-b200-3 BACKUP-1]$ ndb_restore -n sicloud-b200-3 -b 21 -r /home/mysql/my_cluster/ndb_data/BACKUP/BACKUP-1/ Unknown suffix 's...
热门文档