Comment 2 for bug 1313756

Revision history for this message
Muhammad Irfan (muhammad-irfan) wrote :

# dpkg -l | grep percona
ii percona-xtrabackup 2.2.3-4982-1.precise Open source backup tool for InnoDB and XtraDB
ii percona-xtradb-cluster-56 5.6.19-25.6-824.precise Percona XtraDB Cluster with Galera
ii percona-xtradb-cluster-client-5.6 5.6.19-25.6-824.precise Percona XtraDB Cluster database client binaries
ii percona-xtradb-cluster-common-5.6 5.6.19-25.6-824.precise Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
ii percona-xtradb-cluster-galera-3 3.6.3190.precise Metapackage for latest version of galera3.
ii percona-xtradb-cluster-galera-3.x 3.6.3190.precise Galera components of Percona XtraDB Cluster
ii percona-xtradb-cluster-server-5.6 5.6.19-25.6-824.precise Percona XtraDB Cluster database server binaries

# cat my.cnf
[mysqld]
master_info_repository = TABLE
relay_log_info_repository = TABLE
relay_log_recovery = 1
server_id = 100
log-bin = /var/lib/mysql/mysql-bin
binlog-format = MIXED
datadir=/var/lib/mysql

mysql> show global variables like '%wsrep%';
+---------------------------------+-----------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------+
| wsrep_on | ON |
| wsrep_preordered | OFF |
| wsrep_provider | none |
+---------------------------------+-----------------------------------------+

* restart mysqld
* start dummy slave (no real master needed):
mysql> CHANGE MASTER TO MASTER_HOST='10.1.1.1',MASTER_USER='replica',MASTER_PASSWORD='replica', MASTER_LOG_FILE='bin.00001', MASTER_LOG_POS=1;
Query OK, 0 rows affected, 2 warnings (0.10 sec)

mysql> start slave;
Query OK, 0 rows affected (0.04 sec)

* restarted mysql 2-3 times and no crashes.