I am using Percona XtraDB Cluster 5.5.34-25.9. When I set the wsrep_sst_donor using CNAME(mymisc2db2.db.stratus.com) instead of hostname, it failed to state transfer with the error
140505 15:13:35 [ERROR] WSREP: Requesting state transfer failed: -113(No route to host)
140505 15:13:35 [ERROR] WSREP: State transfer request failed unrecoverably: 113 (No route to host). Most likely it is due to inability to communicate with the cluster primary component. Restart required.
If I change the host name(slc4b01c-713813.stratus.slc.com) instead, it works well .
Can someone help check why I can’t use canonical name as wsrep_sst_donor? How can I troubleshooting this?
Thanks for your help in advance.