2

Is there a way to skip State Snapshot Transfer (SST) at startup on Percona XtraDB Cluster Server?

wsrep_sst_mode=skip doesn't work:

121003  6:49:55 Percona XtraDB (http://www.percona.com) 1.1.8-rel28.1 started; 
    log sequence number 82208067084
121003  6:49:55 [ERROR] /usr/sbin/mysqld: unknown variable 'wsrep_sst_mode=skip'
121003  6:49:55 [ERROR] Aborting

I'm using Percona-XtraDB-Cluster-server-5.5.27-23.6.356.rhel5.

  • Are you talking about when adding a node? Perhaps this page has your answer? mysqlperformanceblog.com/2012/08/02/… – Max Vernon Oct 3 '12 at 0:03
  • @MaxVernon: Yes. I know that link but what happens if the backup is not performed by xtrabackup? Assumming that my data on the donor and joiner is the same, how do I skip SST when starting the joiner? – quanta Oct 3 '12 at 0:08
  • unfortunately, I do not know much about XtraDB. Can you not use xtrabackup for some reason? – Max Vernon Oct 3 '12 at 0:12
  • 1
    I have restored the backup that performed by mysqldump. The question still remains in case I need to restart the joiner. – quanta Oct 3 '12 at 0:14
3

I think you want wsrep_sst_method=skip not wsrep_sst_mode=skip

mysql> show variables like 'wsrep_sst%';
+---------------------------+------------+
| Variable_name             | Value      |
+---------------------------+------------+
| wsrep_sst_auth            |            |
| wsrep_sst_donor           |            |
| wsrep_sst_method          | xtrabackup |
| wsrep_sst_receive_address | AUTO       |
+---------------------------+------------+
4 rows in set (0.00 sec)

mysql>
  • You're right. Is this document wrong? – quanta Oct 3 '12 at 1:45
  • Yup, it's wrong. I have that same PDF from the Webinar. This is a guess, but maybe earlier versions of Galera may have had mode, or maybe it's just wrong. – RolandoMySQLDBA Oct 3 '12 at 1:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.