Mysql

Percona XtraDB Cluster:啟動時如何跳過 SST?

  • July 21, 2017

有沒有辦法在 Percona XtraDB Cluster Server 上啟動時跳過狀態快照傳輸(SST)?

wsrep_sst_mode=skip不起作用:

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

我正在使用 Percona-XtraDB-Cluster-server-5.5.27-23.6.356.rhel5。

我想你wsrep_sst_method=skip不想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>

引用自:https://dba.stackexchange.com/questions/25320