mysql> show global variables like '%version%';
+-------------------------+---------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+---------------------------------------------------------------------------------------------------+
| innodb_version | 5.6.20-68.0 |
| protocol_version| 10|
| slave_type_conversions | |
| version | 5.6.20-68.0-56 |
| version_comment | Percona XtraDB Cluster (GPL), Release rel68.0, Revision 886, WSREP version 25.7, wsrep_25.7.r4126 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+---------------------------------------------------------------------------------------------------+
[root@centos3 mysql]# iptables -A INPUT -p tcp --destination-port 4444 -j DROP && iptables -A OUTPUT -p tcp --destination-port 4444 -j DROP
[root@centos3 mysql]# /etc/init.d/mysql start
Starting MySQL (Percona XtraDB Cluster)....State transfer in progress, setting sleep higher
....... ERROR! The server quit without updating PID file (/var/lib/mysql/centos3.bm.int.percona.com.pid).
ERROR! MySQL (Percona XtraDB Cluster) server startup failed!
[mysqld] method= xtrabackup- v2 timeout= 1
# SST method
wsrep_sst_
[SST]
sst-initial-
mysql> show global variables like '%version%'; ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + conversions | | compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- +
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.20-68.0 |
| protocol_version| 10|
| slave_type_
| version | 5.6.20-68.0-56 |
| version_comment | Percona XtraDB Cluster (GPL), Release rel68.0, Revision 886, WSREP version 25.7, wsrep_25.7.r4126 |
| version_
| version_compile_os | Linux |
+------
[root@centos3 mysql]# iptables -A INPUT -p tcp --destination-port 4444 -j DROP && iptables -A OUTPUT -p tcp --destination-port 4444 -j DROP
[root@centos3 mysql]# /etc/init.d/mysql start mysql/centos3. bm.int. percona. com.pid) .
Starting MySQL (Percona XtraDB Cluster)....State transfer in progress, setting sleep higher
....... ERROR! The server quit without updating PID file (/var/lib/
ERROR! MySQL (Percona XtraDB Cluster) server startup failed!
[root@centos3 ~]# iptables -F
[root@centos3 mysql]# ps -ef | grep mysql wsrep_sst_ xtrabackup- v2 --role joiner --address 10.0.3.172 --auth irfan:irfan --datadir /var/lib/mysql/ --defaults-file /etc/my.cnf --parent 3604 4444,reuseaddr stdio 4444,reuseaddr stdio
mysql 3618 1 0 02:27 pts/0 00:00:00 /bin/bash -ue /usr//bin/
mysql 3833 3618 0 02:27 pts/0 00:00:00 timeout 1 socat -u TCP-LISTEN:
mysql 3834 3618 0 02:27 pts/0 00:00:00 xbstream -x
mysql 3835 3833 0 02:27 pts/0 00:00:00 socat -u TCP-LISTEN:
root 3875 1855 0 02:30 pts/0 00:00:00 grep mysql