Not the answer you need?
Register and ask your own question!

Cannot start second server in cluster

llowryllowry EntrantInactive User Role Beginner
Using Ubuntu server 14.04.1 and Percona XtraDB Cluster 5.6.xxx.
I have the mysql service running on each server.
I moved the datadir to a second SSD Drive (more space and faster)
Checked that the servie works, Ok.

The first node bootstraps fine. But the second and third servers fail to start.
It appears to be the WSREP failing to get the initial data transfer from the first server.

Go to first server and run (from the manual)
innobackupex --user=username --password=password /tmp/

This fails with the following:
09:03:24 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','username',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr/bin/innobackupex line 2949.

I have a feeling it is because I moved the datadir, but it is correct in the my.cnf.
Anyone with an idea?

Thanks.

Larry

[mysqld]
datadir=/data/mysql/mysql/
user=mysql

log_error = /data/mysql

#Skip reverse DNS lookup of clients
skip-host-cache
skip-name-resolve

wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_cluster_address=gcomm://
wsrep_cluster_address=gcomm://192.168.90.140,192.168.90.141,192.168.90.142

max_connections=1000
max_connect_errors=100
max_allowed_packet= 32M
max-heap-table-size = 32M
tmp-table-size = 32M
thread_cache_size = 2000
open-files-limit = 65535

log_bin_use_v1_row_events=1
gtid_mode=0
binlog_checksum=NONE
binlog_format=ROW
default_storage_engine=InnoDB
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_buffer_pool_size=5G
innodb_log_file_size=256M
#innodb_log_buffer_size=50M

wsrep_node_address=192.168.90.140
wsrep_sst_method=xtrabackup
wsrep_cluster_name=prodrr
wsrep_sst_auth="username:password"

slow_query_log = 'ON'
long_query_time = 2
log-queries-not-using-index = YES

Comments

  • tkauppintkauppin Entrant Inactive User Role Beginner
    'Access denied' is likely because incorrect password. Maybe the easiest way is to run password update to the user 'root'@'localhost' and retry.
  • llowryllowry Entrant Inactive User Role Beginner
    Finally figured it out. The username for the replication evidently has to be [email protected]

    We had it set for [email protected]%.

    Larry
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.