揭阳网站建设维护,商业网站平台,南通做网站ntwsd,东营网红桥欢迎关注MySQL 8.0必知必会系列课程。MySQL8.0必知必会-自动化部署 https://edu.51cto.com/course/16368.htmlMySQL8.0必知必会之参数标准化配置 https://edu.51cto.com/course/16358.html1.Cant start server: Bind on TCP/IP port: Address already in use… 欢迎关注MySQL 8.0必知必会系列课程。 MySQL8.0必知必会-自动化部署 https://edu.51cto.com/course/16368.html MySQL8.0必知必会之参数标准化配置 https://edu.51cto.com/course/16358.html1.Cant start server: Bind on TCP/IP port: Address already in use2017-12-07T10:25:56.21630908:00 0 [ERROR] Cant start server: Bind on TCP/IP port: Address already in use2017-12-07T10:25:56.21632408:00 0 [ERROR] Do you already have another mysqld server running on port: 22308 ?2017-12-07T10:25:56.21634008:00 0 [ERROR] Aborting故障处理主要是改参数设置有问题参数为wsrep_node_address192.168.192.65:22308正确设置为wsrep_node_address192.168.192.652.It may not be safe to bootstrap the cluster from this node2017-12-15T13:11:30.23713908:00 0 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the updates.To force cluster bootstrap with this node, edit the grastate.dat file manually and set safe_to_bootstrap to 1 .2017-12-15T13:11:30.23714808:00 0 [ERROR] WSREP: Provider/Node (gcomm://10.66.192.65:4567,10.66.192.66:4567,10.66.192.67:4567) failed to establish connection with cluster (reason: 7)2017-12-15T13:11:30.23715808:00 0 [ERROR] Aborting故障处理集群本身无问题只是非正常关闭。修改第一个启动节点的grastate.dat文件将# GALERA saved stateversion: 2.1uuid: 8ed447b7-dafa-11e7-8071-a6ba78498531seqno: -1safe_to_bootstrap: 0 改为 1然后可以直接启动3.Error in Log_event::read_log_event(): read error2017-12-15T15:16:35.19558608:00 0 [ERROR] Error in Log_event::read_log_event(): read error, data_len: 11730978, event_type: 512017-12-15T15:16:35.19560608:00 0 [Warning] Error reading GTIDs from binary log: -1故障处理binlog参数设置过长导致无法正确生成binlog和正常的读取log-bin /data/mysql/db_test1/binlog/192.168.10.128_test1_binlog-bin-index/data/mysql/db_test1/binlog/192.168.10.128_test1_bin.index-rw-r--r-- 1 mysql mysql 177 Dec 15 15:19 192.168.10-rw-r--r-- 1 mysql mysql 40 Dec 15 15:17 192.168.10.128_test1_bin.index 转载于:https://blog.51cto.com/14136767/2334489
