MySQL Forums
Forum List  »  NDB clusters

ndb cluster 7.5 incremental backup
Posted by: Ryan tse
Date: May 02, 2018 03:15AM

Hi all, may I ask the ndb cluster 7.5 whether support incremental backup,
beside to test full backup restore, I'd like to test PITR
I cannot find any binary log from that, even two tables(mysql.ndb_apply_status,mysql.ndb_binlog_index) no any records.
Could u pls to help or any config setting need to enable, many thx.

--------------------------------------------------------------------
mysql> SELECT Position, @FIRST_FILE:=File
-> FROM mysql.ndb_binlog_index
-> WHERE epoch > @LATEST_EPOCH ORDER BY epoch ASC LIMIT 1;
Empty set (0.00 sec)
--------------------------------------------------------------------
mysql> SELECT @LATEST_EPOCH:=MAX(epoch)
-> FROM mysql.ndb_apply_status;
+---------------------------+
| @LATEST_EPOCH:=MAX(epoch) |
+---------------------------+
| NULL |
+---------------------------+
--------------------------------------------------------------------
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.124.181 (mysql-5.7.21 ndb-7.5.9, Nodegroup: 0)
id=3 @192.168.124.182 (mysql-5.7.21 ndb-7.5.9, Nodegroup: 0, *)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.124.224 (mysql-5.7.21 ndb-7.5.9)

[mysqld(API)] 6 node(s)
id=4 @192.168.124.135 (mysql-5.7.21 ndb-7.5.9)
id=5 @192.168.124.136 (mysql-5.7.21 ndb-7.5.9)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)

Options: ReplyQuote


Subject
Views
Written By
Posted
ndb cluster 7.5 incremental backup
45
May 02, 2018 03:15AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.