Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Several nodes in docker went down unexpectedly. Pxc failed to start.

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Docker is down unexpectedly, and PXC can't start the solution.

Due to unexpected downtime of the docker start pxc node, the solution is as follows

Find any data volume mapping directory from the node and modify the parameters

[root@izuf64gdegum84eku07pljz ~] # docker volume × × pect v1 [{"CreatedAt": "2019-06-14T13:13:17+08:00", "Driver": "local", "Labels": {}, "Mountpoint": "/ var/lib/docker/volumes/v1/_data", "Name": "v1", "Options": {}, "Scope": "local"}]

Modify the grastate.dat configuration file (this is a special security mechanism for data consistency synchronization in pxc clusters)

# GALERA saved stateversion: 2.1uuid: f5cf24ff-8e62-11e9-a3b5-df56c6b933c6seqno:-1safe_to_bootstrap: 1 / / change here to 1 start node to docker start pxc node

Note:

Method 1:

PXC clusters are unavailable only when more than half of the nodes are down. This is to avoid deploying PXC clusters in remote computer rooms. Due to network failures, a PXC cluster is split into two clusters. So it's okay to hang up one or two nodes, as long as there are no more than half of the nodes.

Method 2: you can also delete containers and data volumes and recreate them, because the data volumes on the host will not be deleted, re-create containers for mapping, and the data will not be lost.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report