yesterday,we have builded percona cluster which has three nodes in test box.and then we using mysqldump to backup one database data from mysql 5.5 in production box.after we got the sql file,it was 11G and have 30000 lines.we use command “mysql -uroot -p123456 dbname < mysql_dump.sql” to load the database file into percona cluster.actually,we have created a same dbname in percona cluster。
“CREATE DATABASE dbname DEFAULT CHARSET utf8 ".
ok,we run this command “mysql -uroot -p123456 dbname < mysql_dump.sql” in node1 ,Unluckily we got a crush issue in middle of it,and node1’s mysql service was crush,need start.we try to run command many times ,so we wonder that if the percona cluster not be allown import sql file which more than 1GB???but if we decide to use percona cluster in our production box,the first step it load the currentlly db data into percona cluster to keep moving our data.did someone help us??thx very much in advance !!