# 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
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)
# dpkg -l | grep percona 1.precise Open source backup tool for InnoDB and XtraDB xtradb- cluster- 56 5.6.19- 25.6-824. precise Percona XtraDB Cluster with Galera xtradb- cluster- client- 5.6 5.6.19- 25.6-824. precise Percona XtraDB Cluster database client binaries xtradb- cluster- common- 5.6 5.6.19- 25.6-824. precise Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf) xtradb- cluster- galera- 3 3.6.3190.precise Metapackage for latest version of galera3. xtradb- cluster- galera- 3.x 3.6.3190.precise Galera components of Percona XtraDB Cluster xtradb- cluster- server- 5.6 5.6.19- 25.6-824. precise Percona XtraDB Cluster database server binaries
ii percona-xtrabackup 2.2.3-4982-
ii percona-
ii percona-
ii percona-
ii percona-
ii percona-
ii percona-
# cat my.cnf info_repository = TABLE info_repository = TABLE mysql/mysql- bin /var/lib/ mysql
[mysqld]
master_
relay_log_
relay_log_recovery = 1
server_id = 100
log-bin = /var/lib/
binlog-format = MIXED
datadir=
mysql> show global variables like '%wsrep%'; ------- ------- ------- ------+ ------- ------- ------- ------- ------- ------+ ------- ------- ------- ------+ ------- ------- ------- ------- ------- ------+ ------- ------- ------- ------+ ------- ------- ------- ------- ------- ------+
+------
| Variable_name | Value |
+------
| wsrep_on | ON |
| wsrep_preordered | OFF |
| wsrep_provider | none |
+------
* restart mysqld HOST='10. 1.1.1', MASTER_ USER='replica' ,MASTER_ PASSWORD= 'replica' , MASTER_ LOG_FILE= 'bin.00001' , MASTER_LOG_POS=1;
* start dummy slave (no real master needed):
mysql> CHANGE MASTER TO MASTER_
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.