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

If you want to learn the highly available architecture of PXC, please leave me a message.

The error on the first node of PXC startup is as follows:

2019-08-12T03:24:10.282944Z 0 [Note] WSREP: Current view of cluster as seen by this nodeview ((empty)) 2019-08-12T03:24:10.283160Z 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait_prim_timeout): 110 (Connection timed out) at gcomm/src/pc.cpp:connect (): 1592019-08-12T03:24:10.283195Z 0 [ERROR] WSREP: gcs/src/gcs_core. Cpp:gcs_core_open (): 209: Failed to open backend connection:-110 (Connection timed out) 2019-08-12T03:24:10.283350Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open (): 1514: Failed to open channel 'pxc_cluster' at' gcomm://196.55.7.33:4106196.55.7.34:4106196.55.7.35:4106':-110 (Connection timed out) 2019-08-12T03:24:10.283372Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out2019-08-12T03:24:10.283391Z 0 [ERROR] WSREP: Provider/Node (gcomm://196.55.7.33:4106196.55.7.34:4106196.55.7.35:4106) failed to establish connection with cluster (reason: 7) 2019-08-12T03:24:10.283402Z 0 [ERROR] Aborting2019-08-12T03:24:10.283412Z 0 [Note] Giving 0 client threads a chance to die gracefully2019-08-12T03:24: 10.283424Z 0 [Note] WSREP: Waiting for active wsrep applier to exit

Solution method

Add a parameter-- wsrep-new-cluster

[root@localhost 3306] #. / mysql.server-P 3306 start-- wsrep-new-cluster Starting MySQL (Galera Cluster). SUCCESS! [root@localhost 3306] #

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.