MySQL Forums
Forum List  »  NDB clusters

mysqldump data recovery error
Posted by: 陈 jim
Date: April 17, 2021 06:51PM

"hello everyone"

"I'm going to import the data of mysql-cluster-8.0.23-linux-glibc2.12 into mysql-cluster-gpl-7.4.4-linux-glibc2.5, but it will terminate with an error in the middle of the import"

"My operation steps:"
"the first step"
"In mysql-cluster-8.0.23-linux-glibc2.12"
"/usr/local/mysql/bin/mysqldump -h172.16.9.21 -P3306 -uroot -p123456 --add-locks=FALSE --net-buffer-length=4096 database_name > database_name.sql"

"Step two"
"In mysql-cluster-gpl-7.4.4-linux-glibc2.5"
"/usr/local/mysql/bin/mysql -h172.16.9.21 -P3306 -uroot -p123456 database_name < database_name.sql"

"Console error:"
"ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction"

"config.ini"

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=3 # Number of replicas
# Amount of memory required=(SizeofDatabase * NumberOfReplicas * 1.1 ) / NumberO fDataNodes
DataMemory=12000M # How much memory to allocate for data storage
IndexMemory=2000M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
MaxNoOfTables=1024
MaxNoOfAttributes=50000
MaxNoOfOrderedIndexes=100000
MaxNoOfUniqueHashIndexes=100000
#Transaction Parameters
MaxNoOfConcurrentTransactions: 1000000
MaxNoOfConcurrentOperations: 3000000
MaxNoOfLocalOperations: 5000000
TransactionInactiveTimeout =600000
[tcp default]
portnumber=2202


[ndb_mgmd]
nodeid=1
hostname=172.16.9.22
datadir=/var/lib/mysql-cluster

[ndb_mgmd]
nodeid=2
hostname=172.16.9.23
datadir=/var/lib/mysql-cluster
[ndbd]
nodeid=11
hostname=172.16.9.21
datadir=/usr/local/mysql/data
[ndbd]
nodeid=12
hostname=172.16.9.22
datadir=/usr/local/mysql/data
[ndbd]
nodeid=13
hostname=172.16.9.23
datadir=/usr/local/mysql/data
[mysqld]
nodeid=81
hostname=172.16.9.21

[mysqld]
nodeid=82
hostname=172.16.9.22

[mysqld]
nodeid=83
hostname=172.16.9.23
[mysqld]
nodeid=84

"my.cnf"

[mysqld]
sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_connections=2000
symbolic-links=0
skip-name-resolve
tmp_table_size = 512M
max_heap_table_size = 512M
ndbcluster
key_buffer_size = 384M
max_allowed_packet = 300M
sort_buffer_size = 6M
read_buffer_size = 6M
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql_cluster]
ndb-connectstring=172.16.9.21
[mysqld]

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump data recovery error
223
April 17, 2021 06:51PM


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.