Node1 bootstrap correctly but node 2 unable to join node1

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Node1 bootstrap correctly but node to unable to join node1, Getting below error
I am using mysqld users rather than root user to setting up this cluster.

=========
2021-05-20T15:40:58.136375Z 0 [Note] [MY-000000] [WSREP-SST] Waiting for server instance to start… This may take some time

2021-05-20T15:40:59.199089Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************

2021-05-20T15:40:59.200930Z 0 [ERROR] [MY-000000] [WSREP-SST] Failed to execute mysql ‘SHOW SLAVE STATUS’. Check the parameters and retry

2021-05-20T15:40:59.200947Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 861 errcode:1

2021-05-20T15:40:59.200972Z 0 [ERROR] [MY-000000] [WSREP-SST] ------------ show slave status log (START) ------------

ERROR 2003 (HY000): Can’t connect to MySQL server on ’ (111)

2021-05-20T15:40:59.200988Z 0 [ERROR] [MY-000000] [WSREP-SST] ------------ show slave status log (END) ------------

2021-05-20T15:40:59.201950Z 0 [ERROR] [MY-000000] [WSREP-SST] ------------ mysql error log (START) ------------

---- Starting the MySQL server used for post-processing ----

2021-05-20T15:40:58.370855Z 0 [Warning] [MY-010915] [Server] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2021-05-20T15:40:58.370966Z 0 [Warning] [MY-000000] [WSREP] Node is not a cluster node. Disabling pxc_strict_mode

2021-05-20T15:40:58.372264Z 0 [System] [MY-010116] [Server] /home/mysqld/sys/8.0.22_percona_XtraDB/bin/mysqld (mysqld 8.0.22-13.1) starting as process 33206

2021-05-20T15:40:58.401633Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2021-05-20T15:40:58.791578Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

1 Like
2

Hi @Soumyaranjan_Sahani,

Anyways, I’m not sure what you are trying to do. You should bootstrap the FIRST NODE only. Then, after that starts, start node2 normally. It should join node1. wsrep_cluster_address should be the same on node1 and node2. When you make this empty string, it will always bootstrap which is what you DO NOT want to happen.

1 Like
4

Did you copy the SSL certificates from node1 over to node2 before starting? SSL is on by default now.

1 Like
6

Plz share steps how i can bootstrap with mysqld OS user rather than root .

1 Like
7

Hi @Soumyaranjan_Sahani ,
Typically, MySQL/PXC do not run as the root user. You may need to be root in order to run systemctl commands, but they run as the ‘mysql’ system user. True, they start out as root but then fall down to ‘mysql’. If you have the ability to su to the mysql user, you can do that then start mysqld manually, though this is not a recommended way, nor best-practice. Do you have SELinux enabled? This must be disabled for PXC. I will need to see more of your error logs to be of further assistance.

1 Like
8

SELinux is set to permissive

1 Like
9

Using the mysqld user, are you able to run “show slave status” on Node1 from localhost? Maybe a grant is missing.

1 Like
11

Closing, no replies from OP.

1 Like