we are trying to bring up the percona xtradbcluster, whil;e bootstrapping the first node by this command:
/etc/init.d/mysql bootstrap-pxc we got output in terminal: * Bootstrapping Percona XtraDB Cluster database server mysqld [ OK ] But in log file ( /var/log/mysqld.log) we are getting this error: Access denied for user ‘UNKNOWN_MYSQL_USER’@‘localhost’ (using password: NO) please find me solution.
1 Like
im facing also this issue i have 2 node , the first Bootstrapping node was succesfully running
next when i tried on node 2 i got this messasge from /var/log/mysqld.log
Version: '5.7.34-37-57-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel37, Revision 99b8607, WSREP version 31.51, wsrep_31.51
2021-07-31T01:53:32.034039Z 2 [Note] WSREP: Initialized wsrep sidno 2
2021-07-31T01:53:32.034100Z 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 1)
2021-07-31T01:53:32.034124Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-07-31T01:53:32.034173Z 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4
2021-07-31T01:53:32.034342Z 0 [Note] WSREP: Service thread queue flushed.
2021-07-31T01:53:32.043386Z 2 [Note] WSREP: Synchronized with group, ready for connections
2021-07-31T01:53:32.043472Z 2 [Note] WSREP: Setting wsrep_ready to true
2021-07-31T01:53:32.043485Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-07-31T01:53:33.036955Z 11 [Note] Access denied for user **'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)**
my config
#
# The Percona XtraDB Cluster 5.7 configuration file.
#
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
# Please make any edits and changes to the appropriate sectional files
# included below.
#
[client]
port = 3306
#socket = /var/run/mysqld/mysqld.sock
[mysqld]
server-id = 101
#bind-address = 10.100.150.101
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld.sock
log-error = /var/log/mysqld.log
#pid-file = /var/run/mysqld/mysqld.pid
default_storage_engine = InnoDB
# BINARY LOGGING #
log_bin = /var/lib/mysql/mysql-bin
expire-logs-days = 3
sync-binlog = 1
slave-compressed-protocol = ON
binlog_format = row
relay_log_recovery = ON
relay-log = /var/lib/mysql/slave-relay.log
relay-log-index = /var/lib/mysql/slave-relay-log.index
relay-log-info-file = /var/lib/mysql/relay-log.info
log-slave-updates
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 15000
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 512M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 28G
# pmm slowquery#
log_output=file
#slow_query_log=ON
#long_query_time=1
#slow_query_log_use_global_control=all
innodb_monitor_enable=all
userstat=on
# Path to Galera library
# Path to Galera library
wsrep_provider = /usr/lib/galera3/libgalera_smm.so
wsrep_cluster_address = gcomm://172.18.80.100,172.18.80.101
wsrep_slave_threads = 8
wsrep_log_conflicts
innodb_autoinc_lock_mode = 2
wsrep_node_address = 172.18.80.101
wsrep_cluster_name = DR
wsrep_node_name = Prod-mysql02-DR
pxc_strict_mode = PERMISSIVE
wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = sstuser:exeik3Maiye1Tee
[mysqldump]
quick
quote-names
max_allowed_packet = 500M
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/percona-xtradb-cluster.conf.d/
sync data from node 1 was stopped because those error ,
OS = Ubuntu 18.04.5 LTS
fyi : on node 1 already has data that i got from innobackupex , the user sstuser already existing on that data
really appreaciate your help ,
regards,
lookman
1 Like
i know was the problem is , on node 2 i need to get the original file/folder mysql from the origin node that i get the backup , i just get copied all file from the original source put it on node 2 and node 3, sync data from node 1 to node 2 n node 3 are succesfully i do it this one by one after node 2 finish next sync to node 3 without failing
1 Like