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