Percona Cluster Iniialization

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

When trying to initialize the MySQL Percona Cluster, I get the following error (this is prior to attempting to bootstrap the first node):

/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/db01/mysql01/data --basedir=/usr/local/mysql
2022-01-13T15:31:12.701519Z 0 [Warning] [MY-011070] [Server] ‘Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it’ is deprecated and will be removed in a future release.
2022-01-13T15:31:12.701689Z 0 [Warning] [MY-000000] [WSREP] Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks
2022-01-13T15:31:12.703109Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.25-15.1) initializing of server in progress as process 16914
2022-01-13T15:31:12.706028Z 0 [ERROR] [MY-010187] [Server] Could not open file ‘/db01/mysql01/logs/mysql01.err’ for error logging: No such file or directory
2022-01-13T15:31:12.706096Z 0 [ERROR] [MY-013236] [Server] The designated data directory /db01/mysql01/data/ is unusable. You can remove all files that the server added to it.
2022-01-13T15:31:12.706108Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-01-13T15:31:12.706311Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.25-15.1) Percona XtraDB Cluster binary (GPL) 8.0.25, Revision 8638bb0, WSREP version 26.4.3.

Can someone please help?
Thanks
Jim

1 Like
2

Hi @jimbo881 , welcome to the Percona forums!

Please check whether there are already files in the /db01/mysql01/data directory. Please ensure this directory is empty before executing the bootstrap operation.

1 Like
3

I played around with it some more and finally got everything in the proper place. We use the tarball for installs and some libraries needed to be moved around along with some other missing stuff. But it is up and running now…

Thanks for the response!
Jim

2 Likes