I have a configuration like this:
datadir=/usr/local/sg/mysql/data/mysql
I have tables set up in tablespaces such as
/usr/local/sg/mysqldata/lportal
/usr/local/sg/mysqldata/sample
etc
Each database in my installation lives on a separate logical volume
A typical table statement will include DATA DIRECTORY=‘/usr/local/sg/mysqldata/services/’; - the database lives in /usr/local/sg/mysqldata/services/services
My problem comes in that when trying to bring the other two servers online I have tried:
xtradbbackup_v2 – basically remove everything from the datadir and starting mysql … this causes various errors when syncing but does create the .frm and .isl files.
When I set the datadir to /usr/local/sg/mysqldata it does create the services directory and puts the ibd, isl and frm files there … however on my “real” servers my directory structure is (example)
/dev/mapper/VolGroup03-LogVol00 …. /usr/local/sg/mysqldata/services
Q - So my question is … with datadir pointed at /usr/local/sg/mysqldata will xtradbbackup load the data into the actual data dir locations? (see DATA DIRECTORY statement above)
I am unable to get rsync to replicate data under any circumstance in this configuration as well.
I need to be able to exactly replicate my initial node configuration.
Any suggestions?
My wsrep parameters are
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_slave_threads=8
wsrep_cluster_name=xxxxxxxx
#wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=xxxx:xxxx
#wsrep_sst_method=rsync
wsrep_node_name=xxxxxxxx
wsrep_node-address=
wsrep_provider_options = ‘socket.checksum = 1;’
wsrep_cluster_address=gcomm://<node 1>
I also find it interesting that even though my software appears to be the most recent … I can only get it to run with socket.checksum=1 set .