下载地址:
[root@k8s01 ~] # ps ef | grep mysql
root ,,,,60672,54285,0 14:56分/1,,,就是tailf/var/log/mysqld.log
root ,,,,66031,,,,,1,0 15:03 ?,,,,,,,就是/bin/sh/usr/bin/mysqld_safe——basedir=/usr ——wsrep-new-cluster
mysql ,,,66568,66031,6日15:03 ?,,,,,,,00:00:01/usr/sbin/mysqld——basedir=/usr datadir=/var/lib/mysql——plugin-dir=/usr/lib64/mysql/插件——用户=mysql wsrep-provider=/usr/lib64/galera3/libgalera_smm。所以——wsrep-new-cluster日志错误=
/var/log/mysqld。日志——pid文件=/var/run/mysqld/mysqld。pid——套接字=/var/lib/mysql/mysql。袜子——wsrep_start_position=00000000-0000-0000-0000-000000000000: 1 root ,,,,66763,33815,0 15:04分/0,,,就是grep——颜色=汽车mysql
[root@k8s01 ~] # mysql - u root - p # 39;是的;- t * taM8T<& # 39;
mysql(警告):使用一个密码alt="字符集中间件实现Percona集群集群读写分离”>
(1)。查看管理端口服务
2019 - 11 - 15 - t06:33:04.385687z 0(错误)流产
2019 - 11 - 15 t06:41:35.761309z 0(错误)WSREP: gc/src/gcs_core.cpp: gcs_core_open(): 209:未能打开后端连接:-110(连接超时)
2019 - 11 - 15 t06:41:35.761583z 0(错误)WSREP: gc/src/gcs.cpp: gcs_open(): 1514:未能明渠& # 39;pxc_1& # 39;& # 39;gcomm://192.168.54.128,192.168.54.129,192.168.54.130& # 39;: -110(连接超时)
2019 - 11 - 15 t06:41:35.761597z 0(错误)WSREP: gcs连接失败:连接超时
2019 - 11 - 15 t06:41:35.761600z 0(错误)WSREP:供应商/节点(gcomm://192.168.54.128,192.168.54.129,192.168.54.130)未能与集群建立连接(原因:7)
2019 - 11 - 15 - t06:41:35.761603z 0(错误)流产
修复& # 39;& # 39;——mysqld-version & # 39; 5.7.27-30-57& # 39;,,& # 39;& # 39;——gtid & # 39; 19 a21dce - 0776 - 11 - ea - 8879 - 92 - a989219bb1:2& # 39; 2019 - 11 - 15 - t07:27:59.159302z 0[警告]WSREP:违反协议。加入消息发送者0.0 (k8s01)不在状态传输(同步)。消息被忽略。
2019 - 11 - 15 - t07:27:59.159405z 5[注]WSREP:同步组,准备连接
查询好,0行影响,1警告(0.05秒)