Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite
1

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.

share|improve this question
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

1 Answer

up vote 2 down vote accepted

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>
share|improve this answer
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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